How can I store changed column properties with my queries?
When I run a query against any type of logfile using the GUI, I can afterwards right-click on the column and change column properties. For instance, by default the value "0" (zero) is not shown, which is annoying, so I set the format string to "0.###", as opposed to the default #.### for numeric columns.
But when I run the query again, edited or not, these properties disappear and I have to go there again, which is very annoying and in the end makes it rather useless to use these properties.
I don't see any save-button in the properties window, nor anything in the query-syntax that I could use to set column properties. Is there any way to make this stick between runs and sessions?
Abel
shared this idea
This is done in Log Parser Lizard version 5.1.2. Now you can save column properties in query by checking the ‘Save data grid layout’ check box in the Save Query dialog box.
-
In Log Parser Lizard 6.7 there is a button on the toolbar to save the Data Grid layout. The button is in Data View tab, Grid Properties group (two small button between 'Add Calculated Field' and 'Edit Mode'). You can also clear current grid layout.
After you make changes to some grid properties (for instance add custom column formatting), by hitting that button, grid layout will be saved between each run. If you want to keep the layout in queries, you should also save query after saving the layout.
This behavior was changed in 6.7 since we had users complaining that accidentally saved the layout in query (after trying something).
-
Kluge
commented
That's great. But where do I find this check box in version 6.7.1?
-
This is done in Log Parser Lizard version 5.1.2. Now you can save column properties in query by checking the 'Save data grid layout' check box in the Save Query dialog box.