Showing results for 
Search instead for 
Did you mean: 

custome SQL - in list - prompt

Former Member
0 Kudos


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)


Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

try like this.

Object IN  @Prompt('my_objects:','A',,Multi,Free,Persistent,,User:0)

Former Member
0 Kudos

Great. Thank You!!!

Answers (0)