Is there a way to create a static LOV (ie. Yes, No) in Framework Manager and reference that in the prompt macro ?
Something similar to the below -
#promptmany('Display Detail','string','','','['Yes','No']')#
Anyone ?
There is no way, in a relational model, to do this. What you can do instead is to create a table with all of the values you need.
Field
------
|Yes |
|No |
|> |
|>= |
|= |
|<= |
|< |
|And |
|So |
|On |
------
Then in your prompt macro you can do something like:
#prompt('par','string',sq('default'),'','filter([NS].[Table].[Field],[NS].[Table].[Field] in (' +sq('Yes') + ','+sq('No')+'))')#