select new map(o.id as id,o.name as name,o.parent.id as parent,o.order as order)
from Org o left join o.parent where 1=1
本文介绍如何使用SQL查询语句从组织表及其父表中选择特定字段,包括ID、名称、父ID和顺序,以获取所需的地图数据。
select new map(o.id as id,o.name as name,o.parent.id as parent,o.order as order)
from Org o left join o.parent where 1=1

被折叠的 条评论
为什么被折叠?