Skip to content

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

@daxlai

Description

@daxlai

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions