Skip to content
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

【APIJSON嵌套查询】关于APIJSON查询树级结构返回数据不正确的问题,在线救急!!求大佬帮忙~ #761

Open
AwenJackson opened this issue Sep 18, 2024 · 1 comment

Comments

@AwenJackson
Copy link
Contributor

Description

表结构如下:
image

APIJSON查询请求参数如下:
image

返回的接口数据如下:
image

但是返回的数据中authorinfo的数据返回不正确,正确的返回数据应该是如下(手动拼接的):

image

我想问一下,我的请求参数哪里写的有问题?
是不是这里写的有问题 "parent_tb_id@": "author[]/P33708_c_author/authordesc[]/P33708_c_authordesc/id"

@TommyLemon 大佬,麻烦帮我看一下哈,谢谢~~~

@TommyLemon
Copy link
Collaborator

@Explain: true 或者控制台看下生成的 SQL 是否正确,以及直接在数据库执行结果是否正确。
另外 数组对象 不建议嵌套在 表对象 里,这样加深了不必要的层级,也用不了 SQL JOIN。

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

No branches or pull requests

2 participants