Search Results for

    Show / Hide Table of Contents

    Peoplevox Search Clauses

    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.

    Peoplevox Search Clauses

    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.

    Tasks

    • Export Despatch Summary from Peoplevox
    • Export Goods Ins from Peoplevox
    • Export Item Availability from Peoplevox
    • Export Item Movements from Peoplevox

    Settings

    Clause

    Read Only
    This will update based on the other details added to the search clause to show a visual representation of filter that will be applied.

    Comparison

    Required
    The comparison to use for the Field and Value. Defaults to Equals.

    Available Values

    • Contains - Barcode.Contains("08112")
    • EndWith - Barcode.EndsWith("1232")
    • Equals - Barcode == "800811232"
    • Equals2 - Barcode.Equals("800811232")
    • GreaterThan - Barcode > "800811232"
    • GreaterThanOrEqualTo - Barcode >= "800811232"
    • LessThan - Barcode < "800811232"
    • LessThanOrEqualTo - Barcode <= "800811232"
    • NotContains - !Barcode.Contains("800811232")
    • NotEqualTo - Barcode != "800811232"
    • NotEqualTo2 - !Barcode.Equals("800811232")
    • StartsWith - Barcode.StartsWith("8008")

    Field

    Required
    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.

    Literal

    Required
    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.

    Operator

    Required
    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

    Optional
    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.

    Value

    Enter the value you want to use to compare against the given Field.

    In This Article
    Zynk Documentation © 2021, Zynk Software Limited. Zynk is a registered trademark of Zynk Software Limited