I have a requirement where the table has a large set of data in database, hence we are trying to parametrized the direct query.
Plan is to append the parameter in the SQL query in the advance editor , something like below :
Select * from Country where Region =’"&Parameter1&"’"
Here region is column in country table and have created parameter1 based on the list query which is fetching distinct region from the country table.
Later , will like to provide the distinct region from the list query to the user as a filter , which once selected will trigger the parametrized query and get the limited data on the basis of region value.
Can you please help in the same
Watched this video : http://portal.enterprisedna.co/courses/303649/lectures/4839519 though this seems different as end user don’t get the parameter option.