How to retrieve tickbox (Y/N) as a custom field to another view?

Hi @mingram,

is the  EMAIL_ORDER_CONF_DB in CUST_ORD_CUSTOMER_API connected to a public method?

If yes, create a expression type custom field in the “Customers – Sales Specific Information”.

In the expression statement, call te getter method passing the customer id.

Hope this helps!

Best Regards,
Bhagya

How can I check that?

Hi @mingram,

In the API CUST_ORD_CUSTOMER_API  check whether there is a getter method for EMAIL_ORDER_CONF_DB.

Example:
 

Or else try to write a SQL statement to retrieve the EMAIL_ORDER_CONF_DB from view.

Example:

select  EMAIL_ORDER_CONF_DB
from VIEWNAME
where customer_id=CUSTOMER_ID


VIEWNAME =  The underlying view which contains the EMAIL_ORDER_CONF_DB
customer_id = In the view “VIEWNAME ”, the relevant customer_id field name
CUSTOMER_ID = In the window, “Customers – Sales Specific Information” field name

Example:
 

Best Regards,
Bhagya