Skip to main content

Cornell University

Facilities Inventory: Searching for Rooms by Org Status (Open, Reviewed, Approved)

Back to Facilities Inventory Documentation

Back to Common Facilities Inventory Tasks

Last updated: March 20, 2024

To search for rooms by the "Org Status", navigate to "Views" and select "1.40 Room Updates" as shown in Figure 1 below.

View 1.40 Room Updates

Figure 1.  View "1.40 Room Updates" is found under the "Views" menu item.

When you first open a data view such as 1.40 Room Updates, the options to search by a column are not present.  Click the small filter icon from the top row above the column headers as shown in Figure 2 below to turn on search capabilities.

The search filter button is on the menu bar above the room data

Figure 2.  The filter icon is a toggle switch.  Click it to turn on the ability to search by column values.

There are three room "org statuses": 

  1. Open
  2. Reviewed (was hold), set by department users
  3. Approved (was freeze), set by org admins.

At the beginning of the annual facilities inventory update cycle, all rooms have an org status of "Open".  When the the annual updates are complete, all rooms have an org status of "Approved".

To search for all rooms which have the intermediate "Reviewed" status, in the column called "Org Status", having already turned on the the filter switch above, type the word "Reviewed" or a shorter version such as "Rev", click the filter icon to the right of the words "Org Status" to choose a filter choice.  While "Exact" would work as a filter choice in this case, it may not work for other columns such "Room Orgs", so we recommend using "Contains".

Search filter options include "Contains".

Figure 3. Type the word "Reviewed" or an abbreviation such as "Rev" and select the "Contains" search type from the filter icon drop-down to the right of the column heading "Org Status".

During a delay of several seconds, the text becomes gray and a blue circular icon appears on the screen while the system filters the room data to display only those rooms with the specified org status as shown in Figure 4 below.

Figure 4.  While the search is underway, the room details appear gray and a blue circular icon appears on the screen until the search is complete.

Once the search is complete, the room list will be filtered to display only those matching the specified "org status".  

The number of rooms is displayed in the bottom left corner of the screen as the item number.  In the example in Figure 5 below, there are 400 rooms with a "Reviewed" status.

The number of search results appears in the bottom left corner as a number of items.

Figure 5.  The number of items in a view is listed in the bottom left corner. 

Note that the "Org Status" of a shared room in the upper portion of the screen may not show the correct status for your portion of a shared room.  If any department associated with a shared room still has an "Org Status" of "Open", the whole room is listed as "Open" even though you may have finished your updates and moved your portion of the room to "Reviewed" or "Approved".