How to filter a table control based on service context

Solved1.50K viewsservice Visio Visio Visual Overview
2
0 Comments

I am building a visual overview to be used with a service template and want to include a parametercontrol table, that has its rows filtered based on the service context. However when I include the table in the visual all rows are visible.

Can someone demonstrate the usage of the [servicedefinitionfilter] placeholder for this application?

Thanks

Update-

Below is the shape data I have set, when I do this no rows appear in the table control. When I replace [ServiceDefinitionFilter] with a specific value i.e. 11 - MCP1-203_ATS 01, that row does appear in the table control.

The protocol in question is the Generic Ping protocol.

Jim Woodier [DevOps Member] Selected answer as best 10th February 2021

1 Answer

4
11.62K 13 Comments

The [ServiceDefinitionFilter] placeholder can be used where a table index is expected. This is then replaced by the filter that is specified in the service definition.

For filtering a (table) parameter control, the configuration should look as follows:

Element                                  10/120
ParameterControl                  500
ParameterControlOptions      TableRowFilter:501=[ServiceDefinitionFilter]

Where the parameter with ID 501 is the column that should match the filter.

Jim Woodier [DevOps Member] Posted new comment 30th March 2023
Jim Woodier [DevOps Member] commented

Thanks Sebastiaan, unfortunately that did not work. I’ll add some more info to the original question.
Sebastiaan Dumoulein [SLC] [DevOps Catalyst] commented

After digging into this a bit further, we can confirm the [ServiceDefinitionFilter] is not correctly replaced in the ParameterControlOptions. For this an internal task has been created.

A workaround would be to store the filter in a property on the service. This property can then be used in the ParameterControlOptions as follows:

Element 10/120
ParameterControl 500
ParameterControlOptions TableRowFilter:501=[Property:MyRowFilter]
Options ForcePropertyFromPage
Jim Woodier [DevOps Member] commented

Is there a way to have the TableRowFilter:501=[Property:MyRowFilter] represent multiple rows? Filtered on the same parameter i.e. 501
Sebastiaan Dumoulein [SLC] [DevOps Catalyst] commented

Not using the TableRowFilter which is a filter applied on the server.

However you could use a client filter using ClientSideRowFilter which performs a post filter on the client.
ParameterControlOptions ClientSideRowFilter:MyParameterName:[Property:MyRowFilter]

Here the syntax uses the name of the parameter instead of the ID and any row that has a value for that parameter that contains the filter will be shown.
Jim Woodier [DevOps Member] commented

@Sebastiaan, can you tell me if this issue has been resolved in v10.1.3.0?

Thanks!
Show 8 more comments