Skip to main content
1-Visitor
Mar 29, 2016 4:26 PM UTC
Solved

ThingWorx Display and InfoTable Limit to 500

Hello,

I have the following Observasions:

Observasion 1:

​ThingWorx not able to dispay more than 500 records or items (or Things) in the composer. Below image shows the display limit upto 500 Things only although there is more than 500 Things in the server:

500 Thing Limit.png

Observasion 2:

​This Limit to 500 records applies to Infotable too. InfoTable not able to store more than 500 rows. For example following code should return 1000+ results as there are more than 1000 things created from "VMList" Thing Template.

But returns only "500"

var params = {

  maxItems: undefined,

  nameMask: undefined,

  query: undefined,

  thingTemplate: 'VMList',

  tags: undefined

};

var vmList = Resources["SearchFunctions"].SearchThingsByTemplate(params);// storing list of all the Thing Create using  "VMList" Thing Template

var result= vmList.rows.length;//Pringting no of rows of the infotable

QUESTIONS:

1. Can I display more than 500 Items in the thingworx composer?

2. Is infotable able to handle more than 500 rows? If yes how?

1-Visitor
Mar 29, 2016 7:03 PM UTC

1. I don't know, but I don't think so. You will need to build a mashup if you want to get more.

2. Yes, maxItems by default it's 500 ( hardcoded somewhere behind the scenes ), that's the reason you get only 500, just set maxItems to 1000000 and you will get it all.

Carles.

4 replies

1-Visitor
Mar 29, 2016 7:03 PM UTC

1. I don't know, but I don't think so. You will need to build a mashup if you want to get more.

2. Yes, maxItems by default it's 500 ( hardcoded somewhere behind the scenes ), that's the reason you get only 500, just set maxItems to 1000000 and you will get it all.

Carles.

Translate
1-Visitor
Mar 30, 2016 7:33 AM UTC

Thanks,

# 2. works

But for # 1 only 500.

A pagination feature in the composer will be nice.

Translate
1-Visitor
Apr 1, 2016 5:36 PM UTC

I think there's no way around the 500 item limit in the composer (consider the performance impact in an environment with hundreds of thousands of entities). Instead, you can use the filter and tags to find the entities you're looking for.

Translate