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.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 Schema Viewer
Was this topic helpful?
Thanks for your feedback.
Our robust, flexible Design System provides hundreds of pre-built components you can use to build the presentation layer of your dreams.

Asset types
Module types
Page types
Brightspot is packaged with content types that get you up and running in a matter of days, including assets, modules and landing pages.

Content types
Landing pages
Everything you need to know when creating, managing, and administering content within Brightspot CMS.

Admin configurations
A guide for installing, supporting, extending, modifying and administering code on the Brightspot platform.

Field types
Content modeling
Rich-text elements
A guide to configuring Brightspot's library of integrations, including pre-built options and developer-configured extensions.

Google Analytics
Apple News