SQL

Semantics of XPath expressions part 2 – analysing the SQL

Dec 11, 2015
Mendix
SQL, xPath

In the previous post (semantics of XPath expressions), the semantics of different XPath notations were discussed. Part 2 will be an in-depth analyses of the SQL queries generated by Mendix for each of the XPath expressions. Furthermore it will shed some light on why these XPath expressions return a different data set. If you haven’t read part 1 yet, please do. The data and XPath expressions used First a quick recap of the data used and discussed in part 1. ...

Semantics of XPath expressions

Nov 25, 2015
Mendix
SQL, xPath

XPath expressions can be added to any XPath query in Mendix to constrain the queried Mendix object. The XPath expression can be a combination of variables, operations, functions, keywords and system variables. This post will focus on the semantics of certain XPath expressions with the AND-operator. A seemingly small change in the notation of an XPath expression using this operator can have a huge impact on the retrieved data. Different notations of XPath expressions Consider the following scenario, a team has multiple members (employees) and each employee can speak multiple languages. ...