CheckDates
Description:
Locates all SDIs for an SDC that has a specified date column or where clause, then executes an Action.
Input Properties
sdcid
Description:
Identifier of the SDC to be checked.
Required:
Yes
columnid
Description:
Date column (in the SDC) to compare against the current date.
Required:
Yes
whereclause
Description:
Any additional condition required to find matching SDIs.
Required:
No
Comments:
Do not include the keyword "where", e.g., status='Active'.
processactionid
Description:
Action that will be processed if all of these are in the past:
- Date in the column specifed by the columnid
- sdcid
- whereclause
Required:
No
actionid
Description:
Action executed for all matching SDIs.
Required:
Yes
processactionversionid
Description:
Version of the processactionid.
Required:
No
batch
Description:
Determines how the Action (specified by actionid) is called:
  • Y (default) = Calls the Action only once for all the matching SDIs. The keyids of the matching SDI are collated in a semicolon-separated list and sent to the Action.
  • N = Calls the Action once for each matching SDI that is found.
Required:
No
asynchronous
Description:
Determines how the Action (specified by actionid) is processed:
  • Y = Adds the Action to the ToDo List and does not call the processAction method synchronously.
  • N (default) = Executes the Action synchronously.
Required:
No
Additional Information
Additional information concerning this Action:
This Action locates all SDIs for an SDC that has:
  • A date column that contains a date prior to the current date.
  • A where clause, specified by the caller, to filter the list of matching SDIs.
When SDIs matching these criteria are found, a specified Action is executed.

You can also add properties. CheckDates will pass them to the specified actionid.

Copyright © 1999-2025 LabVantage Solutions, Inc.