Difference between revisions of "Pandora - Locate a UTA Level 1 Entity"
From SmartWiki
(7 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 13: | Line 13: | ||
|'''Callbackfunc''' ||Function to be used after the asynchronous function call. | |'''Callbackfunc''' ||Function to be used after the asynchronous function call. | ||
|- | |- | ||
− | |'''appid''' || | + | |'''[[appid]]''' || Application ID for the UTA. |
|- | |- | ||
|'''Fields''' ||The field list to be retrieved. | |'''Fields''' ||The field list to be retrieved. | ||
Line 26: | Line 26: | ||
|- | |- | ||
|'''Prefix'''|| Used by system to process fields across multiple entities. | |'''Prefix'''|| Used by system to process fields across multiple entities. | ||
+ | |- | ||
+ | |'''specialfind'''|| | ||
+ | |- | ||
+ | |'''groupby'''|| | ||
|- | |- | ||
| '''Returns''' || ssRecordSet object | | '''Returns''' || ssRecordSet object | ||
|} | |} | ||
− | |||
==Notes== | ==Notes== | ||
Line 43: | 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)";