How to create view, group by or filter on publish status?

Question

I created a document library. The library has the following version settings below. I have some documents which are published and have a major version. Other documents are draft and has a minor version. How can I group or filter on published status? I would like to filter on draft documents? Or filter on published documents.

UPDATED

I created a calculated field like Domenico suggested me. It looks like when I add the calculated field it works. When I modify some document in the library it doenst work anymore. I see #Name? as value, but I expecting "Published" or "Draft". See printscreen:

Answer 1

Ciao, you should create a calculated field based on version. And then group your documents by the new calculated field.

Here the full explanation:

• Create a calculated field based on Version; Formula syntax is like Excel formula (see link;
  https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx )
• You should split the version string by the "."(dot) character and then check if major an minor version define a document as Draft or Publish (apply your criteria here)
• Draft | Publish, are two of possible values of your calculated field
• Create views that filter or group documents by that value

Answer 2

Is your pages view showing an "Approval Status" column?

You can filter on that column, or you could create views that show pages according to the status.

Answer 3

Answering an old post in case it helps someone. Like Marc said we can use the "Approval Status" column (internal name - "_ModerationStatus") to solve the problem. We can either add this column to an existing view or create a new view using PnP PowerShell.

 Add-PnPView -List "Site Pages" -Title "Pages with Approval Status" -Fields "Name","Modified", "_ModerationStatus"