Difference between revisions of "Pandora - Locate a UTA Level 1 Entity"
From SmartWiki
(11 intermediate revisions by 4 users not shown) | |||
Line 1: | Line 1: | ||
==Function Overview== | ==Function Overview== | ||
− | This function is used to return a recordset of | + | This function is used to return a recordset of {{l1}} item. |
− | + | levelone_find(flag,callbackfunc,appid,fields,filter,order,start,end,prefix,specialfind,groupby) | |
{| border="1" | {| border="1" | ||
Line 9: | Line 9: | ||
!Description | !Description | ||
|- | |- | ||
− | |'''Flag'''|| | + | |'''Flag'''||True or false, send synchronously or asynchronously. |
|- | |- | ||
− | |'''Callbackfunc''' || | + | |'''Callbackfunc''' ||Function to be used after the asynchronous function call. |
|- | |- | ||
− | |'''appid''' || | + | |'''[[appid]]''' || Application ID for the UTA. |
|- | |- | ||
− | |''' | + | |'''Fields''' ||The field list to be retrieved. |
|- | |- | ||
− | |''' | + | |'''Filter'''|| The criteria to apply on the return records. |
|- | |- | ||
− | |''' | + | |'''Order'''|| The field to be ordered by for the return records. |
|- | |- | ||
− | |''' | + | |'''Start'''||The index of the first record to be returned from the record set retrieved based on the filter. |
|- | |- | ||
− | |''' | + | |'''End'''||The index of the last record to be returned from the record set retrieved based on the filter. |
|- | |- | ||
− | |''' | + | |'''Prefix'''|| Used by system to process fields across multiple entities. |
|- | |- | ||
− | | '''Returns''' || | + | |'''specialfind'''|| |
+ | |- | ||
+ | |'''groupby'''|| | ||
+ | |- | ||
+ | | '''Returns''' || ssRecordSet object | ||
|} | |} | ||
− | + | ==Notes== | |
Fields = always the driver for created record set. | Fields = always the driver for created record set. | ||
− | Filter = | + | Filter = 'lastname like "y*"' |
− | Order = | + | Order = 'lastname desc' |
Start = 0 to 200 default = 0 | Start = 0 to 200 default = 0 | ||
Line 42: | Line 46: | ||
End = 200 default = 200 | End = 200 default = 200 | ||
− | Blank , | + | Blank ,"","", |
Prefix=?? | Prefix=?? | ||
+ | Specialfind = "" | ||
+ | |||
+ | Groupby = lastname | ||
+ | |||
+ | ==Example== | ||
+ | |||
+ | Filter base on status id | ||
+ | |||
+ | fields = "name,stageid,statusname" | ||
+ | |||
+ | filter="status.stageid IN (8958,9480)"; | ||
+ | |||
+ | |||
+ | ==See Also== | ||
+ | * [[Pandora Filter Examples]] | ||
[[Category: Pandora]] | [[Category: Pandora]] |
Latest revision as of 17:04, 28 August 2013
Contents
Function Overview
This function is used to return a recordset of Level 1 item.
levelone_find(flag,callbackfunc,appid,fields,filter,order,start,end,prefix,specialfind,groupby)
Parameter | Description |
---|---|
Flag | True or false, send synchronously or asynchronously. |
Callbackfunc | Function to be used after the asynchronous function call. |
appid | Application ID for the UTA. |
Fields | The field list to be retrieved. |
Filter | The criteria to apply on the return records. |
Order | The field to be ordered by for the return records. |
Start | The index of the first record to be returned from the record set retrieved based on the filter. |
End | The index of the last record to be returned from the record set retrieved based on the filter. |
Prefix | Used by system to process fields across multiple entities. |
specialfind | |
groupby | |
Returns | ssRecordSet object |
Notes
Fields = always the driver for created record set.
Filter = 'lastname like "y*"'
Order = 'lastname desc'
Start = 0 to 200 default = 0
End = 200 default = 200
Blank ,"","",
Prefix=??
Specialfind = ""
Groupby = lastname
Example
Filter base on status id
fields = "name,stageid,statusname"
filter="status.stageid IN (8958,9480)";