Filter DTO v9

Filters are conditions which define a projection on the data read from the cloud. Typically filter contains a CQL expression which is evaluated over data in the cloud.

Field Name Type Category Constraint Reference Description
conjunction List<ConditionDTO_V9> Optional "And" condition defined by the given filter.
description String Optional length >= 1 & length <= 2147483647 Filter description.
disjunction List<ConditionDTO_V9> Optional "Or" conditions defined by the given filter.
name String Required length >= 1 & length <= 512 Filter name.
objectType DomainObjectModel Required Allowed values { PRICELIST, PAYMENTTERM, PAYMENTTYPE, CURRENCY, COMPANYINFO, BUSINESSPARTNERGROUP, SHIPPINGTYPE, EMPLOYEEPOSITION, EMPLOYEEDEPARTMENT, EMPLOYEEBRANCH, SERVICECALLSTATUS, SERVICECALLTYPE, SERVICECALLPROBLEMTYPE, SERVICECALLORIGIN, UDFMETAGROUP, UDFMETA, ITEMGROUP, ITEMTYPE, WAREHOUSE, ITEMCATEGORY, TIMEPROJECT, WORKTIMETASK, REPORTDATA, COUNTRY, STATE, COUNTY, GROUP, OBJECTGROUP, PERSONRESERVATIONTYPE, PERSON, PERSONSTATUS, LOCATION, BUSINESSPARTNER, ADDRESS, CONTACT, BUSINESSPARTNER_REFERENCES, ITEM, ITEMPRICELISTASSIGNMENT, ITEMWAREHOUSELEVEL, SERIALNUMBER, EQUIPMENT, SALESORDER, SALESORDERITEM, PURCHASEORDERITEM, PURCHASEORDER, SALESQUOTATIONITEM, SALESQUOTATION, ALERT, ACTIVITY, ATTACHMENT, DEFECT, INCIDENT, SERVICECALL, SERVICEASSIGNMENT, OBJECTRATING, SIGNATURE, TIMETASK, TIMESUBTASK, TIMEEFFORT, SYNCOBJECTKPI, WORKTIME, ITEMPROPOSAL, EXPENSETYPE, TAX, EXPENSE, MILEAGETYPE, BATCH, BATCHQUANTITY, MATERIAL, MILEAGE, APPROVAL, PRODUCTIONORDER, CHECKLISTCATEGORY, CHECKLISTTEMPLATE, CHECKLISTINSTANCE, BUSINESSPROCESSSTEPDEFINITION, BUSINESSPROCESSSTEPASSIGNMENT, SERVICECHECKOUT, INVOICEITEM, INVOICE, CREDITNOTEITEM, CREDITNOTE, COMPANYSETTINGS, USERSETTINGS, PERSONRESERVATION, USERSYNCCONFIRMATION, SERVICEERRORCODEITEM, SERVICEERRORCODE, ACTIVITYSUBTYPE, ACTIVITYTOPIC, USAGE, SERVICECONTRACT, PROPERTYMETA, SERVICECONTRACTEQUIPMENT, BLANKETORDER, DOCUMENTDISCOUNT, GENERICORDER, ITEMRETURNREASON, LOCATIONNUMBERSERIES, TRANSPORTCOST, VISITORREPORT, INVENTORY, STOCKTRANSFER, DOCUMENTDRAFTITEM, DOCUMENTDRAFT, COMPETITOR, COMPETITORPRODUCT, INDUSTRY, INFORMATIONSOURCE, LEVELOFINTEREST, CATEGORY, REASON, SALESSTAGE, SALESOPPORTUNITY, ENUMERATION, CHECKLISTASSIGNMENT, ERPERROR, RESERVEDMATERIAL, BRANCH, CHECKIN, ACTIVITYFEEDBACK, ACTIVITYCOMPOSEDCODE, ACTIVITYCODE, REPORTTEMPLATE, SERVICEASSIGNMENTSTATUS, SERVICEASSIGNMENTSTATUSDEFINITION, COMMENT, SEQUENCE, FILE, FILEREVISION, FILEREF, ATTRIBUTE, ATTRIBUTEVALUE, ACTIVITYTEMPLATE, SERVICESUITECONFIG, CHECKLISTINSTANCEELEMENT, EQUIPMENTSUBTYPE, TRANSLATION, FIELDCONFIGURATION, SCREENCONFIGURATION, SYNCOBJECTCHANGELOG, CONFIGURATION, FILTER, CUSTOMRULE, TAG, SKILL, REQUIREMENT, UNKNOWN } Type of the object on which the filter is defined.

FilterDTO_V9.ConditionDTO_V9


Field Name Type Category Constraint Reference Description
field String Optional length >= 0 & length <= 255
operator String Optional length >= 0 & length <= 255
value String Optional length >= 0 & length <= 255