wondering if you can assist me with correct syntax or point me in the right direction.
I have your grid display information for a roster. Its is a list of shifts (called ReturnedSolves) which has a start and end time, a field saying if its a day or night roster and a link to the staff table (called MSCO) which holds their names and disciplines.
The roster looks like this which is fantastic, but it’s displaying data out of order.
Im using Unique elements to get my list of staff
So far so good.
I then dynamically add in the number of date columns by using a date range picker and looping the addition of a column until I hit the end date
The problem is the day and night shifts don’t match the user. They just fill up the rows from top to bottom.
I realise Im not noting in the search for shift the MSCO (or staff member ) that’s being searched for to match correctly. Its should be something like this
but I don’t know how to match the operator to the table im searching.
So my question is am I approaching the problem correctly in the first place or is there a way I can link the ID of the Row’s MSCO’s and reference them in the query?
Thanks for reading this far