Can you set a session variable or are there any automatically generated when a table row is selected?
I know this is possible in the protocol, but wondering if this can be done without modifying it.
The requirement is to filter a second table based on the row selected in the first table, with no relations between the tables apart from some of the columns that aren’t PK or DK have the same information in.
I used Generating child shapes based on table rows with Turning a shape into a parameter_control shapes in the child group for each column, with each shape having the value set to the PID:[tableindex], also Adding options to a parameter control of ‘CustomTitle:|Lite|HideTableIndex’ for readonly parameters and ‘CustomTitle:|Lite|HideTableIndex|IncludeWrite’ for write parameters, to hide the parameter name and index.
For the parameter that’s in the separate table I did the following to get the correct row using the display key made up of fixed text & [param:DmaID/ElementID,ParameterID,TableRow].
I also had to add the show as there’s not a row for everything in the first table, in the second table, but showed a button from possibly another row in the second table.
Example end result, the first three columns from table 1 and the last from table 2
Hi Philip,
For parameter controls, this functionality would require adjusting the protocol directly.
However, an alternative approach could be to use child shapes. You can generate a shape for each row, and when clicked, it sets a session variable.
This can be achieved by using the Selectable feature: https://docs.dataminer.services/user-guide/Basic_Functionality/Visio/miscellaneous/Making_shapes_selectable.html
Thank Sebastiaan,
I ended up using child shapes, but using ParameterControl for each column instead.