Data Management

Manage Stores

Use the Stores screen to delete data, make data immediately available, and find specific store information.

The viewing options for stores are found below:

1. Select either All Stores or Uncommitted from the drop-down list provided.
2. Begin entering the store name. As long as the letter or number combination appears anywhere in the store name or number, the store appears in the result list.
3. Click clear to clear the search fields.
4. Click refresh to refresh the store list as documents are being fed to get an accurate record count.
5. Choose to automatically refresh the stores as they feed into the server by changing the toggle from faded to dark, . Leave Auto Refresh turned off if you do not need constant updates. (Note for those using a version prior to 9: if Auto Refresh is toggled on, your account will not time out.)
6.  By default, stores are sorted alphabetically; however, you can sort by store number by using the Sort by Number toggle. This is not available for releases previous to Version 9.

View Store Details

View the store details by clicking on the desired store. Store details include the number of active records, the number of deleted records, the total number of records, and if the store contains uncommitted records.

A store is considered a default store unless it is added to the configuration file's list of excluded stores.

Commit Records

Recently completed feed jobs do not appear in the search results until they go through a transfer process called committing. Your search appliance configuration determines how frequently records are moved from the cache and committed to the server. However, if you need the records available for immediate searching, click Commit to commit records manually. You can commit cached records while records are still being fed into the store.

Delete Store Data

Deleting data removes only the data from the store and not the store from the server. Once data has been removed, it cannot be recovered. A refeed is necessary to add the data back in.

1. Locate the store you want to clear.
2. Click Delete Data found in the pane on the right.
3. Type the store name as it appears in the prompt, confirming you want to remove the data from the store.
4. Click Delete.

Manage Records

This feature accesses an item's XML listing and details such as the store, URI, and index time. It can be used to look at the source of files that are improperly displayed. However, it is most often used by support personnel to diagnose problems or delete faulty records.

Search Records

To search, use a single query:

1. Click the Records tab.
2. Select the store or stores you want to search from the drop-down list.
3. Enter a query on the line.
   The most common search is for a specific URI of a record. The query for the record should include the field name psuri, a colon, and quotes around the URI: ()psuri:"/MPI_records/GregFHIRRecords/F1_cleaned/10101117_005.xml". The code below displays the full URI when entered into the compound script box of Clinical Reports (replace search term with the term of your choice).
   
   

   a = get_hits('()search term', fields='URI') # use your own search term
   for i in a['URI']:
       print(i)

   
   A second common search is the index time. The query for the index time should be modeled after this example: ()psfirstindex:[20170616194208]. The date-time stamp is yyyymmddhhmmss. Use local time, not UTC, for a time-stamp search, 19:42 becomes 13:42 for MDT.
4. Click search.

View Record

Click View Record to view the XML record.

Delete Records

There may be times when a record is flawed. If that is the case, you can delete the record to ensure it is not included in the search results:

1. Locate the desired record.
2. Click Delete found in the pane on the right.
3. Enter delete in the input box provided, confirming you want to remove the record.
4. Click Delete.

You may delete only one record at a time.