Question

XPATH reference

0

Hello, I do have a table “BUDGET” with has an association to table “SERVICES” BUDGET > SERVICES I now want to build a page in which I list all SERVICES and in there see all BUDGET items linked to that service. So I created a templated grid (#TG1)with an XPATH to SERVICES. Within the templated grid I created an other templated grid (#TG2) with an XPATH to BUDGET. Within the #TG2 I want to put in an XPATH constraint filtering only the items for the current service element. I could not find any function to get the current service item of #TG1.

asked 2020-04-24

Martin Bordt

3 answers

Ronald Catersels · Answer 1 · 2020-04-24

For XPaths you have the token [%CurrentObject%]

Regards,

Ronald

[EDIT]

See documentation here: https://docs.mendix.com/refguide/xpath#1-overview-of-xpath

Martin Bordt · Answer 2 · 2020-04-24

Honstely the idea of Mendix is OK.

But if you are familiar with MS Access development, you hit the limits of Mendix in no time.

why is it such a nightmare to run a query against the data base. Everyone knows SQL, where data can be filtered, grouped, calculated, etc.

Just look at the documentation – the constraints is documented OK – and the video helps a bit.

There is no propper documentation for the function, like sum – no video – nothing.

In the time I send figuring out how to do it, I have done the complete project in MS Access.

Rene van Hofwegen · Answer 3 · 2020-04-24

Dear Martin,

As I can deduct from you points and status, you haven’t followed the online learning paths and didn’t take the rapid developer exam. Which is 100% your own choice to invest or not to invest that time. But the moment you start comparing Mendix with MS access you do miss a big point. Mendix != Ms Access

Online academy: https://academy.mendix.com/link/home

Next to that, the solution you need doesn’t require an XPath at all. You can nest the 2^nd template grid into the context of the service and just connect it using the path directly. This works out of the box, just a few clicks. This is explained in the rapid developer learning path; https://academy.mendix.com/link/path/31/Become-a-Rapid-Developer-(Analyst)