Closed zyenggook closed 3 weeks ago
查询过滤使用month,无法查询到数据 如图bill_month字段类型为varchar,值设置了3种,一个都查询不到
点击搜索之后url参数中bill_month携带的值是2023-10,如下图
laravel-debugger里显示的sql语句如下图
貌似对月份查询的值没有进行处理,month(’bill_month‘)=’2023‘ ??,url参数中bill_month改成10就能查询到
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.
Description:
查询过滤使用month,无法查询到数据
如图bill_month字段类型为varchar,值设置了3种,一个都查询不到
点击搜索之后url参数中bill_month携带的值是2023-10,如下图![1701255988309](https://github.com/jqhph/dcat-admin/assets/13347903/b09a83d3-3292-40cf-a2b2-fabf4162e782)
laravel-debugger里显示的sql语句如下图![1701256053885](https://github.com/jqhph/dcat-admin/assets/13347903/50ff7f05-37c1-4476-9b50-78773825c93d)
貌似对月份查询的值没有进行处理,month(’bill_month‘)=’2023‘ ??,url参数中bill_month改成10就能查询到
Steps To Reproduce: