Smartstaff
1,385
edits
Changes
no edit summary
<!--71845 - SmartConnect Function - Report-Query doesn't show the data-->
'''Function Name''' - 3.02.1 Get Report Sample 1: Report Query<br />
'''Description''' - To retrieve data from a report.<br />
'''Object Type''' - Report<br />
'''Action Type ''' - Query<br />
'''Field List''' - Query<br /> '''Mandatory field''' for Report Query:<br/>'''reportid''' - is the [[Determining the reportid|Report ID]] of the [[Report|report]] in the instance.'''Optional field''' for Report Query:<br/>'''criteriavalue''' - is when the [[Report|report]] has [[Setting_Text_Criteria_–_Logical_Operators_in_a_Report|text criteria]]. Values for the criteria should be indicated in this field. If report contains multiple criteria, values should be delimited by double semi-colon eg. "VALUE_1;;VALUE_2".
=====A report query on the number of assessors grouped by specialty=====
'''Description''' - A sample that will display the number of Assessors based on their specialty<br />
criteriavalue: <br />
--End custom parameter--
[[File:APIFunctionReport3.PNG|800px]]
=====A report query on a list of Grants grouped by Focus Area=====