iSheets API version 2 - Common objects - Column conditions and view filter - common object
iSheets API version 2 - Common objects - Column conditions and view filter - common object
OVERVIEW
Note:
1. columnid : column id (within this iSheet)
2. operatorid
| 1 | is equal to | SHEET_FILTER_OPERATOR_TYPE_EQUAL_TO |
| 2 | is not equal to | SHEET_FILTER_OPERATOR_TYPE_NOT_EQUAL_TO |
| 3 | is greater than | SHEET_FILTER_OPERATOR_TYPE_GREATER_THAN |
| 4 | is less than | SHEET_FILTER_OPERATOR_TYPE_LESS_THAN |
| 5 | is greater than or equal to | SHEET_FILTER_OPERATOR_TYPE_GREATER_THAN_OR_EQUAL_TO |
| 6 | is less than or equal to | SHEET_FILTER_OPERATOR_TYPE_LESS_THAN_OR_EQUAL_TO |
| 7 | begins with | SHEET_FILTER_OPERATOR_TYPE_BEGINS_WITH |
| 8 | contains | SHEET_FILTER_OPERATOR_TYPE_CONTAINS |
| 9 | NA | NA |
| 10 | is equal to | SHEET_FILTER_OPERATOR_TYPE_EQUAL_TO_USER_LOOKUP |
| 11 | is not equal to | SHEET_FILTER_OPERATOR_TYPE_NOT_EQUAL_TO_USER_LOOKUP |
| Negative column conditions supported from 5.0 | ||
| 12 | does not contain | SHEET_FILTER_OPERATOR_TYPE_DOES_NOT_CONTAIN |
| 13 | does not begin with | SHEET_FILTER_OPERATOR_TYPE_DOES_NOT_BEGIN_WITH |
| 14 | is blank | SHEET_FILTER_OPERATOR_TYPE_IS_BLANK |
| 15 | is not blank | SHEET_FILTER_OPERATOR_TYPE_IS_NOT_BLANK |
3. oprand : filter value. like, text or userid or date
4. logicaltype
1 : AND
2 : OR
5. columnid : filter supports below column types
| Single line text | SHEET_COLUMN_TYPE_SINGLE_LINE_TEXT |
| Choice | SHEET_COLUMN_TYPE_CHOICE |
| Number | SHEET_COLUMN_TYPE_NUMBER |
| Date and time | SHEET_COLUMN_TYPE_DATE_AND_TIME |
| User lookup | SHEET_COLUMN_TYPE_LOOKUP |
| Multiple line text | SHEET_COLUMN_TYPE_MULTIPLE_LINE_TEXT |
| Calculation | SHEET_COLUMN_TYPE_FORMULA |
6. Operators and operand based on column type
| Single line text |
begins with contains is equal to is not equal to is blank is not blank does not contain does not begin with |
String |
| Choice |
begins with contains is equal to is not equal to is blank is not blank does not contain does not begin with |
String |
| Number |
is equal to is not equal to is greater than is less than is greater than or equal to is less than or equal to is blank is not blank |
Numeric |
|
Date and time |
is equal to is not equal to is greater than is less than is greater than or equal to is less than or equal to is blank is not blank |
[Today]+1 OR 08 Aug 2017 00:00 |
|
User lookup |
begins with contains is equal to is not equal to is blank is not blank does not contain does not begin with |
[me] OR user id OR String (other) |
|
Multiple line text |
begins with contains is equal to is not equal to is blank is not blank does not contain does not begin with |
String |
|
Calculation |
is equal to is not equal to is greater than is less than is greater than or equal to is less than or equal to |
Numeric |
7. sheetfiltervaluetypeid : Only applicable for 'User lookup' type column
1 : Me
2 : User (user id)
3 : String value
Vandana Sharma - if it mentions the row it is probably an id error with the column you are trying to reference in the logic. The getColumns() call ...isheets/admin/{iSheetid}/columns will return a list of columns in that iSheet and their respective column ids
I am getting error - Invalid columnid 12 for row. from where i can find this columnid?
It seems that example XML request was removed on v4 of this post - can it be put back in? Until then example, inserted below (which I found from the post history)
Imran Aziz Tagged
Imran Aziz Hi Imran with 5.1 a new element is required in column -> columnconditions -> row -> scoreconditiontypeid. I believe this is only mandatory when the column it is referencing is a score column (and should be set to 2, set to 0 in all other cases). Would you be able to share the purpose of this element as the column type could surely be inferred using the columnid making this element redundant? I feel I must be missing something....
The error message when it is missing is also not very descriptive
Thank you
Your review has been submitted.
Comments
5 Comments