Skip to Content
Former Member
Jun 19, 2016 at 09:01 AM

custome SQL - in list - prompt



I am using SQL VIEWER (custome SQL) to write a query from a table that is not in our DWH.

But I find a problem in writing an "in list" prompt in which the user could type any value he/she wants.

If I write a simple "in list" with certain values - it works fine

But if I write an open prompt of which the user can choose any value he/she wants – It doesn't work

Can anyone please assist?

Here is a sample of one of my tryouts:

and my_object in @prompt('my_objects:','A',Multi,Free,Persistent,,User:0)