Company Shifts(timings) maintainence in Multitentant Application.

[ss-10]

Hi,

We are working on a multi-tenant application, where we need to save data from devices.The companies operate in different shifts and the data also needs be retrieved shiftwise.

Now what is the better way to create a Shifts.

1) Create Shift Thing for each Shift.Retreive using thingworx Services.

2) Create a DataTable(db table) and save every Shift as a row in the Table and retrieve the shifts via query.Since it is not a real world entity.

[ptc-5082906]

Hello Shiva S​,

I would go with the 2nd option. It is a scalable, easy to maintain solution and also it's easier to retrieve and filter the data stored in the Table.

Please let us know how you implement it, we really appreciate your answer.