How to add new categories to bioport

[mosin_kazi]

In behalf of Jennifer Cai

1. If we wants to add the column such as specimen class, what code do I
   need to modify following two files:
   JBOSS_HOME/server/default/catissuecore-properties/oracle_analysis_updateSQL.sql
   JBOSS_HOME/server/default/catissuecore-properties/specimen-dashboard.xml.

2. Can Bioport display the data fields from dynamic extension form?

[mosin_kazi]

Adding a new category to bioport

You need to update the SQL queries to handle the ETL process in the file /sql/oracle/oracle_analysis_updateSQL.sql.

For the new category to be visible in the UI category drop down, add the entry in file: /WEB-INF/CreateDatabase.xml

Since you were interested to add field from participant, you can refer to how “Gender” field is handled in the above files.
Once you add new category you need to redeploy the catissuecore-da.

Can Bioport display the data fields from dynamic extension form?

Yes, BioPort can display DE fields too. You will need to again update the SQL file to handle the extract DE data from OpenSpecimen and load into BioPort and update the field as new category.