Edited Request:
Original Request:
I frequently use JSON Templates to build custom AI components in my clients’ applications. However, I’ve noticed that when working with JSON arrays, I often need to create a dedicated JSON Template column in the entity table for each specific JSON array used in queries or relations.
It would be beneficial to introduce a new column type that supports JSON queries across multiple properties in queries and relations.
Exemple without this feature:
Table1 has property1, property2 and property3 and a json template for these three properties.
Table2 has a query on table1, a joined list column on the json template from the query, a template column to make the array “[” + joined list + “]”.
Exemple with this feature:
Table1 has property1, property2 and property3.
Table2 has a query on table1, an advanced JSON query column that result in [{property1:“”, property2:“”,property3:“”},{property1:“”, property2:“”,property3:“”},{property1:“”, property2:“”,property3:“”}]