How to write this Xpath..2 entities..LoanRequest and Author. A loan request is associated to an author.
How to write this Xpath..2 entities..LoanRequest and Author. No association. Author inherits from System.User and has 2 attributes minAmount, maxAmount. I need to create a data grid of LoanRequest with datasource as database and Xpath such that I show only those LoanRequest where its attribute loanAmount lies between minAmount and maxAmount of the logged-in user. I need to do this with xpath+database as source and not microflow due to performance reasons.
I don't think you can use an xpath on a grid directly, but you can use a microflow to prepare the data and then use an intermediate associated object to show it, i.e. you don't have to use a microflow as the datagrid source and do the query every time.