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
WHERE MODIFIED_DATE >= ?
AND USER_ID = 'Kash'
AND COMPANY_KEY = '59'
AND NOTIFY_STATUS = 0