Forum Discussion
What is a list query for a parameter?
- 9 years ago
Hi Tracy,
Query list is a list of values created in the blank query using M Language. It is basically the ordered list of values and defined using comma separated values with any data type enclosed in braces.
For example, Type the list of values of any data type in the advanced editor window.
Remove all the code in Advanced Editor and just type below list of values
{"Ryan","Matthew","Todd"} and Press Done.
You can use this list of values in your parameter and this can be done by creating a new parameter and in the Suggested Values field, Select Query and Query field will become active now. You can select the current value as per your preference.
This list of values will be shown in your parameter values.
Hope this has clarified ypour understanding.
For more information on this, Please visit this blog.
Thanks & Regards,
Bhavesh
Hi Tracy,
Query list is a list of values created in the blank query using M Language. It is basically the ordered list of values and defined using comma separated values with any data type enclosed in braces.
For example, Type the list of values of any data type in the advanced editor window.
Remove all the code in Advanced Editor and just type below list of values
{"Ryan","Matthew","Todd"} and Press Done.
You can use this list of values in your parameter and this can be done by creating a new parameter and in the Suggested Values field, Select Query and Query field will become active now. You can select the current value as per your preference.
This list of values will be shown in your parameter values.
Hope this has clarified ypour understanding.
For more information on this, Please visit this blog.
Thanks & Regards,
Bhavesh
thank you - thank you - thank you!
i was able to create the list query and use it.
tracy
- BhaveshPatel9 years ago
Super User
Thank you for your appreciation.
Thanks & Regards,
Bhavesh