LASTNAME
FIRSTNAME
USERNAME
EMAIL
PHONE
MOBILE
PAGER
FAX
OFFICE
DEPARTMENT
COMPANY
JOBTITLE
PERSONALTITLE
EMPLOYEENUMBER
EMPLOYEETYPE
POSTALADDRESS
POSTALCODE
CITY
STATE
{ISMEMBER(groupname)}
*groupname
{ISMANAGER(username)}
*username
{ISSTAFFMEMBER(username)}
*username
{ISMEMBER(my_group_name)}
{ISMEMBER(@GROUP_NAME)}
advantys.com
:DEPT_DATA
request data:MY_CITY
request data and the value of the MY_COUNTRY
request data is CANADA
:=
, !=
, <>
, IS NULL
, NOT IS NULL
, LIKE
, NOT LIKE
, etc.AND
and OR
to combine multiple criteria conditions to a maximum of 255 characters length in the query. When there are many criteria conditions, it is strongly recommended to use parentheses to logically enclose them.CITY_DATA
of CANADA
:%
(percent sign) and _
(underscore) can be used with the LIKE
operator.AN
:@
character.DATA1
:DATA1
is an arbitrary convention; any request data name may be used.)Dev
group, member of the WORKFLOWGEN
directory and comes from Montreal:LIKE
operators and wildcard characters (%
,_
) in criteria conditions. The is due to a possible large amount of information that needs to be filtered by the limited scope engine for user accessible requests and actions.