List of component data from Retool PostgreSQL db

💬 App Building
1

I have a module called 'Menu' using a 'navigation' component. I would like to fetch a list of the menu items from the module to use in another app but I can't seem to see them. Does anyone know if/where they are stored in the Retool PostgreSQL database (on-prem) for me to pull down a list.

2

I couldn't find the data but i found a work around. This is to design a change request app allowing users to select an app and submit a change request/bug fix to our department.

What I ended up doing was using the below SQL and in the description of each app I want returned i added in a 'ã…¤' character (hangul filler U+3164). That returns me a list of apps I can use for a dropdown.

image

SELECT *
FROM pages
WHERE description LIKE '%ã…¤%';
3

Hey @rcanpolat! Glad you were able to find a workaround :slight_smile: for your original question, could you clarify what you mean by menu items?

4

Menu items like on the right side of this image. I can't read them when the menu is a module.

image
image1600×715 106 KB

5

Ah, got it! Filed—thank you :slight_smile: