Hi everyone =)I have an aggregate (screenshot: ServiceStudio_w77Mbwh9kn) in the Status attribute where we store Status Identification. I must filter by this attribute when the user clicks the specific checkbox (screenshot: ServiceStudio_rqw8dlBqBP). I have tried adding new attributes in aggregation and named it 'isSelected', but I didn't figure out how to use it properly. Now I'm trying to use Index() function in Filter (screenshot: ServiceStudio_d5GhgE0Uhd, FilterStatus - Text data type), but I think it isn't very easy because I need to remove the selected checkbox value from 'FilterStatus' using Substr() and Index() functions. Can someone please suggest an easy way of filtering status by checkbox value?
Hi @Zhomart Aripbay,
I think the solution is not straight forward and there will be slight change in the logic.
I am attaching the oml file, please check.
ThanksPankaj
Hi Zhomart Aripbay,
I have seen the SS which you have given. what i suggest you use List Filter and pass the required condition and append the value in you list type var.
Hope this will work for
Kind regards
Sourabh sharma
Hi,
Use the string join, to include the identifier that you need to fetch. So for here i included denied and success filter.
Use string join in index.
Let me know if any queries.
Apply the filter in the aggregate and refresh the aggregate on change of your check box.
hope it helps.
Thanks.
Are you looking into a facet filter? Meaning that a user can select one or more status and the list gets filtered? Then you can download my pattern sample https://www.outsystems.com/forge/component-overview/15145/pattern-sql-patterns to see how it is done.
Thank you guys a lot! Didn't expect this amount of support, I appreciate it.
I chose @Pankaj Jain's response because, although I had also first considered dealing with the problem in this way, he demonstrated how it might be done. However, I'm sure all of your advice was excellent.