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

Visual Overview TableRowFilter containing semi colon

Solved1.30K views5th August 2020parameter control Visio
1
Jeroen Geldhof [SLC] [DevOps Enabler]5.04K 4th August 2020 0 Comments

I'd like to filter on a display key that looks like the following:

1.2.198.55.x.x/IO 1/B-IN 1/3 - B-OUT 1/4/Input/Not Applicable/TS=234.1.2.10:2100=;Source IP=10.92.0.34=;/PAT Error

I want to apply two filters:

  • *234.1.2.10:2100=;*/PAT Error
  • *234.1.2.11:2100=;*/PAT Error

However, the TableRowFilters are separated by semicolons, and the filters also contain semicolons.
Is there a way to encapsulate the filters so that it's clear to DataMiner that the semicolon in the filter is part of the filter value?

Jeroen Geldhof [SLC] [DevOps Enabler] Selected answer as best 5th August 2020

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
2
Brent Alleweireldt [SLC]1.53K Posted 4th August 2020 3 Comments

The ";" seperator is only partly responsible for identifying the different parts in the filter. Other parts such as the presence of a filterkeyword needs to be present as well. Otherwise it is considered part of the value, and used as such. So in your case FULLFILTER= ((DK == '*234.1.2.10:2100=;*/PAT Error') OR (DK == '*234.1.2.11:2100=;*/PAT Error')) should work fine.

EDIT: DataMiner Help also states that string values should be enclosed by single quotes (').

Jeroen Geldhof [SLC] [DevOps Enabler] Posted new comment 21st August 2020
Jeroen Geldhof [SLC] [DevOps Enabler] commented 5th August 2020

Following is the one I’m trying based on your feedback, but it doesn’t seem to filter. We’re running 9.6.11

IncludedPids:1449,1419,1409|ColumnWidths:80,250,80|TableRowFilter:FULLFILTER=((DK == */TS=[property:Inbound Main Multicast]=*;/Udp Stream Loss) OR (DK == */TS=[property:Inbound Backup Multicast]=*;/Udp Stream Loss) OR (DK == */TS=[property:Inbound Main Multicast]=*;/TS Loss) OR (DK == */TS=[property:Inbound Backup Multicast]=*;/TS Loss) OR (DK == */TS=[property:Inbound Main Multicast]=*;/TS Sync Loss) OR (DK == */TS=[property:Inbound Backup Multicast]=*;/TS Sync Loss) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter1]=*/CC Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter1]=*/CC Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter2]=*/CC Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter2]=*/CC Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter3]=*/CC Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter3]=*/CC Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter4]=*/CC Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter4]=*/CC Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter5]=*/CC Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter5]=*/CC Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter1]=*/PID Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter1]=*/PID Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter2]=*/PID Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter2]=*/PID Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter3]=*/PID Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter3]=*/PID Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter4]=*/PID Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter4]=*/PID Error) OR (DK == */TS=[property:Inbound Main Multicast]=;*PID=[Property:PidFilter5]=*/PID Error) OR (DK == */TS=[property:Inbound Backup Multicast]=;*PID=[Property:PidFilter5]=*/PID Error))

Brent Alleweireldt [SLC] commented 5th August 2020

The initial answer did forgot to mention the fact that string-values should be enclosed by single quotes (‘). Locally similar filters worked without it, but it might solve your issue.

You can use Client Test Tool->Advanced->Dynamic Table Query to test the FullFilter part. Start with 1 comparisonsegment, run it and see if the returned result is correct (Does the returned data matches the filter, or in case of no result is this correct). Keep adding segments until the filter breaks. That way you can verify if it’s one segment breaking the filter, or if there is a bug in the filtering.

Be aware that the dynamic table query does not replace the […] parts n the filter, these will need to be filled in manually.

Jeroen Geldhof [SLC] [DevOps Enabler] commented 21st August 2020

Additional information was found. On Visio parsing the semicolons are always seen as a separator, even when they are between single quotes.
The way to resolve it is by replacing the separator with the [sep:;$] placeholder.

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

Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 1 Vote
When using the Setter = true attribute, will the copy action always be executed first? 1 Answer | 2 Votes
Multiple Set on Table parameters for DVE’s 1 Answer | 2 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 (109) Correlation (69) Correlation rule (52) Cube (150) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) 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