Form (datagrid) based on query?

0
Hello, Is it possible to have a datagrid based on a query. The datasource, in my case should be something like: SELECT * from Product INNERJOIN Ingrediënt INNERJOIN Recipe WHERE Recipe.Date > now. Support I try to create a shoppinglist, i need the ingredients used in the recipes I have selected for the future. Is this possible and if yes: how? and if no: how to solve this in another way? Thanks! Gerard
asked
2 answers
3

You can use xpath constraints for this

answered
0

You can set a datagrid to receive it's contents from a Microflow. In your retrieve you can set your xpath constraints. However, a datagrid based on a microflow cannot contain associated attributes in the grid.

Maybe you can solve this with a non-persistant entity, which you'll create / fill on demand?

answered