Value prompt

[DaisySara]

Instead of grabbing values from a package object, how can I type in a list of values I want to display on my value prompt?

[calson33]

Select "Static Choices" in the properties of the object.

[DaisySara]

So simple...thank you!!!!

[DaisySara]

One more thing...is there a way to put in ABC order, without just having to enter all the values that way?

[calson33]

I don't know of any way to make them sorted other than to put them in that way.

[RKMI]

Hi,

I agree with Calson no way to define a sort on static choices unless entering them that way. But, I have an idea and I would be curious to know if a Javascript item would help do a sort for static values.

Thanks,
RK

[calson33]

I have used javascript to sort listboxes before, but it seems like a lot of extra effort.

Another option would be to create some sort of unioned SQL query like:
select 'MY Display Val 1' d, 'my return val1' r from dual
union
select 'MY Display Val 2' d, 'my return val2' r from dual
union
select 'MY Display Val 3' d, 'my return val3' r from dual
union
select 'MY Display Val 4' d, 'my return val4' r from dual
union
select 'MY Display Val 5' d, 'my return val5' r from dual

This could be sorted by Cognos autmatically, and extra values could be easily appended to the end of the query.