I want to retrieve data from "FeedTrackedChange" table between particular time period. For Example:
select * from FeedTrackedChange where CreatedTime >= jan 2000
But the problem here is there is no timestamp field for "FeedTrackedChange" table. I believe 'FeedItem' table is the parent table of FeedTrackedChange which is having 'CreatedDate' field. Can we create something like
select * from FeedTrackedChange where FeedTrackedChange.feeditemid in (select id from FeedItem where createdDate <= Starttime AND CreatedDate > Endtime)
Kindly help me here. Thanks in advance