Allow specific field values to be referenced in SQL query.

Description

Hi Team,

Use case -

Currently, we only have the option to use the "field key" parameter in the field in run macro to substitute the value selected in the field to the SQL macro, but if we want to use a specific value to be substituted to the SQL query we do not have this option as of now.
i.e if we have a checkbox type of field as shown the below screenshot and if the field has three different values.

and if the user wants to extract values "admin" in one variable and "admin1" in other variable so that I can give it as input to SQL. We would like to mention a variable similar to the one mentioned in the below SQL where $username.1 is the first value in the checbox and $username.2 is the second value in the check box

Thanks,
Kiran.

Environment

None

Status

Assignee

Aravind Kashyap

Reporter

Jagruti Waghulde

Labels

None

Support Entitlement

None

Priority

Major
Configure