Custom Query Vs Custom Query Cached On Demand

Hi Reut,

Thanks for reaching out to support with your question.

As per the wiki, here are the definitions -

Custom Query: Create a list of values by caching the current contents of the field in the database using a custom SQL query.

Custom query cached on demand: Create a list of values by caching the current contents of the field using the custom SQL query each time the report is loaded.

It would depend on your environment and your report filtering needs as to which filter value list setup you would want to implement.

More info on filters can be found here -

https://wiki.yellowfinbi.com/display/user80/Filter+Formatting

Thanks,

Eric

Thank you.

So is there a meaning by schedule refreshing with Custom query cached on demand ?

From: Support Queue <support@Yellowfin.bi>

Sent: Tuesday, March 12, 2019 8:16 PM

To: Reut Taizi <reut.taizi@galor.com>

Subject: Re: Custom Query Vs Custom Query Cached On Demand [#12802]

Hi Reut,

with the "Custom Query On demand" feature - query is refreshed every time the report is run

as opposed to

Custom Query - query is refreshed when the "refresh" button is pressed

Does that help clarify things for you?

Hi, yes I understand.

Although the explanation is not intuitive.

I don’t really understand what is the meaning of cashing if the query run every time the report is open.

Regards,

Reut

From: Support Queue <support@Yellowfin.bi>

Sent: Thursday, March 14, 2019 10:52 PM

To: Reut Taizi <reut.taizi@galor.com>

Subject: Re: Custom Query Vs Custom Query Cached On Demand [#12802]

Hi Reut,

Here is a bit more depth on the difference -

https://community.yellowfinbi.com/knowledge-base/article/filter-format-cached-values-on-demand

Does this help?

Thanks,

Eric

A little bit,

But still it is difficult for me to see the all picture.

Is there a post explaining all options? With the differences between them?

From: Support Queue <support@Yellowfin.bi>

Sent: Monday, March 18, 2019 6:13 PM

To: Reut Taizi <reut.taizi@galor.com>

Subject: New Comment in "Custom Query Vs Custom Query Cached On Demand"

Hi Reut,

The Filter Formatting wiki link has a list of all options, in this case see the Filter Settings - Entry Style section -

https://wiki.yellowfinbi.com/display/USER74/Filter+Formatting

A previous ticket with a bit more context-

https://community.yellowfinbi.com/topic/cached-value-list-clarification

Let me know if you are still having difficulties.

Thanks,

Eric

Hi Reut,

I'm going to go ahead and mark this question as Answered. Feel welcome to reach out with further inquiries.

Thanks,

Eric