How To...

How to do various things

How do I query the list of users in my Biotics instance
You need to use quotes around the fieldname: select "User_ID", "Username", "Full Name", "E-mail" from SECURITY_USER...
Fri, 2 Aug, 2019 at 7:59 AM
How to create an Oracle view
An Oracle view is a virtual table that does not physically exist. It is stored in Oracle data dictionary and do not store any data. A view is created by a q...
Tue, 25 May, 2021 at 11:58 AM
Generate the link (URL) for elements in Explorer
Use the following string within a query to generate the link (URL) for an element in Explorer, using the necessary universal keys. An example of it in a qu...
Wed, 6 Oct, 2021 at 7:51 AM
Identify dependencies on a table
Following is a query to determine which (child) tables are dependent on another table, in this case ELEMENT_GLOBAL_RANK. select distinct c.TABLE_NAME fr...
Tue, 16 Nov, 2021 at 2:11 PM
Adding Custom non-IUCN Threat Category Domain values
The threat category domain (d_iucn_threat_category) table is locally extensible. We have established conventions that allow for the addition of custom level...
Wed, 29 Jun, 2022 at 3:58 PM