topic Re: Let variable returns String as field-attribute in App Development

Let variable returns String as field-attribute

erp_curaden — Sat, 16 Nov 2024 20:07:42 GMT

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 😉

Re: Let variable returns String as field-attribute

agigliotti — Fri, 06 Sep 2019 08:38:15 GMT

what are you trying to do with that load?

Re: Let variable returns String as field-attribute

erp_curaden — Fri, 06 Sep 2019 08:45:16 GMT

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).

Re: Let variable returns String as field-attribute

agigliotti — Fri, 06 Sep 2019 08:50:01 GMT

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

Re: Let variable returns String as field-attribute

erp_curaden — Fri, 06 Sep 2019 09:11:21 GMT

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.

Re: Let variable returns String as field-attribute

agigliotti — Fri, 06 Sep 2019 09:25:10 GMT

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