i'm having a problem in converting a mariaDB query to coldbox criteriaBuilder. i not quite understand how to join multi table using criteriaBuilder in coldbox. this is my mariaDB query :
select TerminalInst.* from TerminalInst
inner join Terminal on TerminalInst.terminal_id = Terminal.id
inner join custinst on TerminalInst.custinst_id = custinst.instID
where Terminal.description like '%value%'
how to convert this query to criteriaBuilder? please help me..
Try something like this (within a handler):
where