Hey everyone,
I’m working with a view table and was wondering if there is a way to hide the name of the table from which a column is taken.
All help would be appreciated.
I assume that you mean the table name being mentioned as a suffix between round brackets in the parameter description of the column parameter.
-Which DataMiner version are you trying this on?
-What does your table view look like? All columns of the same table, or does it included columns from linked tables?
For the columns coming from the table where the view is based on, you can use the duplicateAs attribute. For the columns coming from the other table(s) you’re going to have to copy the parameter definitions and prefix them with “View_” and adapt the table suffix to have the same one like the other parameters are having. Don’t forget to disable trending and remove alarming on the View_ parameters. This way all column parameters will have the same table suffix and will be filtered out automatically
That does work indeed. It does give me problems when trying to use the SNMP sets.
Is there an easy workaround for doing sets in the view table? Or can I only do sets by using a Qaction that triggers on the View_…. write parameter?
Sets triggered by a duplicateAs parameter will indeed be automatically on the base pid instead of the view pid. For the View_ parameter you’re going to have to trigger a QAction (row=”true”) on that View_ pid and further process it from there onward.
Hi Maxim,
Often the column description is suffixed with the table name, to make them unique. These table names are automatically hidden when displaying the table in Cube, if they meet these conditions:
- Parameter is a table column
- The suffix matches the regex \s*\(\s*[^\(\)]*?\s*\)\s*$
- All columns of the table that have a description, must have the same suffix.
If these conditions are not met, the suffix will still be trimmed if it exactly matches the table description.
In practice, this means you can accomplish what you want by making sure all columns have the same table name suffix between parentheses. This can be the exact table name, or an abbreviation.
You can find more detailed info in release note 18928.
Thanks for the answer Laurens, your assumption is correct.
I’m using DataMiner version 10.0.7.0-9247.
The view table contains columns from different tables, so for example:
Column name 1 (table name 1) | column name 2 (table name 2)| …
Someone suggested adapting the table names so that they fit the view table name, but this is more of a workaround and would leave the original tables with the parenthesized information.