I'm running into an issue getting published pages programmatically. Currently, I'm using
IEnumerable<PageNode> pageNodes = parentNode.Nodes.Where(m => m.ShowInNavigation && (m.ApprovalWorkflowState == "Published" || m.ApprovalWorkflowState == "")).OrderBy(m => m.Ordinal);
which returns published pages but if a page was published but is now in Draft mode currently the page is not returned but it needs to be returned. Basically, I need to be able to get all "live" pages.