Skip to Content
Information
This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

SQL generated by the call--value set queries

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

Warning

Note

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.


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*

AR System 21.3