How to update view using yellowfin webservice & refresh.

Hi Vishal,

Thanks for reaching out to support with your issue.

It sounds like the issue as its base-

A view name has been changed at the Data Source Level.

This view name change is not reflected in Yellowfin.

you are looking for a way to apply this change via webservice upon a report's refresh.

Some questions -

-Could you provide screenshots of the name change and the resulting unexpected behavior?

-Could you explain what you mean by (Ar system form)?

-Could you provide step-by step details of what you are doing and your objective for the purpose of replication?

Hi Eric,

-Could you provide screenshots of the name change and the resulting unexpected behavior?

select * from reportview;

In old yellowfin database(reporting) suppose view name was A pointing to old data source.

In latest data source now table is renamed to B but still yellowfin database (reporting) has A table thus eventually yellowfin(reporting) application will not found A table in data source.

-Could you explain what you mean by (Ar system form)?

you can say it's a table in data source (or database table is a form).

- Could you provide step-by step details of what you are doing and your objective for the purpose of replication?

Now we wanted rename A table to B table in yellowfin database (Reporting) how to process it. how we can rename the view name from reportview table please provide a best practice of doing this task.

Actually data source is updated its table name(renamed) it's another application.

Let me know if you got the problem.

Thanks,

Vishal

Hi Vishal,

Thanks for the additional info.

I was able to fix a report that had a renamed table at the db level by renaming in the view builder -

There doesn't appear to be a way to rename a view's table using web services at this time, however. Would you like me to raise an enhancement request for developers to potentially include this functionality in a future build?

Thanks,

Eric

Hi Eric,

We don't wanted to user to change manually, As you shown change old source name to new source name. Can we do it through webservice call. If we can do it through UI means so webservice call made by yellowfin application check if we already have this or not?

Thanks,

Vishal

Hi Vishal,

I will double check with developers to see if there is an undocumented solution to this, and will provide an update. if there is not, I will proceed to create an enhancement request on your behalf.

Thanks,

Eric

Hi Eric,

Thanks waiting for your reply.

Thanks,

Vishal

Hi Vishal,

I have gone ahead and created a enhancement request to developers to provide the functionality you are seeking. Updates to the request will be provided here aas they are available. I will in turn mark this as Idea Logged; feel welcome to reply to this ticket with further related inquiries.

Thanks,

Eric

Hi Eric,

if we change directly through DB update query & restart the tomcat like

update ReportView set ViewName='new_view' where ViewName='old_view'

can we do like this. I guess your image operation might doing the same thing.

It worked for me.

Thanks for creating idea, please add this functionality through webservice we don't wanted to update though the DB query.

Thanks,

Vishal

Hi Vishal,

Thanks for the reply. Glad to hear you have found a workaround in the meantime. I will keep you updated on the developer enhancement request here.

Best,

Eric

Hi,

The workround not working when calculated fields are used. Can you check what SQL queries do we need to issue to update the view with new name. Meantime as there know webservice for this.

Thanks,

Vishal

Hi Vishal,

I've been asked to provide a use case to developers for this enhancement, would you be able to provide this to better clarify the situation?

Also, I am waiting for a reply from development for a statement that would provide the functionality you are seeking, however, changes to the back end as this are not fully supported or tested against, and it's hard to gauge the long-term impact these type of adjustments can have on the system. Please make sure you have quality tested backups when attempting these types of modifications.

Thanks,

Eric