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 ARMultiSchemaFuncValueSetQueryStruct structure of the  ARGetListEntryWithMultiSchemaFields function represents a subquery for the IN and NOT IN operators. You can perform each IN and NOT IN operation on only one field.

The following C and Java examples show a value set query:

In the following 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.