Cast association to object in XPath

Iā€™m trying to iterate through a list and count each instance of a particular association. My issue is when I write an XPath constraint I cannot test for equality because I am comparing type String to type association. Is there a way to cast the association to a string or another way to go about this. Here is my microflow . And I have attached a picture of my domain model below. I am checking for instances each buyer appears in a transaction (i.e. Walmart ā€“ 4 transactions, Costco ā€“ 6 transactions)  
1 answers

The most efficient way is to create an OQL-command for that. Download the OQL from Appstore, in your micrflow create an variable containing the OQL-command and execute the OQL command:

SELECT <yourmodule>.Buyer.Name,COUNT(*) as NumberOfTransactions
FROM  <yourmodule>.Transaction
GROUP BY  <yourmodule>.Buyer.Name

Make it return a list of Name, NumberOfTransactions. 

if you are not comfortable with OQL, then do it in a microflow, but the other way around compared to your current microflow: loop over each Buyer and count the number of tranasctions. See this microflow:


A third way is to add a calculation-attribute to Buyer, call NumberOfTransactions an attach your calculation-microflow to it. Then you only have to read the Buyer’s attribute. Be careful not to have your app calculate it more then necessary.