Facility Control

 View Only
Back to discussions
Expand all | Collapse all

Dynamic Searchable Combo Box in DashBoard from Local API

  • 1.  Dynamic Searchable Combo Box in DashBoard from Local API

    Posted 6 hours ago

    Hi everyone,

    I am currently designing a custom DashBoard panel for an upcoming live Election Night broadcast. I am looking for the best architectural approach to implement a specific database-to-UI workflow.

    Our backend is a local Python API connected to a SQL Server database, and it is already fully functional and tested successfully via HTML/browser clients.

    Here is the exact workflow we want to build in DashBoard:

    1. Database Trigger: The operator clicks a "Load Database" button. This wakes up the data-flow and fetches the initial list of cities from our local API (GET /api/villes).

    2. Real-time Filtered List: This populates a dropdown/combo list. We need a search field at the top of this list that dynamically filters the entries in real-time, as the operator types each letter.

    3. Content Display Window: Clicking a city from the list must immediately fetch that specific city's data from our second endpoint (GET /api/resultats/<city_name>) and display its content (candidates, scores, votes) inside a dedicated window/container on the dashboard.

    4. Future Routing (FYI): In the next phase of the project, we will use this data to send commands to our graphics engines (Ross XPression, Viz Trio, and Viz Arc). DashBoard will automatically select the correct graphic template to trigger on each machine depending on the data payload.

    Right now, we are focusing purely on steps 1, 2, and 3: connecting the database and bringing the data into the UI cleanly.

    My questions for the community:

    • Given that we have thousands of cities, what is the recommended native pattern in DashBoard to achieve this letter-by-letter filtering combo box smoothly without freezing the UI? Should the button load all constraints at once, or is there a way to filter progressively?

    • What is the cleanest UI architecture to link the combo box selection to a dedicated absolute container (<abs>) acting as the information display window?

    If anyone has built a similar database lookup interface for elections or sports, I would love to hear your advice or see some sample OGLML/OgScript structures.

    Thanks in advance for your help!

    Best regards,

    Gaëtan



    ------------------------------
    Gaetan Renard
    Paris France
    ------------------------------