APIJSON icon indicating copy to clipboard operation
APIJSON copied to clipboard

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

Open jackphang opened this issue 10 months ago • 1 comments

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'", 请问我该如何组合呢?

jackphang avatar Mar 29 '25 02:03 jackphang

没有 "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"

或者同字段不同等价条件 https://github.com/Tencent/APIJSON/issues/107#issuecomment-1864625732

TommyLemon avatar Mar 29 '25 05:03 TommyLemon