Hello,
I have a table with group_names and a table with groups. In groups I save a bunch of record IDs for a given group_name. Now I want to be able to tell the user, how many entries there are for a single group_name (so doing a count(*)).
I have a field member_count that uses getSize over the relation to groups. That gives me 40 every time a group has more than 40 members. In formulas I don't have access to the DatabaseManager, so I can't do a count (*).
The only way I see right now is to run a method onShow of the groups form, that retrieves the counts for all groups and then walks through the groups and inserts this value manually. That is not so nice.
Any ideas?
A nice enhancement would be if we could use aggregations on relations!
Thanks, Patrick
P.S. I know you Servoyans don't like those "expensive" operations, but sometimes they are useful and if it takes too long it's not your fault, is it?