We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
环境信息
问题描述
子查询中没办法引用父查询的字段 数据库结构和数据如下: apijson如下:
{ "[]": { "Lrx_student": { "sid}{@": { "from": "Lrx_score", "Lrx_score": { "@column": "sid;grade", "sid@": "[]/Lrx_student/sid", //没办法引用 "grade>":"90" } } } }, "@schema": "lrx" }
结果如下:
错误信息
The text was updated successfully, but these errors were encountered:
目前不支持在子查询中引用赋值,可以反过来写,EXISTS 改为 IN,里面就不需要引用赋值(外键关联)键值对了
{ "[]": { "Lrx_student": { "sid{}@": { "from": "Lrx_score", "Lrx_score": { "@column": "sid;grade", "grade>":"90" } } } }, "@schema": "lrx" }
https://github.com/Tencent/APIJSON/blob/master/Document.md#3.2
打算后续支持在子查询中引用赋值,可以在建议收集箱 issue 提个建议看看多少人点赞(需要这个功能) #37
Sorry, something went wrong.
No branches or pull requests
环境信息
问题描述
子查询中没办法引用父查询的字段
数据库结构和数据如下:
apijson如下:
结果如下:
错误信息
The text was updated successfully, but these errors were encountered: