Date filters are limiting user prompt values

Angelo Rigakis shared this idea 2 months ago
Idea Logged

Hello,

YF: 9.3.1

I am having some data issues when using date filters, and I can recreate the issue within your demo ski team data set.

Please see the attached pictures.

I create a simple report with the fields:  Camp Region and Invoiced Date, and I use both of these in the filters.  When I leave the date filter field blank, I can see all the Camp Region values, but if I populate the date filter, then my Camp Region filter is blank.  I think that this is because there are no Region records that fall within the date range.

Why is the date filter limiting my ability to choose in this case Regions?

This is also happening on our servers hosting YF: 7.4.14.

Thank you,

Angelo

Comments (7)

photo
0

Hi Angelo,

Thanks for reaching out to support. And thanks for this very easy replication process!

I was able to see this myself - and it looks like it's a function of the "allow prompt" setting of the user prompt filter. Based on the language, I believe yellowfin will query the DB for available filter options at the time of the search. This appears to include the other set filter.


535d140ecc88c3da6fcceb9090153e9a

5c88d0b415634245c618e4eb88ef45e3


So now we must play the game "Bug or Feature?" haha!

The only time I could get the filter to apply was when using the textbox and search function, other filter formats showed all values.


6e00b9a279d4d38b695024d98bb038e3


So I'm thinking what we would need here is some kind of option to have the user prompt search NOT query for values, and instead use cached values. Does this sound correct? If so, I could request this functionality to devs and see what they come back with. Let me know what you think.

Thanks,

Eric

photo
0

Hi Eric,

Applying your suggestion did not resolve it, we still have a short list.

So I try :

In the entry list - Value List selection -  Cached Values  >> short list

Then

Custom query – checkboxes  enter the query – and receive this :

This filter is dependent on another filter.

Your query should return these columns:

1 Access Filter: CASEUSERNAME

2: Resolution

Still give a short list.

I also did a test using an old yf version >>> I don’t have this issue all value are display in the filter list.

The version is:

073822ab83d879095e78db1c6e2bca08

Thank you

Mich

From: Yellowfin Support <support@yellowfin.bi>

Sent: Thursday, November 12, 2020 2:54 PM

To: Michel Salomon <MSalomon@i-sight.com>; Angelo Rigakis <arigakis@i-sight.com>

Subject: [EXTERNAL] Date filters are limiting user prompt values [#19925]

photo
0

Hi Michel,

Thanks for testing that, the access filter may be impacting, are you able to remove the dependency and test?

Just to keep the issue and resolution concise though, I think I can ask devs to try to fix the initial issue, which I have replicated even without an access filter - you want the ability to see all values on a user prompt popup, that override a selected date filter, correct?

fad74545689c18093839867b115ff767Thanks,

Eric

photo
0

Hi Michel,

Just wanted to make sure I had this dev task correct in your eyes before submitting?

Thanks,

Eric

photo
0

Good morning Eric,

Yes we are looking for the ability to see all available user prompt values even when there is a date range selected, as currently the date range is limiting our pick lists.

And I’m super happy that you were able to replicate this in your database as sometimes we feel a bit crazy!

Thanks again,

Angelo

From: Yellowfin Support <support@yellowfin.bi>

Sent: Monday, November 23, 2020 6:21 PM

To: Michel Salomon <MSalomon@i-sight.com>; Angelo Rigakis <arigakis@i-sight.com>

Subject: Date filters are limiting user prompt values [#19925]

photo
0

Hi Angelo,

Thanks for the reply here. I've gone ahead and created a developer task to look into this issue. Updates to the task will be provided here as they are available. I will in turn mark this as Idea Logged for now; feel welcome to reply here with related inquiries.

Thanks,

Eric

photo
1

Thank you very much for the help Eric.

Angelo

From: Yellowfin Support <support@yellowfin.bi>

Sent: Tuesday, November 24, 2020 1:48 PM

To: Michel Salomon <MSalomon@i-sight.com>; Angelo Rigakis <arigakis@i-sight.com>

Subject: Date filters are limiting user prompt values [#19925]