Document toolboxDocument toolbox

フィルター

Filter in navigation panel

If your database uses Room groups, status or/and classification, you can apply those as filters when you browse Rooms, Items, Systems, occurrences or products. You will see an Add filter (1) option in the navigation panel. If you press Add filter you will see all availbale statuses or classifications you can use as filters.

Step one is to select the status type or classification type to filter by. Then you can press the status or classification again to decide which statuses or classifications you want to include in the filter

 

In the example above we have first selected classification; Room classification. Then set the filter to include all rooms classified as "Green rooms". The result in the navigation panel is;

After applying filter to in the room or item module all lists (functions, item groups, status, classifications) will be filtered. To remove the filter select the X icon to the right of the applied filter. 

Filter in columns

You can apply filters to most lists in dRofus. When hover the cursor over a column header you will see a filter symbol  indicating the column can be filtered. Click the filter icon to apply a filter to the column.

What filter methods you can use will depend on what datatype the column consist of. If the column consists of a text filed you will be able to use methods; Contains, Does not contain, Is empty, Is not empty. If you filter in a column with numeric fields you will have the options; Equals, Less than and Greater than. If you filter in e.g. responsibility, budget or any other built in fields that include a dropdown list, you will get a fixed list of options to filter by.

The filter by column works the same way as a search in the sense that it will be active also if you shift focus. If you first apply a filter, and then navigate the e.g. function structure in the room module, you will not see the rooms that has been excluded by your filter. To remove column filter you can either click on the filter icon again and select Reset, or click on the  icon in the bottom right corner of the panel;

When a filter is used, it also shows in the bottom left so the user knows which columns are being used.