iSheets API
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

<row>
      <rowid></rowid>
      <columnid></columnid>
      <operatorid></operatorid>
      <oprand><![CDATA[]]></oprand>
      <logicaltype></logicaltype>
      <sheetfiltervaluetypeid></sheetfiltervaluetypeid> (Only applicable for isheet view filters)
</row>

 

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

Comments


5 Comments

Last Updated: Jun 09,2023