All Peoplevox Export tasks allow you to set search clauses to limit the data that is returned from the report. You can build up complex search criteria by using a number of search clauses and sub search clauses.
Note, if Export All is set to False, an additional clauses will be applied to filter on the modified date of the record using the Modified Since setting on the task as the value.
Use the Add and Remove buttons to maintain the search clauses to apply to the filter, and the Sub Search Clauses for more complex criteria.
- Export Despatches from Peoplevox
- Export Goods In from Peoplevox
- Export Item Availability from Peoplevox
- Export Item Movements from Peoplevox
This will update based on the other details added to the search clause to show a visual representation of filter that will be applied.
The comparison to use for the Field and Value. Defaults to Equals.
The name of field you want to compare the Value to, use the column name as it is expressed in the System reports displayed in your Peoplevox web application.
Set to False to have the Value quoted as part of the search. Set to True if the value is numeric and should not be quoted. Defaults to False.
You can use the operator to build up a complex query of multiple search clauses. Setting to AND will only return records where all the clauses match. Setting to OR will return records where at least one of the clauses match. Defaults to AND.
Sub Search Clauses
Additional sub search clauses can be used to build up a complex query. The Operator of the sub clause defines how the query will be built up. Note the sub clause had identical settings as the main search clause, except does not allow further sub clauses.
Enter the value you want to use to compare against the given Field.
Back | Edit on Github