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

when use of poplov in grid how to get data #2

Open
daxlai opened this issue Jul 16, 2022 · 0 comments
Open

when use of poplov in grid how to get data #2

daxlai opened this issue Jul 16, 2022 · 0 comments

Comments

@daxlai
Copy link

daxlai commented Jul 16, 2022

I am not getting data when my first field in IG is pop lov i am getting output like
[{"ORGN_TKTL_ATID":{"v":"2022070789","d":"A700-1"},"TTL_PCS":"6","TTL_CRTS":"","INSUM$ROW":1}]
where "v" data shows my return value and "d" is my display value my query is
SELECT a.ORGN_TKTL_ATID,
A.TTL_PCS,
A.TTL_CRTS
FROM json_table(:P22_JTBL, '$[*]'
columns
ORGN_TKTL_ATID number path '$.ORGN_TKTL_ATID',
TTL_PCS number path '$.TTL_PCS',
TTL_CRTS number path '$.TTL_CRTS'
) a
here in this query if i use
A.INSUM$ROW than it gives me error i am unable to run the page
error is
ORA-20999: Failed to parse SQL query! ORA-06550: line 1, column 1: ORA-40597: JSON path expression syntax error ('$.INSUM$ROW') JZN-00209: Unexpected characters after end of path at position 11

this time my query is
SELECT a.ORGN_TKTL_ATID,
A.TTL_PCS,
A.TTL_CRTS,
a.INSUM$ROW
FROM json_table(:P22_JTBL, '$[*]'
columns
ORGN_TKTL_ATID number path '$.ORGN_TKTL_ATID',
TTL_PCS number path '$.TTL_PCS',
TTL_CRTS number path '$.TTL_CRTS',
INSUM$ROW number path '$.INSUM$ROW'
) a
guide me

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

1 participant