Tag: Pivot
The Pivot tag lets you automate the flexYgrid's integrated Pivot Table tool.
<Pivot FilePath="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. |
| FilePath | User definable | The file path to the previously saved Pivot configuration XML 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
| Note | When using the attribute FilePath to retrieve incoming files, it will validate if both the folder path is correct and that the file itself exists. |
|---|
The configuration for the Pivot Table generator CANNOT be automated directly. The attribute
FilePath, along with a saved configuration file must be used.
<Pivot FilePath="databaseEZ-Pivot-setup.xml"/>
| Note | General grid automation actions can be used to configure the resulting pivot table, but 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 FilePath="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 and 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.