SQL and Query Builder
See this online help topic: Query Builder in Biotics 6.
Thu, 29 Oct, 2026 at 12:37 PM
This article will continue to be updated as we find additional information that we think is useful. If you have information or sample queries to share, or i...
Fri, 13 Nov, 2026 at 6:58 PM
The custom DELIMLIST function was converted to PostgreSQL and can still be used, but it doesn't work for all SQL. (One fixable issue is that there must ...
Thu, 29 Oct, 2026 at 3:26 PM
There are some custom functions in Central Biotics that are likely useful to many member programs. When we have capacity, we hope to add them as standard f...
Fri, 13 Nov, 2026 at 4:10 PM
The ELEMENT_OCCURRENCE_SOURCE view was deprecated as of Biotics 6. The script is attached, should you want to recreate it within your extensible schema via ...
Mon, 2 Nov, 2026 at 1:51 PM
Problem A unique constraint error on BIOTICS_USER.EO_AK3 indicates that the EO_NUM being utilized already exists for that element. However, this is hard to...
Tue, 3 Nov, 2026 at 12:06 PM