Community
Showing results for 
Search instead for 
Do you mean 
Reply

Correct Syntax: Picklist filter, SQL DataChart Component

Bronze Super Contributor
Posts: 1,170
Country: USA

Correct Syntax: Picklist filter, SQL DataChart Component

Does any have an example of the correct syntax for using a filter in the SQL data chart that uses the picklist type filter with an embedded discreet list?

 

The documentation states:

 

{ParamName|PICKLIST:LNAME|Value}

Displays a checklist box with the contents of a pick-list. Value returned at run time is a comma separated list of items selected

 

Similar to the USERS paramater, you can specify a value or a comma separated list of values, or % = All.


Note the bold, underlined portion:  How do you format for the comma seperated list of values? 

I have tried without including LNAME, with including LNAME, list items with single quotes, list items w/o surrounding quotes...

 

Always get zilch...