How to Insert Parameter into SQL to produce data set

Q&A
, ,
1

Is there a way to take a user-provided variable (parameter?) from a QS control and insert it into the SQL that creates the data set? (Dataset query: select * from products where id = [3], where [3] is provided by user via a control.) Could it work with a default parameter to pull initial results and then after user selects a parameter it can fetch new data vs. just filtering on what was presented.

2

Hello Clee1,

Yes this is possible. Kindly review the below documentations for implementation steps:

Regards,

1 Like
3

This is excellent. Thanks so much!