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.
The elements that get you up and running in a matter of days, from pre-built content types, to modules, to landing pages.

Content types
Landing pages
Everything you need to manage and administer content within Brightspot CMS, including plug-and-play integrations.

Admin configurations
A guide for installing, supporting and administering code on the Brightspot platform, including integrations requiring developer support to use.

Field types
Content modeling
Rich-text elements