Smartstaff
1,385
edits
Changes
no edit summary
===List===
<!--66823 - SmartConnect grouping criteria-->
<!--75675 - SmartConnect field name and format consistency-->
This function will retrieve a list of records from the selected '''Object Type'''.
: "field" - name of the standard/custom field to sort records by
: "direction" - either "asc" (for ascending) or "desc" (for descending)
* getstorevalue - this is an optional settings for the json array. <br/>Options are: int type: '''0''' - to get display value, '''1''' to get stored value (value from the databaseeg. $25,000 vs 25000)* renderfieldname keyformat - this is an optional settings for the json array. Options are: '''0''' - to use what is configured in the Field List form the SmartConnect Function, '''1''' - to use the custom field names / standard field names and '''2''' - to use the custom field ID
=====Retrieve a list of contacts=====
criteria : [{"andor":"or","field":"sf_First Name","operator":"like","value":"J%"}]<br />
sortby : [{"field":"sf_First Name","direction":"asc"}]<br />
--End custom parameter--
criteria : [{"andor":"or","field":"sf_First Name","operator":"like","value":"S%"},<br />{"andor":"and","field":"sf_Address","operator":"like","value":"%Peter%"}]<br />
sortby : [{"field":"sf_First Name","direction":"asc"}]<br />
--End custom parameter--
criteria : [{"andor":"and","field":"sf_Name","operator":"like","value":"Br%"}]<br />
sortby : <br />
--End custom parameter--
criteria : [{"andor":"and","field":"sf_Name","operator":"like","value":"Br%"},{"andor":"and","field":"sf_Address","operator":"like","value":"%Ave%"}]<br />
sortby : [{"field":"sf_Name","direction":"asc"}]<br />
--End custom parameter--
criteria : [{"andor":"and","field":"cf_Nature of Injury / Comments on Claim","operator":"like","value":"%professor%"}]<br />
sortby : [{"field":"sf_Customer","direction":"desc"}]<br />
--End custom parameter--
objectid : 1688407<br />
fieldid : 1523157<br />
--End custom parameter--
===Transaction===
<!--72195 - SmartConnect Function on Transaction-->
Transaction should be [[Category:Transactions | configured]] before using this API function.<br/>
====Get Transaction Record====
'''Function Name''' - 3.10.1 Get Transaction Record<br />
'''Action Type ''' - List<br />
'''Field List''' -
'''Action Type ''' - Update<br />
'''Field List''' -
'''Action Type ''' - Delete<br />
'''Field List''' -
