ChronoConnectivity WHERE SQL with 2 tables

I got the following problem.. 😑

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

Hi rjransijn,

ChronoConnectivity only supports a single table at the moment so you can't do a compound query like this.

You may be able to work round this by using a MySQL View.

Bob