How can I configure a form to search over Registration and platedata simultaneously in BioSAR Browser?

How can I configure a form to search over Registration and plate data simultaneously in BioSAR Browser?

In order to search over both Registration and plate data simultaneously in BioSAR Browser, it is necessary to create a materialized view, combining Registration System, Inventory Manager, and BioAssay HTS fields.

To create this view, run the script INV_VW_REG_PLT_CPDS.sql in Oracle's SQLPlus worksheet (logging in as system.manager).  Note: If your administrator username and password is not system/manager, this must be changed in the script before executing.

After running the script, you must tell BioSAR Browser how to use it.  To accomplish this, do the following:

1. Log into Biosar Browser with an admin level password and click Schema Management
2. Click on the Inventory schema name (cheminvdb2).
3. Select the checkbox next to the new view (INV_MVW_REG_PLT_CPDS).
4. Click Save Changes.
5. Click on the view, INV_MVW_REG_PLT_CPDS, in the cheminvdb2 list of tables.  
6. Add the path to the Registration MST file (by default, C:\Chemoffice_data\Chem_Reg\regdb.mst) to the Structure File Path textbox.
7. Click Save Changes.

Finally, link the new view to the Registration System database:

1. Publish a table in BioAssay HTS.
2. Find the published table under the BioSAR Browser Schema Management (under bioassayhtsdb) and click on it.
3. Click the Parent Table link for the Reg_Number field in the table you published from BioAssay HTS.
4. Select BIOASSAYHTSDB.INV_MVW_REG_PLT_CPDS.REG_NUMBER as the parent column for the field.
5. Repeat this for each table from BioAssay HTS.

You are now able to use the INV_MVW_REG_PLT_CPDS view as your base table and any published BioAssay HTS tables are your child tables in a form.

Note: It may be necessary to refresh this materialized view from time to time as new data is added.  The following code will refresh the view:

alter materialized view inv_mvw_reg_plt_cpds
refresh force
start with sysdate
;

The following code will refresh the view automatically once a day.  To refresh in increments smaller then a day, use fractions (e.g. next sysdate + 1/24):