Updating view metadata in 7.4

Hi Brendan,

looks like you've found a bug! I checked the 7.4 wiki and it definitely documents a link called "Edit Metadata" existing in the View Summary. And you're right, I remember it back in 7.2. So I have raised product defect YFN-11453 so that it gets fixed.

In the meanwhile, you can change the corrupt view's name with the following query:

UPDATE ReportView 
SET ViewDescription = '<insert new name here>' 
WHERE ViewId = <insert ViewId here>

and then restart Yellowfin. By the way, you don't have to restart Yellowfin for the change to take effect if you use the JSP called "info_cached_enhanced" and click the Clear button under the View Cache table as mentioned in the following Knowledge Base article:

https://community.yellowfinbi.com/knowledge-base/article/how-to-avoid-having-to-restart-yellowfin-after-backend-modifications-to-the-yellowfin-database

or you could also use the REMOVEVIEW web service as also mentioned in said article.

Hope that helps, if there are any further questions please let me know.

regards,

David

Thanks Dave, glad it wasn't me missing something! We'll use the above query to make the change and hope the bug is fixed soon.

Regards,

Brendan

yes indeed! Please let me know if there are any issues with that workaround.

One other thing, you raised this issue in a Question, and Questions don't have a status of "Defect Logged", they just have "Answered", "In Progress" and "Awaiting Reply", so I'm wondering whether you'll permit me to convert this into a Problem or a private Ticket (both of which allow the "Defect Logged" status)? Please let me know.

thanks,

David

Hey Dave, absolutely please convert as required (Problem is fine) so it can have the Defect Logged status.

Thanks,

Brendan

thanks Brendan!