Show Documents Where IsPublished = 'true'( PublishFromDate and PublishToDate). SQL Query to Resulting the above requirement
Below is the example how to fetch the published tree node items. You can create your custom table with ItemPublishedFrom and ItemPublishedTo column and provide IsPublished functionality to that custom table. I am sure this will help you a lot while you need the publish feature on custom table. So why you should create a page type instead a custom table to do a simple functionality.
Select * from [dbo].[View_GTH_Seller_Joined] Where DocumentCulture ='en-au'
AND (DocumentPublishFrom <= GetDate() OR DocumentPublishFrom IS NULL) AND (DocumentPublishTo >= GetDate() OR DocumentPublishTo IS NULL)
