SQL and Query Builder

Why does the Query Builder table list look funny in Biotics6?
See this online help topic: Query Builder in Biotics 6.
Thu, 29 Oct, 2026 at 12:37 PM
Translation of some Oracle/B5 SQL into PostgreSQL/B6
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
DELIMLIST replacement in B6 (STRING_AGG)
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
Useful functions
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
ELEMENT_OCCURRENCE_SOURCE view not in Biotics 6
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
update_next_eo_num procedure
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