This documentation supports the 18.05 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Value set queries

The ARGetListEntryWithMultiSchemaFields function can perform IN and NOT IN operations on a fixed value set and on a value set returned by a subquery (the WHERE clause of an SQL query).

The function's  ARMultiSchemaFuncValueSetQueryStruct structure represents a subquery for the IN and NOT IN operators. Each IN and NOT IN operation can be performed on only one field.

The following C and Java examples show a value set query. In these examples, the login user name is InSubqueryUser. The query operates on the InSubqueryPermissions1 form and performs the IN subquery on the InSubqueryPermissions3 form. The example assumes that both forms are populated with the appropriate data. The following topics are provided:

Was this page helpful? Yes No Submitting... Thank you