yff的动态消息

我修改了一下sql，select id as "id",bat_no as "bat_no",pal_no as "pal_no",pstatus as "pstatus",ptype as "ptype",quantity as "quantity",tenant_id as "tenant_id",create_user as "create_user",create_time as "create_time",create_dept as "create_dept",update_user as "update_user",update_time as "update_time",is_deleted as "is_deleted",(select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no) as "snquantity" from tab_palinfo tbl where tbl.is_deleted = 0 AND #{jeelowcode_auto_where} 去掉哪些过滤，只保留了AND #{jeelowcode_auto_where}，我不使用查询条件，可以查询出数据，只要增加查询条件，就抛空指针

java.lang.NullPointerException

at com.jeelowcode.framework.plus.build.buildmodel.wrapper.SqlInfoQueryWrapper$Wrapper.buildSql(SqlInfoQueryWrapper.java:215)

at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.getAutoWhereSql(JeeLowCodeAnnoaionAspectjSQL.java:559)

at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.executeEnhanceAfterPage(JeeLowCodeAnnoaionAspectjSQL.java:318)

at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.executSQLPlugin(JeeLowCodeAnnoaionAspectjSQL.java:215)

at com.jeelowcode.core.framework.config.aspect.enhance.JeeLowCodeAnnoaionAspectjSQL.afterReturingAdvice(JeeLowCodeAnnoaionAspectjSQL.java:114)

at sun.reflect.GeneratedMethodAccessor892.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

如何根据查询条件过滤其他表的数据

yff

2026-05-19 09:47

你好，有空帮忙看看上面那个sql对不对

如何根据查询条件过滤其他表的数据

yff

2026-05-18 18:18

我在sql增强中这样配置，查询报空指针异常，(select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no) as "snquantity" 这个是我设置的一个虚拟字段，虚拟字段使用sql查询，帮忙看看这个哪里不对。。

select id as "id",

bat_no as "bat_no",

pal_no as "pal_no",

pstatus as "pstatus",

ptype as "ptype",

quantity as "quantity",

tenant_id as "tenant_id",

create_user as "create_user",

create_time as "create_time",

create_dept as "create_dept",

update_user as "update_user",

update_time as "update_time",

is_deleted as "is_deleted",

(select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no) as "snquantity"

from tab_palinfo tbl where 1=1

AND

IFNULL(#{sn_numstatus} '') = '',

OR #{sn_numstatus} = 0 and tbl.quantity > (select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_no)

#{sn_numstatus} = 1

AND tbl.quantity = (select count(sn.id) as sn_quantity from tab_info sn where sn.is_deleted = 0 and sn.status = 1 and sn.pal_no = tbl.pal_noo)