Dataverse Filter a SQL Table using Multi-Choice Delimiter separated values
In SQL, a common approach you can save multiple values in a single column by Concatenation under which you can concatenate multiple values
In SQL, a common approach you can save multiple values in a single column by Concatenation under which you can concatenate multiple values together using a delimiter and store them as a string in a single column. For example, you could store a list of names separated by commas in a column.
USE CASE:
If you need to filter a SQL table based on a multi-choice/value column where the values or choices are separated by a comma or semicolon. You want the end-users to be able to find all records that have one or more selected values of those comma-separated values. what would you do?
In this blog post, I will guide you through the process of creating a filter functionality to achieve this.
Filter a SQL Table using Multi-Choice Delimiter separated values is a process of filtering data in a SQL table by selecting the columns to be filtered based on the delimiter-separated values. This process is useful when the data needs to be filtered by multiple criteria. For example, say you have a table with multiple columns like name, age, gender, etc. and you want to filter the data based on age and gender. You can do this by providing a delimiter-separated list of values (e.g. Age > 18, Gender = M) and the query will return the rows that match the criteria. This way you can quickly filter the data without having to write multiple queries.
More links on about Power Platform/Power Apps
Jan 5, 2009 · 3 answersI solved this one by writing a table-valued function (we're using 2005) which takes a delimited string and returns a table.
To filter rows by using a list: Type: SELECT columns FROM table WHERE test_column [NOT] IN (value1, value2,...); columns is one or more comma-separated column ...
Solved: Hi Guys, In my Datatable there is a comma separated multi select field ... But I am getting comma separated values in my dropdown like below image.
Jun 20, 2021 — Jun 20, 2021How to create a multi-select filter from column with string values separated by commas. I am looking to create a single multi select filter ...