Let variable returns String as field-attribute

[erp_curaden]

I ran into another issue:

I was trying to assign a String to a "Let"-variable. However, whatever I try, it always returns the variable with "-quotes instead of ' (I use this variable in a "Where"-statement):

Example (in which $(currentCustomerEMail) is interpreted as a Field-value):

Let currentCustomerEMail='email@mail.com';

Load
Count(OrderEMail) As "NumberOfOrders"
Resident Order
Where $(currentCustomerEMail)='xyz';

Thanks for your help 😉

[agigliotti]

what are you trying to do with that load?

[erp_curaden]

Hi Agigliotti,

This part of the code is contained within a loop. So I have a number of customers (IDs) and a series of dates (YearMonth) I'm looping through to get the count of orders for each timestamp (YearMonth).

[agigliotti]

i don't understand  Where $(currentCustomerEMail)='xyz';
what does it means?
what is the logic behind this condition?

[erp_curaden]

I'm looping through a table of all orders, and I only want the ones where the Email address of the order table corresponds to the current customer in my loop.

[agigliotti · Accepted solution]

let's try using the below syntax:
Where '$(currentCustomerEMail)'='xyz';