Skip to main content
L
liwei5-Regular Member
5-Regular Member
February 4, 2020
Question

Collection Widget not displaying data as expected

  • February 4, 2020
  • 9 replies
  • 5644 views

Hi guys,

 

In Thingworx Version "ThingWorx 8.4.2-b2151"

 

I'm using Collection widget to make a calendar.

 

I have a datatable with "date" column, column type is "DateTime".

 

When use collection widget, i set the sort column to date column, I have a service to load data from datatable by Month(each time it only load 28-31 rows from datatable base on user's choice of month).

 

Collection widget display correctly on default load, date is in order from 1 to the end of month(Service triggered when mashup loaded), but when user select different month, date order is mess up, no longer sort by date column, even user go back to the default loaded month, date order still mess up.

9 replies

raluca_edu
raluca_edu17-Peridot
17-Peridot
February 5, 2020
Hi,

Try to check SortField property of Collection widget to always sort data.

Hope it helps,
Raluca Edu
L
liwei5-Regular MemberAuthor
5-Regular Member
February 5, 2020

Thank you for reply! I did used the sortField, which is my "Date" column. 

C
Chao1231-Visitor
1-Visitor
February 5, 2020

Hello @liwei ,

 

So you're SortField is binded with date? Can we see this?

L
liwei5-Regular MemberAuthor
5-Regular Member
February 5, 2020

Thank you for reply! Yes it did bind with data, I attached screen shots. I thing I forgot to say is it was working on different server, but it broke after I moved it

C
Chao1231-Visitor
1-Visitor
February 5, 2020

That is strange, the sorting is done Client-Side and shouldn't be affected. Maybe double check your service.

Terms & ConditionsAccessibility statement