-
Using search with Draftbit
I managed to set up the search feature in Xano, but I am stuck with implementing it into Draftbit. Here is what I have on Xano: search_query is inputted to give the search, but I am unsure what to do after this. In Draftbit, I cannot add the ability to input search_query. At least I do not see the ability for me to. This…
-
How to filter / summarise a response based on a criteria nested two levels deep?
I have a response from an get all records query called certificates, enriched by some addons (farm, credits). I want to filter my response where credits.status == ex_post. How can I achieve this? Using the result I want to summ different data from that list like total_tonnesco2e with credit status ex_post I tried dot…
-
Struggling with Fuzzy Search
I don't know what I'm doing wrong (or more likely, what I'm missing) when it comes to fuzzy search. I've got a database full of monitors that users can search. The first issue I was having made me discover that partial match wasn't a default thing. To fix that, my function stack takes the user's query, breaks it into an…
-
Fuzzy search in array of object.
Hello Com, I having an user table here with "Emails" field which is an array of object containing key "value" for storing the "email". But i cannot create index search for that field. Question: Is there any other way to implement the Fuzzy search for that? Thank you all.
-
server capacity
Hello, I'm new to using xano so far I've only used the free plan, however I have a big project that will possibly be a union of flutterflow with xano, but I don't know the capabilities of the server, I'd like to better understand if there's a limit on requests, like Does the server limitation issue work, is it because of…
-
How to search the backend from a search input in the frontend?
I've followed this tutorial. https://www.youtube.com/watch?v=5_XkvyAX2C0 but how do I update the search query for the input from WeWeb?
-
searching contain "ends with"
Hi what should I do to get in search request any results that contain words that ends with "ing"? I found how to get in request start with: "pro:*"
-
How do you use a join in a Query All for an array of tablerefs?
I am trying to use a join that take an array of tablerefs and adds the other tables details so that they can be used in the query versus doing it as an addon. Example: Events table has an artists column that is a list/array of artist_ids that reference their corresponding row in the Artists table. I am creating a text…
-
How to return a single record with 2 or more parameters (inputs) having to be true? (GET)
I see in the endpoint query maker tool the note "If you choose a field_value that maps to multiple records, then the first one found will be used." This would not work for my use case. I have a table with multiple recrods containing the same field value. However I would like to know how to search by multiple field values…
-
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…