Filters
Filtering can be made through the following operations:
- Equals:
- Not Equals
- Like (use * as wildcard)
- Greater Than
- Greater Than or Equals
- Less Than
- Less Than or Equals
When passing a list of criteria’s all operations are executed on the entire set using AND. No support exists for OR operations. OR operations can be accomplished by making multiple calls.
When creating the filer query 4 properties can be set:
- attribute – Filter on the standard properties on a DTO (when used leave customFieldId empty)
- customFieldId - Filter on the custom fields on a DTO (when used leave attribute empty)
- operation – The operation described above
- value – the actual value to filer on.
The following filters can be made on each service
Activity:
Client
|
|
Integer |
| CloseDate |
|
Date |
| StartDate |
|
Date |
| StartTime |
|
Time |
| Opportunity |
|
Integer |
| Order |
|
Integer |
| Project |
|
Integer |
| Contact |
|
Integer |
| User |
|
Integer |
| RelatedProject |
|
Integer |
Back to the top
Appointment:
Client
|
|
Integer |
| EndDate |
|
Date |
| StartDate |
|
Date |
| StartTime |
|
Time |
| Opportunity |
|
Integer |
| Order |
|
Integer |
| Project |
|
Integer |
| User |
|
Integer |
| RelatedProject |
|
Integer |
| RelatedUser |
|
Integer |
Back to the top
Opportunity:
| Client |
|
Integer |
| Contact |
|
Integer |
| OrderDate |
|
Date |
| Project |
|
Integer |
| User |
|
Integer |
| Probability |
|
Integer |
Back to the top
Order:
Client
|
|
Integer |
| Contact |
|
Integer |
| OrderDate |
|
Date |
| Project |
|
Integer |
| User |
|
Integer |
Back to the top
Product:
| Category |
|
Integer |
Back to the top
Project:
Name
|
|
String |
| RelatedUser |
|
Integer |
| RelatedClient |
|
Integer |
| RelatedContact |
|
Integer |
Back to the top
User:
RelatedClient
|
|
Integer |
| RelatedProject |
|
Integer |
| RelatedAppointment |
|
Integer |
Back to the top