In this video we look at one technique for more advanced filtering when using Supabase. Unfortunately out of the box filtering for #Supabase in #FlutterFlow is limited and this video we use a direct API approach to return the data we need.
Specially we are covering how to retrieve data from our database based on a text query within FlutterFlow. We gradually build this up to use more than one filter to overload our search box to also search within another database column. We additionally handle non-case sensitive queries to increase the chance of returning results. Finally I also cover restricting the number of rows returned. The video will really help you use this technique and customise it further for use in your own specific projects.
This example then sets ourselves up nicely for an upcoming video which covers the implementation of Infinite Scrolling using Supabase. Look out for this video soon!
Please note: As always please make sure that, if you have significant data contained in your tables, please make sure you have applied the correct level of indexing otherwise you may run in to performance issues. Other search techniques are available which may be a better fit for your usecase.
_____
👉 Table Setup
1. Run the following create tables script in the Supabase SQL Editor.
www.thedigitalpro.co.uk/acade...
Sample Data for Import
2. Import the following data in to the respective tables. Please start with regions and then contacts.
www.thedigitalpro.co.uk/acade...
www.thedigitalpro.co.uk/acade...
👉 Starter Project
app.flutterflow.io/project/n-...
👉 Final Project
app.flutterflow.io/project/n-...
🔥 The following reference guide will support you in understanding how to apply various filters which you can carefully apply to your API requests.
postgrest.org/en/v12/referenc...
_____
🔥 Looking for more content and a helpful community? Why not consider joining The Digital Pro's #Nocode Academy at www.thedigitalpro.co.uk
_____
Chapters
00:00 Introduction
00:32 Application Example
02:01 Superbase Project Setup
04:17 FlutterFlow Starter Project Walkthrough
06:12 FlutterFlow Supabase Setup
06:51 Supabase API Url
07:38 Setup FlutterFlow API Call
08:48 Configure the API Key in App State
09:16 Setup API Query
10:57 Using Custom Data Types
11:58 Data Type Setup + API Config
13:44 Setup UI Mapping to Custom Data Type
15:58 Executing the Query
17:27 PostgREST Introduction
19:39 Simple Search
20:40 Simple Search: TEST
21:07 Wildcard Search
21:53 Wildcard Search: TEST
22:00 Handling Case
22:11 Handling Case: TEST
22:36 Multi Column Search
23:07 Multi Column Search: TEST
23:44 Limiting Records
24:23 Limiting Records: TEST
24:40 Infinite Scroll Warmup + Summary
26:10 Infinite Scroll Demo
_____
🚀 The Digital Pro's NoCode Academy: www.thedigitalpro.co.uk
(Support the channel and go ad-free! 😉)
🔥 If you love my content why not consider buying me a coffee, it's really appreciated: www.thedigitalpro.co.uk/coffee
👍 Support the channel and grab yourself a free FlutterFlow account by clicking here: www.thedigitalpro.co.uk/flutt...
🎉 Your love is much appreciated ... A like to this video is like a High Five!!! Thank you all.
Негізгі бет Advanced Searching Technique in
Пікірлер: 29