Counting based on on related field

svenschuldt · 2022-01-10T16:51:04.294Z

Hi,

It is either me or the absurd learning curve I am not able to cope with (which comes back to it being me ). I am developing in all kind of languages but this tool drives me insane … still, I don’t give up but need help

Following (I would guess simple) issue, I am having:

I have two tables (Data Types) one being a project table, the other being a milestone table - both are connected via the project_id - shown as follows:

Screenshot 2022-01-10 at 17.21.531749×649 62.4 KB

Screenshot 2022-01-10 at 17.26.071259×548 76.3 KB

I am trying to do something simple now:

showing a repeated group and within that
showing some base data for each project: project name, project_id … and … the total number of milestones per project - not too much asked for, I guess

However, I cannot get my head around how to calculate the total number of milestones. I can easily count all milestones across all projects but I cannot constraint based on the project_id - I get the most-famous red "More … " asking me to add some further “language elements”, just what is being offered does not make much sense, imho.

Screenshot 2022-01-10 at 17.23.051623×1225 133 KB

The “Parent Group” is a group which is based on the type DB_project - exactly the type I am using for the constraint.

What am I doing wrong here?

P.S. And no, I am not planning to use a backend process, just because of performance issues when it comes to showing the data on the screen - such a thing should not be a backend process, should it?

p.dog · 2022-01-10T17:06:24.918Z

It looks like your query in your search for milestones should just be:
1_project_id=parent group’s DB_Project

Because t_project_id in your DB_milestones table is already of the type “DB_project”. With the way you have built the search in your bottom screenshot, you are trying to get it to search using text, but it is expecting a project data type instead

svenschuldt · 2022-01-10T18:40:42.774Z

That was easy and yet I was so blind

Thanks a lot!