Hi, I am a new user of Bonita, I wanna ask how can I use column keys feature on UI Designer (Form Editor) to filter nested JSON.
All of the examples that I can find use a direct JSON data (the JSON data straightforward into an array)
Example of direct JSON data :
[ { "postId": 1, "id": 1, "name": "id labore ex et quam laborum", "email": "Eliseo@gardner.biz", "body": "laudantium enim quasi est quidem magnam voluptate ipsam eos\ntempora quo necessitatibus\ndolor quam autem quasi\nreiciendis et nam sapiente accusantium" }, { "postId": 1, "id": 2, "name": "quo vero reiciendis velit similique earum", "email": "Jayne_Kuhic@sydney.com", "body": "est natus enim nihil est dolore omnis voluptatem numquam\net omnis occaecati quod ullam at\nvoluptatem error expedita pariatur\nnihil sint nostrum voluptatem reiciendis et" } ]
and in my case, I need to get my JSON data from a nested form.
Example for nested JSON data:
{ "_type":"Collection", "total":2, "count":2, "pageSize":20, "offset":1, "_embedded": { "elements": [ { "_type":"Project", "id":3, "identifier":"api-test-boi", "name":"API test boi", }, { "_type":"Project", "id":2, "identifier":"your-scrum-project", "name":"Scrum project", }, ] } }
Please help me and thanks
P.S I tried using column keys with this format :
name _embedded.elements[0].name $_embedded.elements[0].name elements[0].name|_embedded