New Filter Options in Report Designer

Put your suggestions here.
enishemed
Posts: 651
Joined: 30 Oct 2017, 11:24
Name: Enis Hemedoglu
Location: Istanbul, Turkey
Company Name: SCORE DANISMANLIK
Contact:

New Filter Options in Report Designer

Post by enishemed »

Dear Sergey,

Currently Report Designer has two default filter options, filter by date and filter by users. I suggest a new filter option. "Filters By Entity Fields"

Sometimes, we need to qucikly filter the mysql table according to some columns. For example according to customer, status etc. So is it possible to add new filter options for dropdown field type, entity field type and global lists?

It will work like this. When creating the report, in Filters Panels, the admin will select an entity and a dropdown field type belong to that entity. And in configuration, the mysql table will have a new variable something like "[filter_by_entity_field]".

Thanks.
enishemed
Posts: 651
Joined: 30 Oct 2017, 11:24
Name: Enis Hemedoglu
Location: Istanbul, Turkey
Company Name: SCORE DANISMANLIK
Contact:

Re: New Filter Options in Report Designer

Post by enishemed »

What do you think about this Sergey?

I am ready to donate, if you develop this feature for 3.3
enishemed
Posts: 651
Joined: 30 Oct 2017, 11:24
Name: Enis Hemedoglu
Location: Istanbul, Turkey
Company Name: SCORE DANISMANLIK
Contact:

Re: New Filter Options in Report Designer

Post by enishemed »

Have you considered this Sergey? I think this option will level up the Report Designer.
enishemed wrote: 15 Dec 2022, 19:18 What do you think about this Sergey?

I am ready to donate, if you develop this feature for 3.3
enishemed
Posts: 651
Joined: 30 Oct 2017, 11:24
Name: Enis Hemedoglu
Location: Istanbul, Turkey
Company Name: SCORE DANISMANLIK
Contact:

Re: New Filter Options in Report Designer

Post by enishemed »

Dear Sergey,

I know you are so busy. I really need this improvement and I am ready to donate. Have you thought about this improvement. In your opinion, is it possible?
User avatar
support
Site Admin
Posts: 6221
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: New Filter Options in Report Designer

Post by support »

I'm going to add 3 extra filters by for entities and 3 extra filters for global list.
You can donate for this https://www.rukovoditel.net/donate.php
User avatar
support
Site Admin
Posts: 6221
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: New Filter Options in Report Designer

Post by support »

enishemed
Posts: 651
Joined: 30 Oct 2017, 11:24
Name: Enis Hemedoglu
Location: Istanbul, Turkey
Company Name: SCORE DANISMANLIK
Contact:

Re: New Filter Options in Report Designer

Post by enishemed »

Donation made. Coould you please check and send me the invoice asap.

Thanks.
support wrote: 17 May 2023, 08:38 I'm going to add 3 extra filters by for entities and 3 extra filters for global list.
You can donate for this https://www.rukovoditel.net/donate.php
amamyoj
Posts: 44
Joined: 17 Nov 2023, 19:37
Name: Joy Pacardo
Location: Philippines

Re: New Filter Options in Report Designer

Post by amamyoj »

Hi Sergey,

Is it possible to add another report filter but in the same entity of the Filter by Entity 1? Like in the picture below, I toggled on the Filter by Entity 1 using the "Leading Indicator" Entity and "Location" column/field as filter. I would want to add another filter, so I toggled on the Filter by Entity 2 but Im still using the same Entity "Leading Indicator" but using a different column/field named "Department". Is this possible? If yes, please guide me on how to do it.
1.png
Thank you in advance!
User avatar
support
Site Admin
Posts: 6221
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: New Filter Options in Report Designer

Post by support »

"Filter by entity 2" means second filter so you can select the same entity I think. Try this way.
amamyoj
Posts: 44
Joined: 17 Nov 2023, 19:37
Name: Joy Pacardo
Location: Philippines

Re: New Filter Options in Report Designer

Post by amamyoj »

I tried toggling on the Filter by Entity 2 and selected the Leading INdicator Entity, and in the dropdown list it is showing the "HEading COlumn" for the Leading Indicator Entity which is the Location. Is it possible to choose a column in the selected entity other than the heading column? Attached are the screenshots for your reference.
Attachments
5.png
4.png
4.png (10.16 KiB) Viewed 3154 times
3.png
Post Reply