Forum Discussion
Helper IIParameterize and accept user input
Microsoft EmployeeHi sprasad,
Based on my test, It is possible to achieve it, you can create the different parameters and queries to filter the table. You can refer to below steps:
1.Create two parameters and set the “Current Value”
2.Create two queries to relate the parameters.
Query1= Sql.Database("<ServerName>", "TSQLV3", [Query="select * from Calendar2 where year ='"&Parameter1&"'"])
Query2= = Sql.Database("<ServerName>", "TSQLV3", [Query="select * from Calendar2 where year ='"&Parameter2&"'"])
3.Now you can see the result.
4.You can use the data of “Query1” in your page A and use the data of “Query2” in your page B. Now you can enter the different parameters to show your different data.
Regards,
Daniel He
Helper IIHi Daniel,
Thanks for your reply and solution. In fact this is the way I am currently querying by using different variables for the queries in different page/tabs.
But I want to optimize on the input parameters since I end up in entering many input values as there are 5 different pages. So I wanted to input one value in Parameters and according to the Input value it should go to the correct page and sit in the query string for that tab. Again I want to emphasize on my requirement/condition: "So when a user enters the Value as Product 1 the graph should get updated in Page A and when the user enters the Value as Product 2, the graph on Page B should get updated." And I should have only one Parameter variable for "Value"
Thanks