Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Automatically "Select All" on Prompt Page?

Question in brief:
Does anyone know if there is a way to cause all the prompt values on a Prompt Page to be selected by default, when the values are the result of a query?

Background:
I am using Insight 1.0.1.1 . I have a report for Test Suites. The Test Suites have several Categories defined, and each Category Term has multiple Category Values.

I am able to create a Prompt page, where each Category Term has its own List Box. The List Boxes are populated by queries against the Category Term. Each Prompt displays with a "Select All" and a "Deselect All" link underneath it.

This is all working correctly.

My users would like the values in the List Box to be all selected by default (as if they had pressed the "Select All" link). They want this because there are many prompts, and clicking "Select All" several times is tedious.

I would use a Range for each value, but the Category Values can be redefined with new ones added, so Ranges would only work if I could specify the Minimum as less than the lowest possible Category Value, and the Maximum as greater than the highest possible. It is not obvious how to do this, since the values are text.

I cannot use the other mechanisms for specifying default selections, because those mechanisms only permit static values. The Category Values could be changed, possibly causing the static values to become incorrect.

I would try to use Cascading Prompts, but these Category Values are all independent of each other. And besides, Cascading Prompts does not appear to include a hook to permit causing all the values to be selected.

Does anyone know if there is a way to cause all the prompt values to be selected by default, when the values are the result of a query?

0 votes



4 answers

Permanent link
On 10/10/2011 7:38 AM, leethomas wrote:
Question in brief:
Does anyone know if there is a way to cause all the prompt values on a
Prompt Page to be selected by default, when the values are the result
of a query?

I do not have a direct answer, but in some cases this is actually not
necessary, because often parameters define a filter. So, when nothing is
selected then no filtering happens. Selecting noting in that cases has
therefore the same effect as selecting all in the parameter box.

However, if you already have a filter on the items you show in the
parameter box then this behavior cannot be assumed, of course.

So as long as you show all the values of your category term then you can
assume that everything is selected we you select nothing.

Hope this helps,
Peter.

0 votes


Permanent link
See this IBM technote: http://www-01.ibm.com/support/docview.wss?uid=swg21339608

You may need to make some security/permission setting changes to allow users to run the report with embedded Javascript. There is a technote out there that describes this but I haven't been able to find it.

Question in brief:
Does anyone know if there is a way to cause all the prompt values on a Prompt Page to be selected by default, when the values are the result of a query?

Background:
I am using Insight 1.0.1.1 . I have a report for Test Suites. The Test Suites have several Categories defined, and each Category Term has multiple Category Values.

I am able to create a Prompt page, where each Category Term has its own List Box. The List Boxes are populated by queries against the Category Term. Each Prompt displays with a "Select All" and a "Deselect All" link underneath it.

This is all working correctly.

My users would like the values in the List Box to be all selected by default (as if they had pressed the "Select All" link). They want this because there are many prompts, and clicking "Select All" several times is tedious.

I would use a Range for each value, but the Category Values can be redefined with new ones added, so Ranges would only work if I could specify the Minimum as less than the lowest possible Category Value, and the Maximum as greater than the highest possible. It is not obvious how to do this, since the values are text.

I cannot use the other mechanisms for specifying default selections, because those mechanisms only permit static values. The Category Values could be changed, possibly causing the static values to become incorrect.

I would try to use Cascading Prompts, but these Category Values are all independent of each other. And besides, Cascading Prompts does not appear to include a hook to permit causing all the values to be selected.

Does anyone know if there is a way to cause all the prompt values to be selected by default, when the values are the result of a query?

0 votes


Permanent link
So, when nothing is
selected then no filtering happens. Selecting noting in that cases has
therefore the same effect as selecting all in the parameter box.


This is correct, Peter, as long as two conditions are true:
1. The "Required" property for the List Box must be set to "No".
2. The filter that contains the parameter must have its "Usage" property set to "Optional". (In my case, the filter was applied inside another query.)

But by setting both the "Required" property to "No" and the "Usage" property to "Optional", the result is that selecting nothing (or clicking "Deselect All") is the same as clicking "Select All".

Thank you, Peter!

0 votes


Permanent link
See this IBM technote: http://www-01.ibm.com/support/docview.wss?uid=swg21339608


Thank you, Jared, but that technote appears to apply to only Cognos 8.2 and older, while Insight uses 8.4 .

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 10 '11, 10:24 a.m.

Question was seen: 14,858 times

Last updated: Oct 10 '11, 10:24 a.m.

Confirmation Cancel Confirm