To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.
JOB, JOBACTION and ACTION_TRANSACTIONS. JOB is the main has 1 to many JOBACTIONS. JOBACTIONS has 1 to many ACTION_TRANSACTIONS. When I select a JOB from the first table I want to see the corresponding JOBACTIONS in the second table ed.
But as simple as it look it isn't for me. I did a try with FreeformQuery but this type cannot have a filter. Then I tried the TableQuery and that results in an error 'Incorrect syntax near 'LIMIT'.'
I drives me crazy :-)
Who has a good working database example with a working filter.