topic Filtering on arrays in App Development

Filtering on arrays

jenniferboughton — Tue, 13 Apr 2021 15:09:23 GMT

Hi all,

I'm trying to create a filter for what was originally an array in my dataset:

issue_number	areas	severity	areas_string
3344	[ "App" ]	1	App
3345	[ "App", "Website" ]	1	App,Website
3346	[ "Website" ]	2	Website
3347	[ "Website" ]	1	Website

I'd like to create a filter (for either areas or areas_string) that when I choose "App" would return issues 3344 and 3345 and when I choose "Website" would return issues 3345, 3346, and 3347.

How can this be done?

Thanks!

Re: Filtering on arrays

marcus_sommer — Tue, 13 Apr 2021 16:20:55 GMT

You may try the following:

load issue_number, subfield(areas_string, ',') as areas_items from source;

to create an extra dimension-table with issue_number as key and areas_items is then your selection-field.

- Marcus

Re: Filtering on arrays

jenniferboughton — Tue, 13 Apr 2021 20:43:36 GMT

This worked! Thank you!