This batch process report will load a list from a predefined query and specifies how many records there should be in a list.
MKT510 will fail if the custom SQL query used contains comments in the (--) format. Instead, use comments in the format (/* */).
The query can fetch “N” number of records but user might want to select only the first 500 records in a particular list. If “0” is selected it creates a list with all the records.
If the report tries to load a list from a predefined Data Analyzer query, and the query returns zero results, MKT510 will fail.
Parameter |
Description |
Required? |
---|---|---|
Organization |
The Organization ID for which you want to run the report. |
Read-only |
Organization Unit |
The Organization Unit ID for which you want to run the report. |
Read-only |
List Code |
List Code is a uniquely assigned number for each time the list is used. If you want to use a Data Analyzer query list, you need to create a DA query with only 2 columns - Master_Customer_ID and Sub_Customer_ID in Select if the query has a UNION clause. |
Yes |
Total Number of Records |
This parameter specifies how many records should be there in a list. The query can fetch 'n' number of records but user might want to select only first 500 record in a particular list. If this is 0, then it is assumed to create a list with all the records. |
Yes |
Regenerate Flag |
If this flag is checked then existing members in the list will be deleted before loading the list with new criteria. If this flag is not checked then existing members in the list will be kept and new members will get added in list upload process. |
Yes |