Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Вытащил filters и получил
- select * from (select * from jsonb_populate_recordset(null::tp_filters, (select '{"title": "Отчёт1", "filters": [{"name": "Дата с", "value": "30.01.1999", "property": "datebeg"}, {"name": "Дата по", "value": "31.01.1999", "property": "dateend"}], "selection": [{"name": "Код", "index": 0, "orderby": null, "property": "Id", "isvisible": true}, {"name": "Наименование", "index": 1, "orderby": 1, "property": "Name", "isvisible": false}]}'::jsonb->'filters'))as filter) as prop
Add Comment
Please, Sign In to add comment