- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
I have queried through the query activity by taking the schema as 'broadlogRCP' where "NmsBroadLogMsg " is the linked table and i have queired like below with event date and failure type = soft. Is the right way to do.
query :
SELECT B0.iBroadLogId, B0.iMsgId, B1.iBroadLogMsgId FROM NmsBroadLogRcp B0 JOIN NmsBroadLogMsg B1 ON (B1.iBroadLogMsgId = B0.iMsgId) WHERE (B1.iFailureType = 1) AND (B0.tsEvent >= TIMESTAMP WITH TIME ZONE '2020-07-01 00:00:00.000-05') AND (B0.tsEvent < TIMESTAMP WITH TIME ZONE '2020-07-31 00:00:00.000-05') LIMIT 10001
Views
Replies
0 Likes
Total Likes