Asked by Martin on March 27, 2025
How do I retrieve employees with their associated managers for a given company (relational queries across tables)? Can I define indexes or run SQL for efficiency?
Answered by Twidget
One approach: keep company_id and manager_id fields on the Employee table. Use Get Multiple Data filtered by company_id to fetch employees, then for each employee fetch the manager by manager_id (this results in multiple calls).
For better efficiency: perform a single Get Multiple Data to fetch all employees, then use Conversion → Group Items by Field to build a map (employee_id → employee). Locally join the employees with their manager entries using that map to avoid repeated table calls.
At present Twidget does not expose raw SQL or custom index definitions; use data modeling and grouping techniques to optimize queries.
Deleting layers in the page editor
Select the element and press the Delete key, or use the Delete option available in the toolbar options dropdown.
Accessing global variables inside functions
Global variables are accessible only in server‑side contexts (endpoints, server functions, events). They are not available inside client‑side code or client functions.
Sign up error: "No token provided"
Check that you have saved the reCAPTCHA site key and secret key in the API and page settings respectively. Missing or misconfigured reCAPTCHA keys can cause sign‑up token errors.
Securing endpoints with long‑lived tokens / API keys
Follow the authentication guides: https://www.youtube.com/watch?v=kfbS6gJqRa4 and https://www.youtube.com/watch?v=vRtlTfvI22I
By default tokens last 24 hours (86,400 seconds). You can increase the token expiration by editing the command that generates the token in the endpoint — the expirat...
Querying records by a date field
Convert the incoming date text input to a Date (or the platform’s date object) and then query the database using that date field. A working datetime format is like 2025-08-08T00:00:00.
To append a time suffix to a date string, use the Concat command (for example, concat(dateText, 'T00:00:00...
