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
Pegasystems Inc.
US
Hi Aswana,
Based on the above query, it looks like you are using the table column names instead of Class property names something like below syntax,
{SQLPage:FetchDeviceDetails} select h.[ADD PROPERTY NAME] as ".HouseHoldID", h.[ADD PROPERTY NAME] as ".DeviceID"
from {Class:NLSN-FW-SDPFW-Data-ANL-HH-DeviceStatus} h
join {Class:NLSN-FW-SDPFW-Data-ANL-Device} d
on h.[ADD PROPERTY NAME] = d.[ADD PROPERTY NAME] and h.[ADD PROPERTY NAME] = d.[ADD PROPERTY NAME]
Can you try this way and let us know the result.
Regards
Mahesh
Pegasystems Inc.
IN
Hi Aswana,
You can also trace your connect-sql and check the exact query that triggered from Pega.
There may be a difference that you would find from expected.
Regards,
Ujjwal