OQL with XPath constrain

0
Hello  buddies,   I am using OQL of datasets, I tried to construct an where clause using XPath, but I always got compilation error. Input parameter is an object, Please reference my snapshots.  Could anyone help me on it? Thanks in advance.  select      c.ID MendixId,     c.Name CustomersName,      count(o.TotalPrice) Ordercount,      sum(o.TotalPrice) TotalSpent from Sales.Customer c join c/Sales.Order_Customer/Sales."Order" o where  c.Name=[$Customer/Name] group by c.ID,  c.Name;  
asked
2 answers
3

This isn’t worring. What you can do is building the string in a String value and then sue the object data in the string.

in your case eg:

‘ where  c.Name= ‘’ ’ + $Customer/Name + ‘ ‘’’

You need to be careful with the quote characters abiout the right amount..

answered
0

don’t use the brackets, use where  c.Name=$Customer/Name

answered