-
Join two table is slow so how to we should do it?
Hi everyone! We have this table that is related to another like this: table 1 (20k records) → column fk_jobs[] (any array of id of table 2) table 2 (10k records) → column id (an id) When we do a query all paginated the speed is very good (~0.07s), but if we want to join the table to use a search index in a fuzzy search…
-
Query all records from - filter
Hello, I have a table with a JSON field that on some records is empty. When using the above query method I want to filter out all the records with that JSON field empty. However differently then the filter list that appears usually in this case I can not find the is_empty filter. Comparing the JSON to empty object did not…
-
Question about dynamically populating pages.
So I recently realized that rendering data on a page from a backend like xano would result in either a nondescriptive URL path, or an uncrawlable query parameter by search engines. For example, (with a token) example.com/user-profiles example.com/user-profiles?id=239487234987 I've created a marketplace using webflow and…
-
Geting X number of latest records from a table
As the title mention, how can I do it from an API?
-
Filter for (not) empty text field in query
Hi, I want to have an optional query clause to filter for entries which have a value (strlen greater 0) on a text field. Unfortunately I am not able to use the strlen filter on the condition/field. I know I can just leave the value side of the condition empty, but I want to make the where clause conditional by an input…
-
Edit all users of a table with a single DB query [EDIT ALL RECORD]
Hi, I'm setting up a cron-job where every week I would edit the field counter of all users back to zero. I wouldn't like to do this with a FOR cycle because Is probably not ideal and not fair for some users to get the counter to 0 prior to others, I'd like to do this with a simple DB query, is that something possible with…
-
Query slow when enabling distinct response
Hi, I have a query in one of my endpoints which queries table A with a Query all Records statement. In this query I have two left joins to tables B and C. An entry from table A can have multiple entries in B and C. To get only results from table A I need to enable the "Distinct" response in the output tab. If I do so, the…