Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Global parameters in run query chains



2 opmerkingen

  • Courtnie Carver

    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!

  • Jeff Hickey

    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 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 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:


U moet u aanmelden om een opmerking te plaatsen.