Set limits for exporting variants

In Oracle Healthcare Translational Research, in the Single Patient Viewer screen, users can only export variants separately, instead of doing it for all phenotypes at once.

If the number of variants that they want to export is less or equal than the pre-configured limit of 50000, then all variants for the selected node are exported. If the number of variants that they want to export exceeds that limit, variants are then exported only for the selected chromosome within the node.

In some cases, that limit can be modified from the database. To change the limit:

1. Log in the Oracle Healthcare Foundation / Oracle Healthcare Translational Research database using the Enterprise (ENT) schema user or as an admin user.
2. Find the current value of the Variant Export limit using this query:

   Select value from W_EHA_CONFIG_PARAMETER where name ='variant_export'; 

3. Update the variant export limit with a different value, using this query:

   Update W_EHA_CONFIG_PARAMETER set value=<new_variant_export_limit> where name='variant_export'; 

   Instead of <new_variant_export_limit> add the new limit for exporting variants.

4. Check with the user who wants to export variants to see if everything works.