Tag: Pivot
The Pivot tag lets you automate the flexYgrid's integrated Pivot Table tool.
<Pivot InputFilePath="databaseEZ-pivot-setup.xml"/>
Tag Attributes
| Attributes | Attribute Value | Value Description | Comment |
|---|
| Target | Applicable Grid Code |  | Not mandatory – If no target is set, this will default to the main grid. |
| InputFilePath | User definable | Saved XML Pivot configuration file | Mandatory |
| Server | Abbreviated server names (separated by comma) | | Only applicable in consoleEZ - see detailed description |
| Index | Positive integer | Window index number | Only applicable in consoleEZ - see detailed description |
Detailed Description
The configuration for the Pivot Table generator CANNOT be automated directly. The attribute InputFilePath, along with a saved configuration file must be used.
<Pivot InputFilePath="databaseEZ-Pivot-setup.xml"/>
| Note | General grid automation actions can be used to configure the resulting pivot table. These actions MUST be embedded within the Pivot action block. |
|---|
The Server attribute is only applicable to consoleEZ, in which case it will be mandatory for Target="LogAnalyzer" or Target="VolumeAnalyzer".
The Index attribute is also only used in consoleEZ and is mandatory when using Target="LogAnalyzer" or Target="VolumeAnalyzer", it is the value found on the Log Analyzer and Volume Analyzer windows.
Example Script
<?xml version="1.0" encoding="UTF-8"?>
<ytriaAutomation Application="databaseEZ" ApplicationVersion="16.5">
<Load Server="ACME01/ACME" Select="True"/>
<Pivot InputFilePath="C:\pivot_config.xml">
<Export>
<SetParam field="FilePath" value="D:\temp-exports\PivotExport.html"/>
<SetParam field="ExportType" value="HTML"/>
<SetParam field="FileOutput" value="Unicode"/>
<SetParam field="OpenFileOnceGenerated" value="true"/>
</Export>
</Pivot>
</ytriaAutomation>
In the script above, the entire server "ACME01/ACME" will be loaded into the database tree in databaseEZ; all databases will be selected and loaded into the main grid. The action Pivot will trigger the retrieval of the saved Pivot Table configuration file "pivot_config.xml" and generate a pivot table of the data in the main grid based on this based on this configuration. The resulting table will be exported to an HTML file; the file will open once it has been generated.
|