Allow using [SomeStringXpath] as XPath query in the retrieve from database microflow action.
There are situations where it is not known before which search criteria to use:
In such case, putting the Xpath together is a pain. It is possible to check whether the variable is set in the XPath itself but that degrades performance of the final SQL statement. It would be best to only include the search criteria that are relevant. That is easy to do with basic string functions in the microflow.
Now I often use a small Java action to do the retrieve.
If anyone needs a Java action, we have made one here: https://github.com/shelterbox/mx_RetrieveByXpathString/releases/download/1.0.0/RetrieveByXpathString.mpk
… or get it from the Marketplace: https://marketplace.mendix.com/link/component/205255
Has this feature been implemented yet? Thanks
is there a release date know for this feature?
Having this as a native Mendix functionality would be indeed very positive.
Good news to see that it is a planned feature. In the mean time, for those interested, I recommend the solution by Andrej Koelewijn on https://github.com/ako/QueryApiBlogPost.