Skip to content

app.sidebar_item_preferences

TableRow level security on

A person's own layout of an org's Atlas sidebar (Section 4.5.2): the position and visibility of module groups and items. Nodes without a row keep the role default. Private to the person; Reset to role default removes every row.

Primary key: id

Columns of app.sidebar_item_preferences
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org. A row never moves to another org.References app.organizations.id
person_iduuidNoPerson whose sidebar this is, from the session.References app.people.id
node_idtextNoSitemap node of the group or item, for example group.production or finance.
sort_orderintegerNoPosition among the node's siblings, ascending.
hiddenbooleanNoTrue when the person took the item out of their sidebar; it stays in search and the command menu.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.