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
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • YouTube Videos
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Agility
      • Book your Agile Fundamentals training
      • Book you Kanban workshop
      • Learn more about 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)
    • >> Go to DataMiner Docs
  • DevOps
    • About the DevOps Program
    • Sign up for the DevOps Pogram
    • DataMiner DevOps Support
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
  • Downloads
  • Contact
    • Sales, Training & Certification
    • DataMiner Support
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Solutions
    • Deal Registration
  • >> Go to dataminer.services

Table Pagination

Solved797 views4 days ago
0
Julien DA COSTA [DevOps Member]72 5th September 2024 2 Comments

Hello

The problem we are facing is a GQI query which is sending back 2000 rows at least and first call seems to make a full load and then pagination is made on the dataset. So it takes a lot of time.

i would like to handle pagination on server side by myself but problem is that pagination properties available in payload of GetNextQuerySessionPage request are not available in the GetNextPageInputArgs argument of GetNextPage GQI function.

May be i am using the wrong class to get that ?

the answer which would say we should filter first to have less data is not accepted 🙂

thanks

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 4 days ago
Marieke Goethals [SLC] [DevOps Catalyst] commented 28th March 2025

I see that this question has been inactive for some time. Do you still need help with this? If not, could you select the answer (using the ✓ icon) to indicate that the question is resolved?

Marieke Goethals [SLC] [DevOps Catalyst] commented 4 days ago

As this question has now been inactive for a very long time, I will close it. If you still want more information about this, could you post a new question?

3 Answers

  • Active
  • Voted
  • Newest
  • Oldest
0
Julien DA COSTA [DevOps Member]72 Posted 5th September 2024 2 Comments

thanks for the feedback

i tested the code example and it works correctly but something strange is happening.

once the page is displayed the getnextpage is called in few seconds and twice for the first page (GetNextPage 1)

And all the pages are called in few seconds ( 269 rows in database).

So that means that all the data is loaded on server side even if only the first page is displayed in the grid.

Second point is pageSize is set to 100 in GQI but the component still displays 50 rows.

i did a second test with pageSize to 50 and all the date is still loaded

Question is why all the pages are loaded at screen init and not when scrolling down ?

is there any parameter or configuration which might help ?

Julien DA COSTA [DevOps Member] Posted new comment 17th September 2024
Ward Haeck [SLC] [DevOps Enabler] commented 6th September 2024

Hi Julien, it all depends on the query and what you are visualizing in your app/dashboard. For example, if you add an ‘aggregate’ operator to your query than all data of your data source is needed, which would explain why all pages are fetched. Another example, if you would sort the data in your table, it could also result in all pages getting fetched from your data source.

If the client only shows 50 rows while your data source returns 100 rows, than the other 50 rows are kept in memory in GQI. If another page is fetched the 50 rows from memory are returned.

Could you give me some more information on how the query is used in the dashboard/app? Feel free to contact me through support.data-exploration@skyline.be if that would be more convenient.

Best regards, Ward

Julien DA COSTA [DevOps Member] commented 17th September 2024

Thanks for your feedback
is there an instance kept in memory per user or active page ?
https://docs.dataminer.services/user-guide/Advanced_Modules/Dashboards_and_Low_Code_Apps/GQI/Extensions/API_Reference/IGQIDataSource.html#examples
in this example, pagecounter is incremented which that means its value is kept between two calls ?

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