We've completed much of the groundwork required for our cutting-edge multi-tenant app. In this part of the series, we'll put all of the pieces together, and by the end of it, you'll have built a fully functional & secure app with RLS
Read more
Now this is the secret sauce, the RLS security feature. This video will cover how to enable RLS, create an access policy, and an RLS app user. See you in the video!
Read more
Welcome to the second video in the RLS series. In this video, we'll build a sign-in/sign-up flow using the database, users' email, and hashed password. See you there!
Read more
Ever heard of RLS? Not sure? It's an awesome security feature baked into most SQL-supported databases. We're creating a video series showing how to build secure multi-tenant RLS-based apps on Appsmith. Check it out!
Read moreIn my query, i want to filter the where clause based on a checkbox. To transform the array to a readable list in the query i use the selectedValues.join(', ') method. For one value this works, but as soon as i check multiple values this fails. My datasource is MS sql server
SELECT
locatie,
“sdf potmaat”,
teelt,
uitgangsmateriaal,
leverancier
FROM stamgegevens.producten
WHERE locatie IN ({{CheckboxGroup1.selectedValues.toString()}});