[sims] Discover - group not showing in attendance reports

[coolhands]

I hate discover and sims.

I made a dynamic group in Discover of our Year 7 to 11 LAC students. It shows in sims in focus>groups>discover groups correctly just like others I have there. It has pupils showing. When I go to marksheets I can see it and add it no problem. However when I go to the lesson monitor reports this one is not there to pick (see picture) whereas my other Discover groups are. How can this be. Going round in bloody circles.

 

The 'Y7-11 LAC (CBR)' exists, I can add it to marksheets, but it is missing from lesson monitor reports. Yet allt he other Discover groups are there.

 

>

Edited June 15, 2023 by coolhands

[ajp233]

Student membership of Discover groups starts from the date that group was created. If you then try and run an attendance report where the start date used is prior to the membership start date it will not show up.

 

Use SQL Management studio to identify the base_group_id of the relevant discover group - SELECT [base_group_id],[group_mode_id],[criteria] FROM [simsdbname].[sims].[dw_group] and then use that id to update to membership start dates of pupils in the group - UPDATE [simsdbname].[sims].[sims_member] SET start_date='2022-09-04 00:00:00' WHERE base_group_id=xxxx

[coolhands]

Well to answer this for future reference it is because of the second date range in the box. It seems if it is set to a date before the group was made in Discover it doesn't show as available ie you don't see it. If I set the second date to today (or after group was made) it becomes visible. The report does work correctly retrospectively though ie gives me the correct number of attendances back to September

see pic for second date range adjusted

 

edit as ajp233 says, thankyou

Edited June 16, 2023 by coolhands