Was this page helpful?

CreateViewSettings Example

    Table of contents
    No headers
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsdl="http://iterity.com/enterprise/wsdl">
       <soapenv:Header/>
       <soapenv:Body>
          <wsdl:CreateViewSettings>         
             <server>iterity</server>
             <session>47A79431462A5A5D3C1E5C4BA96428567AED551AFC20</session>
             <treeHandle>1172720000</treeHandle>
             <VIEW>
                <treeHandle>1172720000</treeHandle>
                <name>zkouska</name>
                <optimalize>1</optimalize>
                <id>1172861000</id>
                <itemId>contact.contact</itemId>
                <SORTORDER>
                   <count>2</count>
                   <COL>
                      <colId>contact.contact.mobile</colId>
                      <sortOrder>1</sortOrder>
                      <sortDirection>0</sortDirection>
                      <viewName>Mobile</viewName>
                   </COL>
                   <COL>
                      <colId>contact.contact.employer</colId>
                      <sortOrder>2</sortOrder>
                      <sortDirection>0</sortDirection>
                      <viewName>Employer</viewName>
                   </COL>
                </SORTORDER>
                <FILTERS>
                   <count>1</count>
                   <FILTER>
                      <colId>contact.contact.createdby</colId>
                      <operatorId>1093460000</operatorId>
                      <rowOrder>0</rowOrder>
                      <colType>user</colType>
                   </FILTER>
                </FILTERS>
                <COLSORDER>
                   <count>2</count>
                   <COLORDER>
                      <viewName>Employer</viewName>
                      <colId>contact.contact.employer</colId>
                      <colOrder>1</colOrder>
                   </COLORDER>
                   <COLORDER>
                      <viewName>City</viewName>
                      <colId>contact.contact.city</colId>
                      <colOrder>2</colOrder>
                   </COLORDER>
                </COLSORDER>
                <DEFAULTS>
                   <count>52</count>
                   <DEFAULT>
                      <sortOrder>0</sortOrder>
                      <colOrder>0</colOrder>
                      <sgs>4</sgs>
                      <align>left</align>
                      <width>40</width>
                      <itemId>contact.contact</itemId>
                      <colType>text</colType>
                      <isJoined>0</isJoined>
                      <viewName>Bank account</viewName>
                      <tableName>cm.account</tableName>
                      <xmlName>account</xmlName>
                      <colId>contact.contact.account</colId>
                   </DEFAULT>
                   <DEFAULT>
                      <sortOrder>0</sortOrder>
                      <colOrder>0</colOrder>
                      <sgs>4</sgs>
                      <align>left</align>
                      <width>40</width>
                      <itemId>contact.contact</itemId>
                      <colType>text</colType>
                      <isJoined>0</isJoined>
                      <viewName>Bank code</viewName>
                      <tableName>cm.bankcode</tableName>
                      <xmlName>bankcode</xmlName>
                      <colId>contact.contact.bankcode</colId>
                   </DEFAULT>
                   <DEFAULT>
                      <sortOrder>0</sortOrder>
                      <colOrder>0</colOrder>
                      <sgs>4</sgs>
                      <align>left</align>
                      <width>40</width>
                      <itemId>contact.contact</itemId>
                      <colType>text</colType>
                      <isJoined>0</isJoined>
                      <viewName>SWIFT/IBAN</viewName>
                      <tableName>cm.swiftcode</tableName>
                      <xmlName>swiftcode</xmlName>
                      <colId>contact.contact.swiftcode</colId>
                   </DEFAULT>
    ...
                   <DEFAULT>
                      <sortOrder>0</sortOrder>
                      <colOrder>0</colOrder>
                      <sgs>8</sgs>
                      <width>0</width>
                      <itemId>contact.contact</itemId>
                      <colType>subjecttype</colType>
                      <joinOn>s.contact=cm.id</joinOn>
                      <isJoined>1</isJoined>
                      <tableJoin>subject s</tableJoin>
                      <viewName>Subject type</viewName>
                      <tableName>s.subjecttype</tableName>
                      <xmlName>subjecttype</xmlName>
                      <colId>contact.contact.subjecttype</colId>
                   </DEFAULT>
                   <DEFAULT>
                      <sortOrder>0</sortOrder>
                      <colOrder>0</colOrder>
                      <sgs>8</sgs>
                      <width>0</width>
                      <itemId>contact.contact</itemId>
                      <colType>dimension3</colType>
                      <joinOn>dim3.id=sdim3.dimension3</joinOn>
                      <isJoined>1</isJoined>
                      <tableJoin>subject sdim3 on sdim3.contact=cm.id left join features_dimension dim3</tableJoin>
                      <viewName>Dimension 3</viewName>
                      <tableName>sw.dimension3</tableName>
                      <xmlName>dimension3</xmlName>
                      <colId>cnotact.contact.subject.dimension3</colId>
                   </DEFAULT>
                </DEFAULTS>
             </VIEW>
          </wsdl:CreateViewSettings>
       </soapenv:Body>
    </soapenv:Envelope>
    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Pages that link here
    Page statistics
    1309 view(s), 1 edit(s), and 7709 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments