Suggest Totara Learn features

TL-40071 Multiple filters with report builder

 
Kerry Friend
TL-40071 Multiple filters with report builder
by Kerry Friend - Thursday, 16 June 2022, 2:41 AM
Group 2022 Learner of the Year (Bronze)Group PartnersGroup TXP Site Administrator

Hi,

Just a suggestion to enhance the filter function on report builder to allow for and/or and multiple filters.

For example, when viewing a course completion report to be able to filter by:

Course name contains "Alpha" OR course name contains "Beta"

Currently it appears that you can only have one active filter on each field.

Regards,


Kerry

(Edited by George Angus - original submission Thursday, 16 June 2022, 9:41 PM)

Craig Eves
Re: Multiple filters with report builder
by Craig Eves (Totara Support) - Thursday, 16 June 2022, 7:30 PM
Group Totara

Hi Kerry

That is correct the filters only allow one active filter per field.

A workaround would be to add the Course (multi item) filter and then do a Search when choosing courses for Alpha and select all these courses and then do the same for Beta and select these courses 

I can't see a feature request around this - are you able to create a feature request outlining the benefits of this and scale of the problem it is causing?

Regards





Kerry Friend
Re: Multiple filters with report builder
by Kerry Friend - Friday, 17 June 2022, 1:38 AM
Group 2022 Learner of the Year (Bronze)Group PartnersGroup TXP Site Administrator

Thanks Craig,


I've created a feature request.


I was using course name as an example but thanks for the workaround.  Useful to know.


Kerry

harry woodward-clarke
Re: Multiple filters with report builder
by harry woodward-clarke - Tuesday, 17 January 2023, 7:55 PM
Group TXP Site Administrator

while a Course "multi-item" would be useful, I think a broader requirement is the ability to use Boolean items (AND / OR & maybe others) in all the filter text entry fields.

Steph Wild
Re: Multiple filters with report builder
by Steph Wild - Friday, 17 June 2022, 12:42 AM
Group Learn Site Administrator

Hi,

I think this would definitely be beneficial, we often find ourselves building audiences to use as a filter in a report as we can only use one active filter for each field.

We find that this issue isn't only linked to the 'Course Name' field, we have a lot of custom fields where we would find this a benefit.

A big +1 from us.

Steph


Matt Barets
Re: Multiple filters with report builder
by Matt Barets - Tuesday, 21 June 2022, 12:43 AM
 

Hi

+1 from us too.

Same here, we sometimes have to build an audience just for the sake of filtering data on reports.

Matt

Lloyd Wilson
Re: Multiple filters with report builder
by Lloyd Wilson - Sunday, 19 June 2022, 11:21 PM
 
+1 from us - would be very helpful.