Differences

This shows you the differences between two versions of the page.

appendixd:customtableadministrationwebmethod:customtablesearchingrules [2009/07/09 07:23]
nsljivar
appendixd:customtableadministrationwebmethod:customtablesearchingrules [2009/07/09 07:23] (current)
Line 1: Line 1:
 +====== Custom Table Searching Rules ======
 +
 +Example: Table –  Account(CpqTableEntryId*, AccountId, FirstName, LastName)
 +\\ 
 +*this column is added automaticly, by API
 +\\ 
 +<code XML>
 +<Root>
 +  <Columns>
 +    <Column>AccountId</Column>
 +    <Column>FirstName</Column>
 +  </Columns>
 +  <SearchCriteria>
 +    <Value>23</Value>
 +    <Value >Jack</Value>
 +  </SearchCriteria >
 +</Root>
 +</code>
 +
 +Result will be obtained with query like this:
 +\\ 
 +Select CpqTableEntryId , AccountId, FirstName, LastName
 +\\ 
 +from Account
 +\\ 
 +where  AccountId = ‘23’ and  FirstName = ‘Jack’
  
You are here: SAP Sales Cloud CPQ Online HelpSAP CPQ APICustom Table Administration Web MethodCustom Table Searching Rules