Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

link shape to parameter in table row filtered from values in two columns

Solved1.05K views4th July 2023linking table parameters Visio
1
Anna Carlsson [DevOps Member]368 27th June 2023 0 Comments

So, I have a table where the key is a string combined from two other columns (port and carrier). For example port 0 and carrier 1 generates key 0_1.

In Visio I would like to link a shape to a parameter on a row with key value port_carrier, or port,carrier.

How to create variable port_carrier or filter parameter from two columns is my question? is this possible?

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

2 Answers

  • Active
  • Voted
  • Newest
  • Oldest
0
Thomas Warnez [SLC] [DevOps Advocate]629 Posted 30th June 2023 4 Comments

Hey Anna.

If I understand your question correctly, you want to link a shape to a parameter within the table. This can be done by adding Shape Data to the shape. The shape data should be looking like this.

You still need to fill in the "ParameterID" to the column you want to show and the "TableRowKey" to which row you want to show. The options part can be deleted.

If you want further information you can lookup the following link https://docs.dataminer.services/user-guide/Basic_Functionality/Visio/linking_shapes/Linking_a_shape_to_an_element_parameter.htm

If you want to show the whole column, you can add a shape and group this shape. Then add following shape data:

The PK is the ID of the primary Key column. The TABLEID is the ID of the table in the connector. And the DMAID/ELEMENTID can be filled dynamically by following sequence [element].

You can open then the Group Shape and create a new shape here and group it again. On this newly grouped shape you can add following shape data:

The PK needs to be the same ID as on the shape above.

Now you can dynamically create shapes in this group shape and link it with following Shape data to each column of the table. The columnID needs to be filled in.

Hope this helps, ofcourse everything mentioned here can also be checked in the help https://docs.dataminer.services/user-guide/Basic_Functionality/Visio/visio.html

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 4th July 2023
Anna Carlsson [DevOps Member] commented 30th June 2023

Thank you for this information. It was very well explained. What I need to understand is how to generate this key value. Let me try to give an example. I am using a key value (user_id) to read a certain row from a table. Here I can find the two values port and carrier which I need to generate a new key to access a row in another table. The key value is port_carrier as a string. Either I must convert the values port and carrier to a string (port_carrier) or I must be able to find a row based on two columns port and carrier.

Thomas Warnez [SLC] [DevOps Advocate] commented 30th June 2023

Ok I think I understand where you want to go. When you have the key to the parameters Carrier and Port. You can use the above documentation to get your parameter. But instead of using “CARRIER_PORT” you use [param:DmaID/ElementID,ParameterID,TableKey]_[param:DmaID/ElementID,ParameterID,TableKey]. This generates the key for you. With the DMA/ELEMENTID similar as before [element] and ParameterID linked to the column where you find your Carrier or Port. The TableKey is than your link to these parameters. If I understood your comment well this is the user_id.

For an introductory course to the different placeholders and how they work, you can refer to our Visual Overview training lesson here: https://community.dataminer.services/courses/visio/lessons/creating-a-dynamic-visio-drawing/

Anna Carlsson [DevOps Member] commented 30th June 2023

Great! Thank you! That solved my problem.

Thomas Warnez [SLC] [DevOps Advocate] commented 3rd July 2023

Hey Anna if this helped you consider to tag it as solved so other people can use the answer when they have a similar question as you. Thank you in advance.

You are viewing 1 out of 2 answers, click here to view all answers.
Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Alarm Dashboard PDF/CSV Export 0 Answers | 0 Votes
Is the Microsoft SharePoint Connector Still Usable 0 Answers | 0 Votes
Is the Microsoft SharePoint Connector Still Usable 0 Answers | 0 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (108) Correlation (68) Cube (150) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (139) driver (65) DVE (55) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (151) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) services (51) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin