$data->render_sql

Webix JS
1

hi
Can you tell me why or where i am going wrong which this as it is not returning schedules.name

$data->render_sql(“SELECT resource_id, resources.name,
schedules.name FROM resources INNER JOIN schedules ON resources.schedule_id = schedules.schedule_id
where schedules.name <> ‘Default’” , “resource_id”, “name”, “name”);

many thanks

2

Hi, did you try to execute the raw query in your database? Does it return the data?