Skip to content

[Feature] 同一个字段组合条件 即有or也有and #806

New issue

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

Open
jackphang opened this issue Mar 29, 2025 · 1 comment
Open

[Feature] 同一个字段组合条件 即有or也有and #806

jackphang opened this issue Mar 29, 2025 · 1 comment

Comments

@jackphang
Copy link

Description

{
"[]": {

    "Sys_dictionary": {
        "@column": "sys_id,element:element_a,column_label,internal_type,db_type,max_length,comments,display",
        "element:element_a": "sys_id",
        "element:element_b": "context_name",
        "@combine": "((element | element:element_a)) | element:element_b",
        "element": "name"
    }
},
"@explain": "true"

}
同一个字段组合条件报错 , "msg": "Unknown column 'element_a' in 'where clause'", 请问我该如何组合呢?

@TommyLemon
Copy link
Collaborator

TommyLemon commented Mar 29, 2025

没有 "element:element_a": "sys_id" 这样的语法,可以用 @key 映射字段
https://github.com/Tencent/APIJSON/releases/tag/6.3.0

"@key":"element_a:(element);element_b:(element)",
"element_a": "sys_id",
"element_b": "context_name"

或者同字段不同等价条件
#107 (comment)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants