Data Mapper - Count based on condition

David Paras

• October 06, 2015 19:42

I have a database source schema and would like to have a count of total number of occurrences based on condition.

I am using this one

count($Input_Invoice_Advanced_Database_Schema/DB/tblEDIInvoices/Orders/AmTx5 > '0.00')

It is returning 1, which is not true as per the data.

Can you please suggest how to get the total number of occurrences of that particular element based on a condition?

0

• 

  David Paras

  • October 06, 2015 19:45

  Try the following

  count($Input_Invoice_Advanced_Database_Schema/DB/tblEDIInvoices/Orders[AmTx1>0.0000])

  The "Orders[AmTx1>0.0000] " will return orders where the AmTx1 value is greater than 0.0000. The count function will then return the number of records that fulfill that condition.

  0

Post is closed for comments.