Repeating group filter is too slow, alternatives?

[melbournemarsden]

I made a tool that basically takes time and location linked slots from a calendar (“sessions”) filled with “tests” of various “statuses”.

Here is my dilemma:

I only want ‘sessions’ to show up in this repeating group if there are ‘tests’ of a certain ‘status’ in it.

“Do a search for tests:grouped by session” works perfectly, but unless I’m an idiot there is no way to really sort the data? I need it to be alphabetical by one of the fields of the group’s “session”. I can’t find any way to use the :sorted by operator to sort the list.

“Do a search for sessions:filtered by advanced search:tests that match status type” works perfectly, but loads EXTREMELY slowly.

“Do a search for sessions” and then using a group that takes up the whole area of the repeating group set to hide and collapse height when there are no tests that meet the status works perfectly AND loads fast. But then I end up with like 2000 pixels of blank space underneath the repeating group. It seems like the RG is still allocating all the space for the hidden cells.

Anyone have any ideas?

Thanks!

[jcpollari]

No ideas to help sorry, but interested in the answer for my own program.

[GH5T]

Make sure ignore empty constraints is checked. Also, to get faster results, call what you need from backend API, and respond with the results you want the user to see. Front-end “do a search for” will kill your app if you scale.