Question

2
Replies
1712
Views
AswanaR0 Member since 2013 11 posts
TCSL
Posted: 2 years ago
Last activity: 2 years 11 months ago
Closed

Connect-SQL Query is not working in RDB-List,with join function

HI Team,

We are unable fetch the details with Connect-SQL in an RDB-List with below Query.

We cant see any syntax issues.but fetching 0 details.But same Query is working and giving results when we run the Query separately outside of Pega.

{SQLPage:FetchDeviceDetails}select h.household_id as ".HouseHoldID", h.device_id as ".DeviceID"
from {class:NLSN-FW-SDPFW-Data-ANL-HH-DeviceStatus} h
join {class:NLSN-FW-SDPFW-Data-ANL-Device} d
on h.household_id = d.hh_id and h.device_id = d.device_id

Can anyone help on this issue please?

Regards

Aswana

Data Integration
Moderation Team has archived post
Share this page LinkedIn