(1) Search Criteria Condition
Specify the operator to be used in the search condition of the item selected in the search condition item setting.
All the selected search condition items are AND conditions.
The data types and operators that can be set for search condition items are as follows.
No. | Salesforce Field Types | Available | Condition | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||
Equals | Not Equals | < | > | <= | >= | Contains | Not Contains | Start With | |||
1 | Auto-Number | ● | ● | ● | - | - | - | - | ● | ● | ● |
2 | Formula(Checkbox) | ● | ● | ● | - | - | - | - | - | - | - |
3 | Formula(Currency) | ● | ● | ● | ● | ● | ● | ● | - | - | - |
4 | Formula(Data) | ● | ● | ● | ● | ● | ● | ● | - | - | - |
5 | Formula(Data/Time) | ● | - | - | - | ||||||
6 | Formula(Number) | ● | ● | ● | ● | ● | ● | ● | - | - | - |
7 | Formula(Percent) | ● | ● | ● | ● | ● | ● | ● | - | - | - |
8 | Formula(Text) | ● | ● | ● | - | - | - | - | ● | ● | ● |
9 | Formula(Time) | - | - | - | - | - | - | - | - | - | - |
10 | Roll-Up Summary Field | ● | ● | ● | ● | ● | ● | ● | - | - | - |
12 | Lookup | - | - | - | - | - | - | - | - | - | - |
13 | MasterDetail | - | - | - | - | - | - | - | - | - | - |
14 | URL | ● | ● | ● | - | - | - | - | ● | ● | ● |
15 | Checkbox | ● | ● | ● | - | - | - | - | - | - | - |
16 | Text | ● | ● | ● | - | - | - | - | ● | ● | ● |
17 | Text(Encrypted) | - | - | - | - | - | - | - | - | - | - |
18 | Text area | ● | ● | ● | - | - | - | - | ● | ● | ● |
19 | Percent | ● | ● | ● | ● | ● | ● | ● | - | - | - |
20 | ● | ● | ● | - | - | - | - | ● | ● | ● | |
21 | Text area (Rich) | - | - | - | - | - | - | - | - | - | - |
22 | Long text area | - | - | - | - | - | - | - | - | - | - |
23 | Time | - | - | - | - | - | - | - | - | - | - |
24 | Number | ● | ● | ● | ● | ● | ● | ● | - | - | - |
25 | Picklist | ● | ● | ● | - | - | - | - | - | - | - |
26 | Picklist(Multi-select) | ● | ● | ● | - | - | - | - | ● | ● | - |
27 | Geolocation | ● | ● | ● | ● | ● | ● | ● | - | - | - |
28 | Currency | ● | ● | ● | ● | ● | ● | ● | - | - | - |
29 | Phone | ● | ● | ● | - | - | - | - | ● | ● | ● |
30 | Date | ● | ● | ● | ● | ● | ● | ● | - | - | - |
31 | Date/Time | ● | ● | ● | ● | ● | ● | ● | - | - | - |