It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×12,002
×1,235

question asked: Jun 21 '12, 11:12 a.m.
question was seen: 10,048 times
last updated: Jun 21 '12, 2:32 p.m.

Related questions

how to retrieve values from a multiple select text box prompt

0
Tapasya Bhaskar (1●2●2) | asked Jun 21 '12, 11:12 a.m.
JAZZ DEVELOPER

Hi,
I am using a multi-select text prompt, so that I can enter multiple values. I am unable to filter the data from this prompt ( lets say separated by commas ) via a query , so that I can get the results and show only the values that are contained in the text box.
Also what adds to the complexity is that when the user enters the data in the prompt, the results should have all records that contain those values e.g ( %value1%, %value2%, %value3% ) , not exact values, but data that contains these words.

We are bringing data from RTC into Insight and running reports from Insight. The report has a Text Prompt for entering tag values to 'include or exclude'.

 

For example there are 2 workitems in RTC.
workitem1 has  |tag1|tag2|tag3| in the 'Tags' field
workitem2 has  |tag4|tag5|tag6|tag7| in the 'Tags' field.

When we run the report and enter tag1 in the text prompt, it should pull up workitem1
when we enter tag1,tag6 as input to the text prompt, it should pull up both workitems - workitem1 and workitem2.

I hope this example makes it clearer. If someone knows how to construct the right filter to pull up this data, it would be very helpful.

Can someone shed more light on this ?
Thanks

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
VK L (817●7●157●159) | answered Jun 21 '12, 11:56 a.m.
Hi Tapasya,
                      Is the Tag coolumn in RTC not available for use directly in the report? - If available, cant the report prompt be made to refer to that field - so that you can choose values while run the report and you get direct results?
0
permanent link
Jackie Albert (1.6k●1●49●47) | answered Jun 21 '12, 12:00 p.m.
The Tag column is available in the report, but if you make a prompt using Tag values, you'll get a prompt that has choices like this:

|tag1|tag4|tag3|
|tag4|tag5|tag6|tag7|
|tag1|tag2|tag4|

In our case the user wants to be able to type in "tag4" in the prompt box and get results that match all 3 of those workitems in my example above - not to have to choose each individual entry that has "tag4" in it.

Similarly, our users also want to be able to prompt on multiple tags - like results that have both tag1 and tag4 - and we have been unable to find a way to represent this in a report.
0
permanent link
VK L (817●7●157●159) | answered Jun 21 '12, 12:56 p.m.
Ok. In that case, take the column "Tag" in the output and apply a filter
Tag contains ?prompt?
(or)
Tag like ?prompt?

I think ? is for single-value prompt.

let me know if it works. This is the format of the filter-query using prompts
0
permanent link
Tapasya Bhaskar (1●2●2) | answered Jun 21 '12, 2:32 p.m.
JAZZ DEVELOPER
Yes we have already tried Tag like ?prompt-name? , it is useful when the user inputs only one value and that value exactly matches the data. However if the user enters e.g data as input , the report should display all words that have data like nodata, datacard, ---data---, data1, This is first scenario.

II scenario : user inputs value1, value2, value3, and we want all rows that will contain %value1%, %value2%, %value3%, ( wildcard characters before and after the word ) user can enter only part of the entire string and we want to retrieve the entire string.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.