AnsweredAssumed Answered

Unable to Query data from CUSTOMER Table

Question asked by mk00557957948356 on Oct 14, 2018

In BOOMI DEV level 1 course I inserted new records in CUSTOMER DB table in prospect traking with USER_ID='Kash', when I  query for the newly added records with a where clause  USER_ID='Kash' in CUSTOMER DB table in daily customer wins, It is showing "Start shape retrieved no documents.". Where is the error & What is the fix?

 

1.inserted new records in CUSTOMER DB table in prospect traking:

2. Query used in customer wins:

SELECT DISTINCT CUSTOMER_ID, NAME, PHONE
FROM CUSTOMER
WHERE MODIFIED_DATE >= ?
AND USER_ID = 'Kash'
AND COMPANY_KEY = '59'
AND NOTIFY_STATUS = 0

Outcomes