Using a database view in a simple list in UI Builder

Ivar Donado · ‎10-03-2022

Hi guys,

I'm currently working on making a custom Agent workspace for a customer. In this workspace they want some "reports" in the landing pages that are similar to the ones they have in some dashboards, The issue I have come across is that some of those reports are built over a database view. Data visualizations in UI builder allow using database views, but simple lists don't.

I tried creating a data resource instance with Lookup records, but that doesn't allow using database views either it seems.

Is there any way?

Brad Tilton · ‎10-06-2022

Yeah I don't think database views are selectable as a table in that component, but there is a workaround/hack to get them to display using a client state parameter as shown in this screenshot (incident_metric is a db view table).

View solution in original post

Wivi · ‎07-17-2025

Hi Brad,

Your database integration method has been very helpful – thanks!

Quick question: After selecting a DB table, can I configure the other fields to accept static input instead of binding data or requiring scripts? I'm aiming to store fixed values there.

When I click static input, the DB table is replaced by a standard table.

Thak you!

Wivi · ‎07-17-2025