How to change view datasource?

Vicky shared this problem 1 year ago
Resolved

Hi team,

we have a new datasource in our environment. Our previous reports are based on datasource A, now when want to use same views to create reports, but views point to datasource B. If I copy those views, i don't see a place i can switch datasource. Any idea?

Thanks,

Vicky

Comments (9)

photo
1

Hi Team,

So If I do create new - view, i can find those existing views attached to datasource B, but we are using single table views, so i have to find view names and add those views one by one. Is there anyway to copy and paste previous views and change datasource? thanks.

Thanks,

Vicky

photo
1

Hi Vicky,

Thank you for reaching out. We have a logged defect for this. There should be a change datasource link in the UI in the View Summary section, but there is not. As of an update 4 days ago, the dev team is currently working on the UI spec for this and we are awaiting further updates. I've added you to the client list of those looking for this option.

The workaround at this point is to:Export the view, then import it over the top (to preserve linked objects) - at this point you can then change the data source.

I'll keep you posted with any updates regarding this.

Regards,

Mike

photo
1

Hi Mike,

Thanks for your reply. Workaround works for me.

Thanks,

Vicky

photo
1

Hi Vicky,

You're welcome! Glad this works for you. I'll let you know when this possibility is available via the UI.

Regards,

Mike

photo
1

Hi Vicky,

Just writing to inform you this has been marked as fixed and will be published in our next build, 7.4.8. Approximate ETA for that is December, but I'll let you know a more concrete date as the time gets closer.

Regards,

Mike

photo
1

Hi Vicky,

Just wanted to let you know that this task has now been completed and included in the latest 7.4.8 release.

You can download latest builds here.

Would love to get confirmation your issue has been resolved with the latest release, so please let me know how it all goes post update, and of course reach out if you have any questions on this.

Thanks,

Mike

photo
1

Hi Mike,

Was this change also deployed in the 8.0.0 release?

Also, where in the UI do you change the data source for a view?

photo
1

Hi Steve,

8.0 was released before 7.4.8, so it is not in 8.0. I've inquired about whether it will be included in the upcoming 8.0.1 build.

I too am struggling to find where this setting is located. I've reached out to determine this point as well.

Regards,

Mike

photo
1

Hi Steve,

This will be included in the upcoming 8.0.1 build.

This option is found in the right hand side pane of the View's model page:

/H0N0UQsVwLJyAAAAAElFTkSuQmCC

Regards,

Mike