I got the following problem.. 😑
In the Query Related Settings of ChronoConnectivity..
In WHERE SQL i got the next sql query:
I try to filter the records with the input of 2 tables.
So the BASE table has all the subprojects of PROJECT, and PROJECT table has the status of the project.
When a PROJECT has Status "Ended" the records don't show, only when status "Started" the subprojects show.
Please help.. thanks in advance
In the Query Related Settings of ChronoConnectivity..
In WHERE SQL i got the next sql query:
, PROJECT WHERE BASE.ID LIKE PROJECT.ID AND PROJECT.Status LIKE 'Started'
I try to filter the records with the input of 2 tables.
So the BASE table has all the subprojects of PROJECT, and PROJECT table has the status of the project.
When a PROJECT has Status "Ended" the records don't show, only when status "Started" the subprojects show.
Please help.. thanks in advance