[错误报告]: 使用LambdaQueryWrapper中出现can not find lambda cache for this property

[redcarp666]

确认

• 我的版本是最新版本, 我的版本号与 version 相同, 并且项目里无依赖冲突
• 我已经在 issue 中搜索过, 确认问题没有被提出过
• 我已经修改标题, 将标题中的 描述 替换为遇到的问题

当前程序版本

3.5.1

问题描述

代码如下, Entity是有effectiveStartTime的

public class EmConversionCoefficient extends BaseEntity {
	@ApiModelProperty(value = "名称")
	private String name;
	@ApiModelProperty(value = "生效开始月份")
	@JsonFormat(pattern = "yyyy-MM")
	private String effectiveStartTime;
	@ApiModelProperty(value = "生效结束月份")
	@JsonFormat(pattern = "yyyy-MM")
	private String effectiveEndTime;
	@ApiModelProperty(value = "组织ids（以英文逗号间隔）")
	private String refOrgIds;
	@ApiModelProperty(value = "备注")
	private String remark;
	@ApiModelProperty(value = "是否删除")
	@TableLogic
	@TableField(fill = FieldFill.INSERT)
	private Integer deleted = 0;
}

private LambdaQueryWrapper<EmConversionCoefficient> getQueryWrapper(EmConversionCoefficientVo.EmConversionCoefficientPageListInput input) {
		LambdaQueryWrapper<EmConversionCoefficient> wrapper = getBaseWrapper(input);
		wrapper.like(StringUtils.isNotEmpty(input.getName()),
		             EmConversionCoefficient::getName,
		             IbfStringUtil.replaceSpecialCharOfLike(input.getName()));
		wrapper.le(null != input.getEffectiveEndTime(),
		           EmConversionCoefficient::getEffectiveStartTime,
		           input.getEffectiveEndTime());
		wrapper.ge(null != input.getEffectiveStartTime(),
		           EmConversionCoefficient::getEffectiveEndTime,
		           input.getEffectiveStartTime());
		return wrapper;
	}

default <Input extends BaseQueryInput> LambdaQueryWrapper<T> getBaseWrapper(Input input) {
        LambdaQueryWrapper<T> wrapper = Wrappers.lambdaQuery();
	    wrapper.like(ObjectUtil.isNotEmpty(input.getCreator()), BaseEntity::getCreator, input.getCreator()).like(
			    ObjectUtil.isNotEmpty(input.getModifier()),
			    BaseEntity::getModifier,
			    input.getModifier());
	    wrapper.between(ObjectUtil.isNotEmpty(input.getCreateStartTime()) && ObjectUtil.isNotEmpty(input.getCreateEndTime()),
	                    BaseEntity::getCreateTime,
	                    input.getCreateStartTime(),
	                    EmDateUtil.endOfDay(input.getCreateEndTime()));
	    wrapper.between(ObjectUtil.isNotEmpty(input.getModifyStartTime()) && ObjectUtil.isNotEmpty(input.getModifyEndTime()),
	                    BaseEntity::getModifyTime,
	                    input.getModifyStartTime(),
	                    EmDateUtil.endOfDay(input.getModifyEndTime()));
        return wrapper;
    }

详细堆栈日志

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfNormal'. Cause: org.apache.ibatis.ognl.OgnlException: sqlSegment [com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: can not find lambda cache for this property [effectiveStartTime] of entity [cn.zjky.ibf.em.bim.entity.EmConversionCoefficient]]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
	at com.sun.proxy.$Proxy144.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy172.selectPage(Unknown Source)
	at com.baomidou.mybatisplus.extension.service.IService.page(IService.java:389)

[miemieYaho]

你有basemapper< EmConversionCoefficient >并且被正确加载了吗?

[redcarp666]

你有basemapper< EmConversionCoefficient >并且被正确加载了吗?

@Mapper
public interface EmConversionCoefficientMapper extends BaseMapper<EmConversionCoefficient> {

}

@miemieYaho 有的

[miemieYaho]

那你Wrappers.lambdaQuery(EmConversionCoefficient.class)

[redcarp666]

那你Wrappers.lambdaQuery(EmConversionCoefficient.class)

• 这样是可以，那就是得传LambdaQueryWrapper参数进去了。

• 

• 使用时，必须在后面拼接上公共条件的字段才不会报错。

• 

[nieqiurong]

也可以改成一下传入子类类型创建或者通过父类初始化的QueryWrapper后回来在setEntityClass一下