Hello,
I have a table in my dataminer that displays information retrieved via a probe. I would like to use visio to display a specific column (for example just the id) of the last row received by the probe. Thanks in advance !
Aymeric
Assuming you have an indication on the last change in one of your columns, here’s what you can do.
Taking
- Column to retrieve: 101
- Column that contains last change date: 102
- Element called “E1”
Set a shape with shape data
- SubscriptionFilter – SORT=102|DESC
And shape text
- [param:E1,101]
Now, this will return your entire column, with pipe separated values, but your last updated row will be the first entry. e.g. “A|B|C”, where A is your column value for the last updated row.
At that point, you can use a regex to match this first entry, wrapping the param placeholder inside it. Your shape text then becomes
- [regexreplace:^([^|]+)\|(.*)$,[param:E1,101],$1]
Not sure if this will match your use case, but hope it helps in any case.
Hi Aymeric,
You could use the shape data ParameterControl together with ParameterControlOptions to define what specific column/row could be displayed.
When using ParameterControlOptions you will notice that we could use a filter to determine which row should be displayed in the table. The question here is how we can identify the last row?
- Do you know if that row has a known display key? If so, you could use the filter to point to that specific row
- In case the display key is not known in advanced, is there another way to identify that row? For example you could use wildcards to match a specific pattern available in the display key