HiBob,
I have a select query that uses more join (model),
I would like to add a sql statement like this
and retrieve the value of the field diff_field_name in the list of columns.
how is this possible without using a custom query?
I tested the code on CC Conditions box and it works perfectly, but I have to take the field in the query and put it in the table model.field, otherwise I have to write all custom code
best regards
Cornelio
I have a select query that uses more join (model),
I would like to add a sql statement like this
SELECT (TO_DAYS(date1)-TO_DAYS(date2)) diff_field_name
and retrieve the value of the field diff_field_name in the list of columns.
how is this possible without using a custom query?
I tested the code on CC Conditions box and it works perfectly, but I have to take the field in the query and put it in the table model.field, otherwise I have to write all custom code
best regards
Cornelio