Global parameters in run query chains
RéponduI am trying to reference global parameters in the function run query. Under type, it does not have global parameter. When I try to recreate the parameters, I do not have a value so I put default value. That is what is listed in the global parameter in the query section. What can I do ?
I also ran the metadata for the query and got the parameters from there but can not use them as a reference in the run query section. Can I maybe use the extract value function to pull the parameters? Any kind of help here would be appreciated.
-
Hello Deepak,
I am going to go ahead a create a Support ticket on your behalf. Our Support team will be able to look into this further for you.
Thank you!
0
Hi Deepak,
Type is used to specify the data type of the parameter rather than which parameter type is used. To use a Global Parameter, you need to provide the Global Parameter's name in the 'Name' field and it's value that should be used when the Query runs in the 'Value' field.
The first step is to verify that the Global Parameter has been created properly. You can find steps here https://support.workiva.com/hc/en-us/articles/360042267591-Configure-global-parameters-for-the-workspace for configuring Global Parameters for the Workspace. Below is a screenshot of an example Global Parameter called 'globalp' with a default value of 2. Note that the type is Text rather than Integer.
The next step is to verify that your Query is properly using the Global Parameter. You can find steps here https://support.workiva.com/hc/en-us/articles/360040227931-Manage-query-parameters#section2 to learn how to use Global Parameters in a Query. Below is a screenshot of a test Query that uses 'globalp' to filter the status column:
Finally, I can run the test Query using the Global Parameter via the Run Query command by referencing its name, type, and value. Below is an example screenshot:
0Vous devez vous connecter pour laisser un commentaire.
Commentaires
2 commentaires