Autogenerated
Autogenerated
 
Line 1: Line 1:
{{#vardefine:ExpiringSoon|
<div class="ext-galaxy-dashboard">
    {{#neowiki_query:
    {
        "conditions": [
            {
                "property": "Document Control.Valid until",
                "operator": ">",
                "value": "{{#time:Y-m-d}}"
            },
            {
                "property": "Document Control.Valid until",
                "operator": "<=",
                "value": "{{#time:Y-m-d|+14 days}}"
            }
        ]
    }
    |format="count"
    }}
}}
{{#vardefine:NoOwner|
    {{#neowiki_query:
    {
        "conditions": [
            {
                "property": "Document Control.Owner",
                "operator": "IS NULL",
                "value": ""
            }
        ]
    }
    |format="count"
    }}
}}
{{#vardefine:NoExpiration|
    {{#neowiki_query:
    {
        "conditions": [
            {
                "property": "Document Control.Valid until",
                "operator": "IS NULL",
                "value": ""
            }
        ]
    }
    |format="count"
    }}
}}
{{#vardefine:Expired|
    {{#neowiki_query:
    {
        "conditions": [
            {
                "property": "Document Control.Valid until",
                "operator": "<=",
                "value": "{{#time:Y-m-d}}"
            }
        ]
    }
    |format="count"
    }}
}}
{{#vardefine:FirstDrafts|
    {{#neowiki_query:
    {
        "conditions": [
            {
                "property": "qm/state_raw",
                "operator": "=",
                "value": "first-unstable"
            }
        ],
        "hasSubjects": [ "Document Control" ]
    }
    |format="count"
    }}
}}
 
{| style="width:100%"
{| style="width:100%"
|-
|-
| <kpitile value="{{#var:ExpiringSoon}}" max="1" label="Expiring soon" color-thresholds="0:green|10:red" />
| {{#tag:kpitile||value={{#neowiki_ask:
| <kpitile value="{{#var:NoOwner}}" max="1" label="Without owner" color-thresholds="0:green|1:red" />
  [[Schema:Document control]]
| <kpitile value="{{#var:NoExpiration}}" max="1" label="Without validity date" color-thresholds="0:green|1:red" />
  [[Document control.Valid until::>{{#time:Y-m-d}}]]
| <kpitile value="{{#var:FirstDrafts}}" max="1" label="Without approval" color-thresholds="0:green|10:red" />
  [[Document control.Valid until::<={{#time:Y-m-d|+14 days}}]]
| <kpitile value="{{#var:Expired}}" max="1" label="Expired pages" color-thresholds="0:green|1:red"/>
| format=count
}}|max=1|label={{int:bs-qmdashboard-tile-expiring-soon}}|color-thresholds=0:green{{!}}1:yellow{{!}}10:red|link={{canonicalurl:Special:QMDashboard|view=expiring-soon}}}}
| {{#tag:kpitile||value={{#neowiki_ask:
  [[Schema:Document control]]
  [[Document control.Owner::!+]]
| format=count
}}|max=1|label={{int:bs-qmdashboard-tile-without-owner}}|color-thresholds=0:green{{!}}1:red|link={{canonicalurl:Special:QMDashboard|view=without-owner}}}}
| {{#tag:kpitile||value={{#neowiki_ask:
  [[Schema:Document control]]
  [[Document control.Valid until::!+]]
| format=count
}}|max=1|label={{int:bs-qmdashboard-tile-without-validity-date}}|color-thresholds=0:green{{!}}1:red|link={{canonicalurl:Special:QMDashboard|view=without-validity-date}}}}
| {{#tag:kpitile||value={{#neowiki_ask:
  [[Schema:Document control]]
  [[qm_state_raw::first-unstable]]
| format=count
}}|max=1|label={{int:bs-qmdashboard-tile-without-approval}}|color-thresholds=0:green{{!}}1:red|link={{canonicalurl:Special:QMDashboard|view=without-approval}}}}
| {{#tag:kpitile||value={{#neowiki_ask:
  [[Schema:Document control]]
  [[Document control.Valid until::<={{#time:Y-m-d}}]]
| format=count
}}|max=1|label={{int:bs-qmdashboard-tile-expired}}|color-thresholds=0:green{{!}}1:red|link={{canonicalurl:Special:QMDashboard|view=expired}}}}
|}
|}


<neowiki_report format="grid">
{{#neowiki_ask:
    {
  [[Schema:Document control]]
        "properties": {
| ?Document control.Document ID = Document ID
            "Document Control.Document ID": "Document ID",
| ?Document control.Document type = Document type
            "Document Control.Owner": "Document owner",
| ?Document control.Owner = Document owner
            "qm/state": "Approval state",
| ?qm_state = Approval state
            "qm/has_draft": "Has draft",
| ?qm_has_draft = Has draft
            "read_confirmation/pending_count": "Pending read confirmations",
| ?read_confirmation/pending_count = Pending read confirmations
            "workflows/count": "Number of running workflows",
| ?workflows/count = Number of running workflows
            "Document Control.Valid until": "Valid until"
| ?Document control.Valid until = Valid until
        },
| format = grid
        "conditions": [],
| mainlabel = Document name
        "sort": [ {
| sort = Document control.Valid until
            "property": "name",
| order = asc
            "direction": "ASC"
}}
        } ],
</div>
        "hasSubjects": [ "Document Control" ],
        "mainLabel": "Document name"
    }
</neowiki_report>

Latest revision as of 04:05, 14 August 2026