---
title: "Queries"
description: "Fast, precise queries for managing and analysing your locking systems."
url: https://help.portiervision.com/en/articles/102-queries
collection: "System Administration"
updated: 2026-08-28
language: en
alternates: [de, fr]
---

# Queries

Fast, precise queries for managing and analysing your locking systems.

## Persons

In the Navigator, select the QUERIES module and click the PERSONS button.

![The Queries: Personnel window opens.](https://staticfiles.gleap.io/g/TZ0mQ0rbsZNHmpmYpJvQVzUZzwTnmypg2QtjuqcG6JDTRgrwesTlhqTTgqFFHuw68OPDstX7xvj.png)

The **Queries: Personnel** window opens.

![The Queries: Personnel window opens.](https://staticfiles.gleap.io/g/Jl26wgDN59krvwjDvYcLQ3LY8DyYBNzrNhJ548Dmxq7Agt9aTJvK2gIiUxpaw4Jm6FChcwlHXFe.png)

The left side of the window shows the fields you can use for searching. You can search in any of these fields, enter any number of search criteria, combine them as needed, and retrieve exactly the information you need. You can use the search results for list printouts and for individual printouts.

The general query procedure is as follows:

You define the conditions the persons you are looking for must meet, then start the search with the **START SEARCH** button.

![portier VISION displays the persons matching your conditions in the RESULT tab.](https://staticfiles.gleap.io/g/XqYaIzGni4kQfYNcaA363UfTnbEL8s9yZhdttwdVPOzi6wRr3Vju6j20OE52cbb3k00hwkO2N86.png)

portier VISION displays the persons matching your conditions in the **RESULT** tab.

Example: you want to find all persons in a specific department who have two or more keys in their possession.

![Example: you want to find all persons in a specific department who have two or more keys in their possession.](https://staticfiles.gleap.io/g/0RL9kuK7sSt9CTrB7L81gLIWgKgbhRrIUCaQUUxU6GPDAYjyGjQEsxxoVBBqiWk3PBHUgxm4I4A.png)

1.  As the first condition, in the **NUMBER OF KEYS** row, select **GREATER THAN OR EQUAL TO** from the dropdown.
    
2.  Enter "2" in the first search field of the same row.
    
3.  As the second condition, in the **DEPARTMENT** row, select **EQUALS** from the dropdown.
    
4.  Enter "Sales" in the first search field of the same row.
    
5.  Click **START SEARCH**.
    

![In the RESULT tab, portier VISION displays the persons matching your conditions: all persons in the Sales department who have at least two keys.](https://staticfiles.gleap.io/g/06vock4SK6wlfkk9ttd3jASaepLyP9VEbXqaBGr7kSZKYXuQVk51yBMYyzPtvuo04JF38d9RwXb.png)

In the **RESULT** tab, portier VISION displays the persons matching your conditions: all persons in the Sales department who have at least two keys.

![To process the found person records, the relevant records must be selected. Individual records are selected by clicking in the CHANGE column. Additional options are available via the buttons:](https://staticfiles.gleap.io/g/GukOKT9GdsRMJCYFYIbXO7h0NItqM7sstZQ72PvEKBbIUO2u2JZyILv1ieLuTcE0PjAuUJbGWEP.png)

To process the found person records, the relevant records must be selected. Individual records are selected by clicking in the **CHANGE** column. Additional options are available via the buttons:

![Ticks every record found.](https://staticfiles.gleap.io/g/4gelisJ3g0m7BsCR4R3U5UmOo8WJsWVIZCf12WNvQ7ysiHIJrvIXjyF661cfw3dhJHTkhnghZSw.png)

Ticks every record found.

![Clears every tick.](https://staticfiles.gleap.io/g/GyhlmDfuBUXYitUJ4hYdKFmwTXoEzAJ0OFLvWDm9weaRBpLtUMRLtB7SWgKVOeGt1i2na0Hn4Jo.png)

Clears every tick.

![Inverts the ticks. Rows that were ticked lose their tick, rows that were not ticked gain one.](https://staticfiles.gleap.io/g/0Da9kv3hnP9ENfZWKM5MgYvkxJQj7d2agGRfTCU0SZWyI57xXjVvSeEoMRAXlpNPFDJ5OnL5uKR.png)

Inverts the ticks. Rows that were ticked lose their tick, rows that were not ticked gain one.

![Ticks the current row.](https://staticfiles.gleap.io/g/tx4FJUpnPf9byRArtU338PN2QVl0Hpcmuhzi7VUPMQIQPzZYiRfYrRihGCMfhfdC1DKwdVF4YWs.png)

Ticks the current row.

![Clears the tick on the current row.](https://staticfiles.gleap.io/g/ag0FQ5KQDgy0eDnRfxJJaPjFqQgiRwAmXmi6ai3TB1UpfgXTJfnEeX92N4mLCrsekj7DV4j0Amz.png)

Clears the tick on the current row.

## Copies

You want to find all key copies that have been recorded as lost or defective.

In the Navigator, select the QUERIES module and click the COPIES button.

![The Queries: Copies window opens.](https://staticfiles.gleap.io/g/Xf7YvH5gh9vIrRlxRIq8difd85U8p1vJLxtZMyM2TWvgUdaFntFWFGLMpALX92dQy2bcpSBiWA4.png)

The **Queries: Copies** window opens.

![In the upper part of the window, specify whether to search across all installations and buildings. The current installation is shown in the INSTALLATION field.](https://staticfiles.gleap.io/g/q7et0vkVRMjEIFk61FZ67UdbIodHZvZ9pDKxEUFzxbi0qS46iyy0zmOFQN2o9N6tBfZhx96uPxz.png)

In the upper part of the window, specify whether to search across all installations and buildings. The current installation is shown in the **INSTALLATION** field.

In the **COPY STATUS** row, select **EQUALS** as the first condition. In the first search field, select **LOST**. Set the connector to **OR**. Select **EQUALS** as the second condition.

In the second search field, select **DEFECTIVE**. Click **START SEARCH**. In the **RESULT** tab, portier VISION displays the key copies matching your conditions:

All key copies recorded as either lost or defective.

## Issue Query

You need a list of all keys currently issued and not yet returned.

In the Navigator, select the QUERIES module and click the ISSUE button.

![The Queries: Issue window opens.](https://staticfiles.gleap.io/g/n72jmsD9iWGFOE5lbfwS8chPjLWnHwKWFpIfvCkX3seOmmvIbMwYfJLZPw4mW7EDR3EixDgOMxD.png)

The **Queries: Issue** window opens.

![In the ISSUE DATE row, select LESS THAN OR EQUAL TO as the first condition. In the first search field, select the CURRENT DATE.](https://staticfiles.gleap.io/g/d3sT0xfWfsXV400BmWN1gdzeCV7rGNugQfJb0oI6xM6BpKsmcVYBMWJ8hc3FcLKUs7uRM5Vvpgc.png)

In the **ISSUE DATE** row, select **LESS THAN OR EQUAL TO** as the first condition. In the first search field, select the **CURRENT DATE**.

Click **START SEARCH**.

In the **RESULT** tab, portier VISION displays the key copies matching your conditions:

all key copies that were issued on or before today and have not yet been returned.

## History

You need a list of all keys that were issued and returned during your holiday.

In the Navigator, select the **QUERIES** module, click **More>>** and then **HISTORY**.

The **Queries: History** window opens.

In the upper part of the window, specify whether to search across all installations and buildings. The current installation is shown in the **INSTALLATION** field.

In the **ISSUE DATE** row, select **GREATER THAN OR EQUAL TO** as the first condition and enter the first day of your holiday. Set the connector to **AND**. Select **LESS THAN OR EQUAL TO** as the second condition.

Enter the last day of your holiday in the second search field.

Click **START SEARCH**.

In the **RESULT** tab, portier VISION displays the key copies matching your conditions:

all key copies that were issued and returned during your holiday.