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

Wildcards in queries (low-code-apps / dashboards) not working?

Solved827 views15th March 2024Generic Query Interface query query filter Wildcards
3
Nils Hoven [DevOps Advocate]1.17K 15th March 2024 0 Comments

Hi Dojo,

after updating our DMS to 10.4.0 recently, we‘ve observed that some tables in one of our low-code apps were not showing any more data. After some investigation on the query that was populating the table in question we could see that now the filtering in the query seems not to allow wildcards any more?
Until now we‘ve been able to apply a filter based on a „contains“ condition and then using wildcards (e.g. „Gi*/0/*“ to filter for certain gigabit interfaces on a switch). Now, after the update, we have to reduce the filter to a string without any wildcards, which does not lead to the same result, unfortunately…

Any idea if this is kind of a bug that has been introduced recently, or is this an intended behavior?

Thanks a lot!

Nils Hoven [DevOps Advocate] Selected answer as best 15th March 2024

1 Answer

  • Active
  • Voted
  • Newest
  • Oldest
5
Ronald Gerard [SLC] [DevOps Advocate]1.73K Posted 15th March 2024 1 Comment

Hi Nils,

Thanks for your question!
Nothing significant changed for this feature in 10.4.0 and should still work as before. Our internal tests still indicate that this feature works and I was able to confirm this manually as well.

This leads met to conclude that either:

  1. there is a system specific difference in the back-end
  2. there are other parts of your query that influence the result somehow

To confirm or refute the first option, you can manually query (part of) your table with the Client Test Tool, taking GQI out of the equation:

  1. Open the Client Test Tool
  2. Connect with the tool to your DMS
  3. Start a dynamic table query
  4. For "Filter(s)" enter e.g. the following: fullFilter=(X == *Gi*/0/**)
    where X is the parameter ID of the parameter table column you want to filter on. This is how GQI would send the filter to the back-end
  5. Request the first page and verify if this still works as expected.

To confirm or refute the second option, you could create a minimal version of your query in the app with only the Parameter Table by ID  data source followed by your wildcard filter.

Important note!

Using wildcards in a contains/equals filter is a legacy feature that we eventually want to fully replace with the more generic alternative: regex filtering.
This is because wildcards only work for parameter tables and nothing else.
Unfortunately, regex filtering is in 99% of cases not compatible yet with parameter table wildcards.

For now, if it all possible, try to avoid using wildcards.
I don't have a full view over your use case, but maybe it is somehow possible to use 2 separate contains-filters on e.g. "Gi" and "/0/"?

Don't hesitate to reach out if you need any more assistance.

Nils Hoven [DevOps Advocate] Selected answer as best 15th March 2024
Nils Hoven [DevOps Advocate] commented 15th March 2024

Hi Ronald,
thanks a lot for your feedback! I tested the first procedure, and the manual query via Client Test Tool including filtering as described works nicely. So that’s alright.
I then looked into the query once again to see which other element of the query may cause the trouble. And it turns out that there is a “Sort by” just ahead of the filtering which is somehow interfering with it. Once I delete the sorting, then the filtering including wildcards works just fine again!
So, very good that you pointed in the right direction – cheers!
BR
Nils
P.S.: thanks as well for the heads-up regarding filtering based on regex.

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

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 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 (151) 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