Skip to Content
0
Dec 11, 2018 at 05:34 AM

Additional field value in CCO manager DB

96 Views

Hello,

I added an additional field ‘Email’ in Customer Checkout. When I executed query in CCO manager data base there is no any data in field [CCOCS].[RECEIPT].[ADDFLD].

Can you please tell me where I can found the additional field value?

select * from [CCOCS].[RECEIPT] t0

inner join [CCOCS].[AdditionalFieldContainer_ADDITIONALFIELD] t2 on t0.ADDFLD=t2.AdditionalFieldContainer_OBJECTKEY

inner join [CCOCS].[ADDITIONALFIELD] t1 on t1.OBJECTKEY=t2.additionalFields_OBJECTKEY

where t0.ID='P001100001495'

Attachments

query.png (133.4 kB)
receipt.png (121.9 kB)