Change report filter defaults within repo?

Hi Bryan,

Thanks for reaching out. This is indeed possible by updating the ValueDataOne columns in both the reportfilter and reportfilterinstance tables.

As a precaution, make sure you have backups before running any queries against the configuration database as doing so can cause irrevocable data loss.

You can run a query like the following in both tables:

UPDATE 73yellowfin20171201.reportinstancefilter SET ValueDataOne = 'TestDefaultValueDos|' WHERE ValueDataOne = 'TestDefaultValue|';

You may also need to reference the ReportId, which can be pulled from the reportheader table, depending on your exact use case.

Anyways, update the filter value in these two tables, and restart the Yellowfin server and the value should change.

Here's my original:

After Update queries and restarting server:

Please let me know how goes and whether you have any further questions.

Regards,

Mike

Hi Bryan,

I just wanted to check in and see how things are going with this.

Regards,

Mike

Hi Bryan,

I've been informed by Joel this item is no longer being pursued. This being the case I'll go ahead and close this ticket out.

Please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike