将mariaDB查询转换为ColdBox条件

Question

我在将mariaDB查询转换为coldbox criteriaBuilder时遇到了问题。我不太懂如何在冷盒中使用criteriaBuilder连接多个表。这是我的mariaDB查询：

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%'

如何将此查询转换为criteriaBuilder？请帮帮我..。

Answer 1

尝试这样的方法(在处理程序中)：

property name="terminalInstService" inject="model:terminalInstService"; //for cbox 3.8.x
property name="terminalInstService" inject="model"; // for cbox 4.2.x

cr = terminalInstService.newCriteria();  
cr.createAlias('terminals','t')
   .createAlias('custinsts','c')
   .ilike('t.description','%value%');

results = cr.list();

哪里

terminals = relationship name between TerminalInst and Terminal
custinsts = relationship name between TerminalInst and custinst
and ilike is for case in-sensitive like