cookn22
Active Member
I'm using the latest revision of fabrik 1.0.6 and MySQL 4.0.18.
I have a table that is entitled 'Client List', where the database table 'client' is left joined to a table 'cases' on the key 'client_id'. There is a second left join between table 'cases' and table 'case_color' on key 'case_id'. I have the option 'Create table filter for this element' selected for the element 'color_name' in the group '40: case_color - [joined to Client List]'. The type of filter is 'dropdown'
When I go to the table view, I'm getting this error:
ALSO, the error does not appear when the type of filter is set to 'field', but on the other hand a more involved error appears when the type of filter is 'range' (yikes!). I'm not planning on using the range filter, but here's the error:
I have a table that is entitled 'Client List', where the database table 'client' is left joined to a table 'cases' on the key 'client_id'. There is a second left join between table 'cases' and table 'case_color' on key 'case_id'. I have the option 'Create table filter for this element' selected for the element 'color_name' in the group '40: case_color - [joined to Client List]'. The type of filter is 'dropdown'
When I go to the table view, I'm getting this error:
I'm pretty sure I tried to do something like this with a previous revision of fabrik and it worked, but unfortunately I can't get more specific than that (it was awhile ago).Unknown table \'cases\' in on clause SQL=SELECT DISTINCT( case_color.color_name ) AS elText, case_color.color_name AS elVal FROM client LEFT JOIN case_color ON case_color.case_id = cases.case_id\n WHERE TRIM(case_color.color_name) <> \'\' GROUP BY elText ASC
ALSO, the error does not appear when the type of filter is set to 'field', but on the other hand a more involved error appears when the type of filter is 'range' (yikes!). I'm not planning on using the range filter, but here's the error:
Unknown table \'cases\' in on clause SQL=SELECT DISTINCT( case_color.color_name ) AS elText, case_color.color_name AS elVal FROM client LEFT JOIN case_color ON case_color.case_id = cases.case_id\n WHERE TRIM(case_color.color_name) <> \'\' GROUP BY elText ASC
Warning: Invalid argument supplied for foreach() in /home/apache/share/htdocs/uabsap/familycourt/components/com_fabrik/fabrik_table.class.php on line 2599
Unknown table \'cases\' in on clause SQL=SELECT DISTINCT( case_color.color_name ) AS elText, case_color.color_name AS elVal FROM client LEFT JOIN case_color ON case_color.case_id = cases.case_id\n WHERE TRIM(case_color.color_name) <> \'\' GROUP BY elText ASC ' a.mainlevel-nav:link { color:#FFFFFF, font-weight:bold; text-decoration:none; } .fabrikTable a:link { color:#FFFFFF, font-weight:bold; text-decoration:none; } .fabrikTable th a:link { color:#FFCC66; font-weight:bold; text-decoration:none; } .style7 {font-size: 14pt; font-weight: bold; }