Didn't want to change the database structure as it would have been just
wayy too much repetitive data.
I did find a solution to my problem:
First find the json_dir_ids that I want and make the grid's query be that,
then use the grid's left join parameter.
For instance, referring to my origina
This is causing a big work stoppage for me. If I cannot find the solution,
I will have to redesign my database tables. Currently I have:
json_dir:
- build
- program
- directory
block_info:
- block_name
- filename
- json_dir_id
And given a build and program (or multi
No, the issue is not in the query because the grid is being populated with
the rows that I would expect. Also, I am using double equal signs when I
build the query, but when I print it it shows only single '=', I assume
because it has already been converted to regular SQL syntax.
Any other id
i think query is should be about comparation not assignment.
e.g.
(((block_info.json_dir_id == json_dir.id) AND (json_dir.build == 'unknown'))
AND (json_dir.program == 'test'))
not
(((block_info.json_dir_id = json_dir.id) AND (json_dir.build = 'unknown'))
AND (json_dir.program = 'test'))
best
4 matches
Mail list logo