我正在尝试运行此查询,这将使我计数
但它确实有效

def query  = "select count(A.id) from Artifact A "+ 
             "LEFT JOIN A.classification C on (A.id=C.artifactId) "+ 
             "where C.id IS NULL"; 
def tc = Artifact.executeQuery(query); 

请您参考如下方法:

这可能会有所帮助:

def query  = "select count(A.id) from Artifact A "+ 
             "LEFT JOIN A.classification C "+ 
             "where C.id IS NULL"; 
def tc = Artifact.executeQuery(query); 

您无需在此处启用,因为Artifact应该已经通过映射与分类“连接”了。


评论关闭
IT序号网

微信公众号号:IT虾米 (左侧二维码扫一扫)欢迎添加!