Feedback
Every databank in the BioRS system contains an element called AllText. The AllText element is an indexed element that BioRS automatically creates for all databanks.
By using the AllText element, you can search on all of the text in an entry, not just on specific indexed elements. For example, searching on the term muscus can return entries where the word muscus appears in the title, abstract, description, or organism.
To use the AllText element in a federated query, you must map the AllText element to a nickname column. You map the AllText element to a nickname column when you specify columns in the CREATE NICKNAME statement. A nickname column that is mapped to the AllText element returns a NULL value in SELECT statements. When you specify a column as an AllText element, the column must not be the first column declared in a CREATE NICKNAME statement.
After the AllText element is properly mapped to a nickname column, you can use that nickname column in a BIORS.CONTAINS custom function.