Skip to Content

SQL generated by the call--value set queries

This section shows the SQL generated by the preceding value set query.

Warning

Important

In this example, an AR System administrator made the API call, and the form did not use row-level security. If a nonadministrator makes the API call and the form uses row-level security, the SQL generated by the call will differ from this example.

Related topic

Retrieving-entries-from-multiple-forms

SELECT J0.C1, J0.C536870913, J0.C536870914
FROM T172 J0
WHERE (J0.C536870913 IN (SELECT J0.C536870913 FROM T171 J0))
ORDER BY J0.C1 ASC

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Helix Innovation Suite 25.4