You’re offline. This is a read only version of the page.
Announcements
Hi,
Wondering if it's possible to get some help / insight.
Say I have a table containing all sales data and i'm connecting to this using the SQL Server connection.
My sales table has columns: orderNumber, customerNumber, orderDate, orderAmount.
Can anyone explain how I can use the ODATA options in the SQL connector to count the number of orders by customerNumber? For example - I only want to return results where a customer number only appears once in the table.
I've tried various aggregate queries i've found online but haven't managed to succeed yet.
Thanks in advance.
Hi @24492IV,
In your filter Query add customerNumber eq xxxxx, then add a compoe action.
Hope this helps.
Thanks
Share
Report
All responses (
Answers (
32,865
