Visio Shape: displaying a table cell value based on a Primary Key

Solved860 viewsVisio
2
0 Comments

Hi,

I am creating a view to show a specific value from a table within an element.

We are looking to get the value from the ‘Status’ column based on a known primary key in a table and I am struggling to find the correct syntax.

The table ID is 112, PK 119 and Status 120, I am able to display the whole table on the shape but unfortunately do not know the syntax. E.g. I am trying to find the Status value based on the Primary Key ‘VideoBlue’

Many thanks

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 11th July 2023

1 Answer

2
12.84K 0 Comments

Hi Oliver,

There are multiple ways to do this, the two most common ones are:

  1. Using the element and parameter shape data (see docs):
    Element         MyElement
    Parameter      120:VideoBlue

    Note that your text should contain an asterisk ‘*’.

  2. Using the parameter placeholder in the shape text (see docs):
    [param:MyElement,120,VideoBlue]

This is also explained in the Visual Overview course which can be found here.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 11th July 2023