Brightspot CMS Developer Guide

Database SQL Query

The SQL Query tool provides access to the SQL tables created by Dari.

Dari Database SQL Query tool.png
Dari Database SQL Query tool

Use standard SQL syntax. For example:

SELECT HEX(id), HEX(typeId), value FROM RecordString4 WHERE value = "spurious news planted by trolls";

To specify a UUID value, remove the dashes from the record ID and add 0x in front of it. For example:

SELECT HEX(id), HEX(typeId), data FROM Record WHERE id = 0x0000015ecd9fdad1a7ffedff7b980003;

Previous Topic
Database Query
Next Topic
Database Solr Query
Was this topic helpful?
Thanks for your feedback.