Hi,
I have a table named "Profesionales" with a field named "Tipo" which is a multiselect dropdown databasejoin field that links with table "Profesionales_categorias", field "id".
I want to add a "fabrik list" menu item that lists only those records where "Tipo" = 2 were selected so I add a prefilter to the "Tipo" field and set "EQUALS / 2 / NoQuote".
This is the result I cannot resolve (see the last WHERE is the issue):
Help will be appreciated.
Regards,
Mauro.
I have a table named "Profesionales" with a field named "Tipo" which is a multiselect dropdown databasejoin field that links with table "Profesionales_categorias", field "id".
I want to add a "fabrik list" menu item that lists only those records where "Tipo" = 2 were selected so I add a prefilter to the "Tipo" field and set "EQUALS / 2 / NoQuote".
This is the result I cannot resolve (see the last WHERE is the issue):
PHP:
getData:Unknown column 'jl2_fb_profesionales_repeat_tipo.tipo' in 'where clause' SQL=
SELECT SQL_CALC_FOUND_ROWS DISTINCT
`jl2_fb_profesionales`.`id` AS `jl2_fb_profesionales___id`,
`jl2_fb_profesionales`.`id` AS `jl2_fb_profesionales___id_raw`,
(SELECT GROUP_CONCAT(jl2_fb_profesionales_categorias.descripcion SEPARATOR '//..*..//') FROM jl2_fb_profesionales_repeat_tipo LEFT JOIN jl2_fb_profesionales_categorias ON jl2_fb_profesionales_categorias.id = jl2_fb_profesionales_repeat_tipo.tipo WHERE parent_id = `jl2_fb_profesionales`.`id`) AS jl2_fb_profesionales_repeat_tipo___tipo,
(SELECT GROUP_CONCAT(id SEPARATOR '//..*..//') FROM jl2_fb_profesionales_repeat_tipo WHERE parent_id = `jl2_fb_profesionales`.`id`) AS `jl2_fb_profesionales_repeat_tipo___tipo_raw`,
(SELECT GROUP_CONCAT(tipo SEPARATOR '//..*..//') FROM jl2_fb_profesionales_repeat_tipo WHERE parent_id = `jl2_fb_profesionales`.`id`) AS jl2_fb_profesionales_repeat_tipo___tipo_id,
(SELECT GROUP_CONCAT(params SEPARATOR '//..*..//') FROM jl2_fb_profesionales_repeat_tipo WHERE parent_id = `jl2_fb_profesionales`.`id`) AS `jl2_fb_profesionales_repeat_tipo___params`,
`jl2_fb_profesionales`.`ocupacion` AS `jl2_fb_profesionales___ocupacion`,
`jl2_fb_profesionales`.`ocupacion` AS `jl2_fb_profesionales___ocupacion_raw`,
`jl2_fb_profesionales`.`nombre` AS `jl2_fb_profesionales___nombre`,
`jl2_fb_profesionales`.`nombre` AS `jl2_fb_profesionales___nombre_raw`,
`jl2_fb_profesionales`.`descripcion` AS `jl2_fb_profesionales___descripcion`,
`jl2_fb_profesionales`.`descripcion` AS `jl2_fb_profesionales___descripcion_raw`,
`jl2_fb_profesionales`.`direccion` AS `jl2_fb_profesionales___direccion`,
`jl2_fb_profesionales`.`direccion` AS `jl2_fb_profesionales___direccion_raw`,
`jl2_fb_profesionales`.`telefono` AS `jl2_fb_profesionales___telefono`,
`jl2_fb_profesionales`.`telefono` AS `jl2_fb_profesionales___telefono_raw`,
`jl2_fb_profesionales`.`email` AS `jl2_fb_profesionales___email`,
`jl2_fb_profesionales`.`email` AS `jl2_fb_profesionales___email_raw`,
`jl2_fb_profesionales`.`website` AS `jl2_fb_profesionales___website`,
`jl2_fb_profesionales`.`website` AS `jl2_fb_profesionales___website_raw`,
`jl2_fb_profesionales`.`userid` AS `jl2_fb_profesionales___userid_raw`,
`jl2_users`.`id` AS `jl2_fb_profesionales___userid`,
`jl2_fb_profesionales`.`image_logo` AS `jl2_fb_profesionales___image_logo`,
`jl2_fb_profesionales`.`image_logo` AS `jl2_fb_profesionales___image_logo_raw`,
`jl2_fb_profesionales`.`id` AS slug ,
`jl2_fb_profesionales`.`id` AS `__pk_val`
FROM `jl2_fb_profesionales`
LEFT JOIN `jl2_users` AS `jl2_users` ON `jl2_users`.`id` = `jl2_fb_profesionales`.`userid`
WHERE ( jl2_fb_profesionales_repeat_tipo.tipo = 2 )
ORDER BY `jl2_fb_profesionales`.`nombre` ASC LIMIT 0, 10
Help will be appreciated.
Regards,
Mauro.