x
character: The x
character in some parameter names means that there can be more than one instance of the parameter. For example, QUERYx_CMD
means there can be QUERY1_CMD
, QUERY2_CMD
, QUERY3_CMD
, etc.
QUERYx_CMD
parameters. They can be used in the conditions for these queries to filter their results.advantys.com
:LASTNAME
FIRSTNAME
USERNAME
EMAIL
PHONE
MOBILE
PAGER
FAX
OFFICE
DEPARTMENT
COMPANY
JOBTITLE
PERSONALTITLE
EMPLOYEENUMBER
EMPLOYEETYPE
POSTALADDRESS
POSTALCODE
CITY
STATE
{ISMEMBER(groupname)}
QUERY1_CMD
: Executing an SQL queryQUERY1_CMD
IN parameter to the action. If the parameter is empty or non-existent, no operation will be performed.RESULT_LIST
parameter:RESULT_LIST
/ QUERYx_RESULT_LIST
: Retrieving queries resultsRESULT_LIST
OUT parameter to the action. To retrieve the result by query, you have to add the QUERYx_RESULT_LIST
OUT parameter for each query (associated to their process data).RESULT_LIST
parameter. QUERY1_RESULT_LIST
contains the username list of Montreal, QUERY2_RESULT_LIST
contains the username list of Toronto, and QUERY3_RESULT_LIST
contains the username list of New York. RESULT_LIST
contains the usernames of all three QUERYx_CMD
parameters.QUERY1_DIR
: Directory specificationQUERY1_DIR
IN parameter in the action. If this parameter has a NULL
value or does not exist, the default directory is WORKFLOWGEN
(or the directory specified as the default by an Administrator).YourCompany
directory into the RESULT_LIST
parameter:QUERYx_CMD
: Using more than one queryQUERYx_CMD
IN parameters, where x
is the number of the query. To get the result of each query, you have to add the QUERYx_RESULT_LIST
OUT parameters.WORKFLOWGEN
directory into the QUERY1_RESULT_LIST
parameter, the username list of users from Montreal in the INTRANET
directory into the QUERY2_RESULT_LIST
parameter, and the complete username list from the two queries into the RESULT_LIST
parameter:QUERYx_TOP
: Specify results maximumQUERYx_TOP
as an IN parameter of the action. The query will not be able to return more results than the number specified in this parameter.QUERYx_DEFAULT_VALUE
: Specify a default valueQUERYx_DEFAULT_VALUE
IN parameter in the action.RESULT_LIST
parameter will contain default1
:RESULT_SEPARATOR
: Separator specificationRESULT_SEPARATOR
IN parameter. The default separator is ,
(comma).RESULT_LIST
parameter value is: name1***name2***name3
:RESULT_COUNT
/ QUERYx_RESULT_COUNT
: Number of records returnedRESULT_COUNT
OUT parameter to the action. For the number of records per query, you must add the QUERYx_RESULT_COUNT
OUT parameters to the action.RESULT_COUNT
parameter and the number of records of each query (QUERY1
and QUERY2
) in the QUERY1_RESULT_COUNT
and QUERY2_RESULT_COUNT
parameters:QUERYx_CMD
parameter. You must add IN parameters with different names for the following reserved parameters:QUERYx_CMD
QUERYx_DIR
QUERYx_TOP
QUERYx_RESULT_COUNT
QUERYx_RESULT_LIST
RESULT_LIST
RESULT_COUNT
RESULT_SEPARATOR
@
character.WORKFLOWGEN
directory:PARAM1
is an arbitrary convention; any parameter name may be used.QUERYx_CMD
: Using macros in SQL query conditionsQUERYx_CMD
by adding an available macro in the condition.Dev
group, members of the WORKFLOWGEN
directory, and are in Montreal:RESULT_LIST_EMAIL
/ QUERYx_RESULT_LIST_EMAIL
: Retrieving the queries result in an email list formatRESULT_LIST_EMAIL
OUT parameter to the action. If you want to retrieve the emails by query, you must add the QUERYx_RESULT_LIST_EMAIL
OUT parameter to each query.RESULT_LIST_EMAIL
parameter. QUERY1_RESULT_LIST_EMAIL
contains the Montreal email list and QUERY2_RESULT_LIST_EMAIL
contains the Toronto email list:This directory does not exist
XML context is empty or incorrect
Database connection error
Query error
QUERYx_CMD
parameter are valid.The queries return too many values
QUERYx_CMD
parameter to filter the results.The parameter [parameter name] has the same name as a WorkflowGen-reserved parameter. You must change the name.
The queries return too many records
QUERYx_CMD
parameters to filter the results.The parameter [parameter name] must have a value
[Parameter name] parameter is required
GetUsersFromDirMaxResultNb
parameter in the WorkflowGen web.config
file specifies the maximum number of records that can be returned by a query.