cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

QueryImplementingThings & paging

sbeckers
1-Newbie

QueryImplementingThings & paging

Hi,

 

I was wondering if it's possible to implement paging with QueryImplementingThings (e.g. return 10 things at a time)? 

 

I see that a 'TopN' filter exists, but I don't see an 'Offset' filter or something like that which could be used to implement paging (e.g. 'return 10 things starting from position 0, then from position 10, 20, ...). Is there another way to do paging?

 

Thanks!

 

Stefan



4 REPLIES 4
adam11
5-Regular Member
(To:sbeckers)

Hi Stefan,

What is the use case for pagination?

Hi,

Well, depending on the situation, we have pagination or lazy loading / scrolling. On the backend, this comes down to the same thing. This is mainly for performance reasons, so that not all data is loaded from the DB and sent with every request. 


For the data that is stored in a MS SQL database, this can be done easily. But for ThingWorx Things & QueryImplementingThings I haven't found a solution, besides duplicating everything in a separate database.



adam11
5-Regular Member
(To:sbeckers)

Stefan,

Have you noticed performance issues when using QueryImplementingThings() on your data set? Having spoken with several colleagues, the consensus is that pagination is only warranted in a few cases. ThingWorx does not provide any built-in functionality for pagination, so unless you are seeing performance issues, it may not be worthwhile to implement the possible pagination solution I'll detail below.


Provided your data is sorted and the column on which you are sorting is unique, you can use a combination of TopN() and a query to implement pagination. Since you will be working with unique Things, you can do a greater than or less than comparison on the last row of data returned and specify the page size using TopN(). For example, if you have five Things ('A', 'B', 'C', 'D', 'E') and want to display two at a time, you would do a greater than comparison on 'B' and return the top two entries from that result ('C', 'D').


Thanks,

Adam



Ok, thanks.

Top Tags