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: