iSheets API
iSheets API version 2 - Common objects - iSheet item - Advance search - common object

iSheets API version 2 - Common objects - iSheet item - Advance search - common object

OVERVIEW

Common object for request xml while running an advanced search

<filterdata>
    <allofthesewords><![CDATA[ ]]></allofthesewords>
    <anyofthesewords><![CDATA[ ]]></anyofthesewords>
    <excludethesewords><![CDATA[ ]]></excludethesewords>
    <data>

        <!-- date time type column -->
        <column attributecolumnid="1130">
            <rawdata>
                <fromdate><![CDATA[9 Oct 2017]]></fromdate>
                <todate><![CDATA[9 Oct 2017]]></todate>
            </rawdata>
        </column>
        
        <!-- choice type column -->
         <column attributecolumnid="1136">
            <rawdata>
                 <choices>
                     <choice>
                         <label><![CDATA[Option 1]]></label>
                     </choice>
                     <choice>
                         <label><![CDATA[Option 3]]></label>
                     </choice>
                </choices>
            </rawdata>
        </column>
        <!-- Score[choice] type column applicable from 5.1-->
         <column attributecolumnid="1136">
            <rawdata>
                 <choices>
                     <choice>
                         <label><![CDATA[Score[Choice1]]]></label>
                     </choice>
                     <choice>
                         <label><![CDATA[Score[Choice2]]]></label>
                     </choice>
                </choices>
            </rawdata>
        </column>
        <!-- user lookup type of column -->
        <column attributecolumnid="1142">
            <rawdata>
                 <value>11</value>
            </rawdata>
        </column>
        
        <!-- other type of column (single line) -->
         <column attributecolumnid="1133">
            <rawdata>
                 <value>
                    <![CDATA[updated]]>
                 </value>
            </rawdata>
        </column>
    </data>
</filterdata>

Note:

1. Date and time type column - The string should be in the required format for the particular column. For example, if the column is configured for 'DD.MM.YYYY' the string should be in the format of '15.11.2017'.

Comments


17 Comments

Last Updated: Jun 09,2023