LassoScript Utility
Basics Browse Detail

[ChartFX_Records]

Tag Link [ChartFX_Records] Category ChartFX
Type Substitution Source Available Yes
Support Preferred Version 8.5
Change New Data Source Any
Output Type Array Security None
Implementation Sets Lasso 8.5

Description

[ChartFX_Records] rreturns a records array which is formatted in the proper format to be passed to the [ChartFX->SetLassoData] tag. Specifically, the field names are included as the first row of the records array. If one or more -ReturnField parameters are specified then only those fields will be included in the records array. If one more -ExcludeField parameters are specified then those fields not be included in the records array. -Fields=(Array) can be used to specify an array of alternate field names to use. Finally, if -Inverse is specified then the arrays are inverted to a format useful for making pie charts.

Syntax

[Inline: -Search, -Database='Contacts', -Table='People', -KeyField='ID', -MaxRecords='all']
[ChartFX_Records]
[/Inline]

[Inline: -Search, -Database='Contacts', -Table='People', -KeyField='ID', -MaxRecords='all']
[ChartFX_Records: -Inverse]
[/Inline]

[Inline: -Search, -Database='Contacts', -Table='People', -KeyField='ID', -MaxRecords='all']
[Records_Map: -ReturnField='First_Name', -ReturnField='Last_Name']
[/Inline]

[Inline: -Search, -Database='Contacts', -Table='People', -KeyField='ID', -MaxRecords='all']
[Records_Map: -ExcludeField='ID']
[/Inline]

[Inline: -Search, -Database='Contacts', -Table='People', -KeyField='ID', -MaxRecords='all']
[Records_Map: -Fields=(Array: 'ID', 'First', 'Last')]
[/Inline]

Parameters

Optional Parameters
-ReturnField Specifies a field name that should be included in the inner array. Should be called multiple times to include multiple fields. If no -ReturnField is specified then all fields will be returned.
-ExcludeField The name of a field to exclude from the inner array. If no -excludeField is specified then all fields will be returned.
-Fields An array of field names to use for the inner array. By default the value for [Field_Names] will be used.
-Inverse If specified then the arrays are inverted to a format useful for making pie charts.

Change Notes

This tag was added in Lasso 8.5.2.

Examples

See the Lasso 8 Language Guide for examples of how to use this tag.