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
  • Updates & Insights
  • Questions
  • Learning
    • E-learning Courses
    • Empower Replay: Limited Edition
    • Tutorials
    • Open Classroom Training
    • Agility
      • Kanban workshop
      • Agile Fundamentals
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • 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
    • 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
      • About the DevOps Program
      • DataMiner DevOps Support
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
    • Global Feedback Survey
  • Support
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

GQI server side filter and sorting

701 views1st April 2025
0
Julien DA COSTA [DevOps Member]72 18th September 2024 2 Comments

Is there a way to send filter & sort operations to server side ?

GQI is nice to do some custom queries but the inconvenient is once you want to integrate it in a table, you have to send the whole table data to have filtering & sorting.

This start to be a problem when you have thousands of rows in your table.

Sending to server side would necessit to code the filter ourselves but it is something common in other frameworks or languages.

For example, js component datatables.net (DataTables | Javascript table library ) is a component which let you choose if you want to process data on client side or server side.

I wish something similar could exist to be able to use the GQI queries on large amount of data.

Ronald Gerard [SLC] [DevOps Advocate] Answered question 1st April 2025
Marieke Goethals [SLC] [DevOps Catalyst] commented 27th January 2025

Hi Julien,
I see that this question has been inactive for some time. Do you still need more information for this? If not, could you select Ward's answer to indicate that the question is resolved?

Julien DA COSTA [DevOps Member] commented 27th January 2025

Hello Marieke,
A delivery date would be fine to me 🙂

4 Answers

  • Active
  • Voted
  • Newest
  • Oldest
0
Julien DA COSTA [DevOps Member]72 Posted 19th September 2024 1 Comment

Hello Ward,

it is an ad hoc data source provided by GQI.

i agree it is our responsability to fetch the data as efficient as possible but when using in a table it is not easy as filter and sorting are done on client side.

currently if we use an adhoc data source to fill a table, the fetch process ask every page until GetNextPage returns false.

Do you know in which version the feature you mention will be released ?

Ward Haeck [SLC] [DevOps Enabler] Posted new comment 19th September 2024
Ward Haeck [SLC] [DevOps Enabler] commented 19th September 2024

Hi Julien, thank you for providing me with some more info!

If your query is shown in a table than it should not necessarely fetch all pages. Since GQI will only retrieve just about enough rows to fill the table. If you scroll down additional pages are fetched from your ad hoc data source.

If the query contains some operators such as aggregate, join, sort etc. Than it might occur that all pages are fetched from your ad hoc data source in order to fill the first visible rows in your table. For example, we need all the data to be able to correctly sort the data.

I currently have no ETA for that feature, it is currently on our backlog, I will include your question/use case to boost the priority.

Best regards, Ward

You are viewing 1 out of 4 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
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