Forum

Refresh a view behind the subquery

I have done a great report where I use subqueries from 3 different views.

Then I needed to add a new field to a view, used in subquery.

After the change, When I start to create new report I see new field but when I edit subqueries of my report, new field is missing from view??

How can I refresh my subquery-report to use lates view so I could add new field to a report

Br.
andy

Hi Andy,

Sorry to hear you are running into problems getting a field to appear in one of your sub queries after adding it to your view.

Do you think that you could let us know what version/build of Yellowfin you are using? To check the build of Yellowfin you are using go to System Information under Administration > Admin Console > System Information. The version of Yellowfin is listed next to Application Version.

I'm going to go ahead and start testing this in the most recent build of Yellowfin (7.1 20150729) but it would be useful to know which version you are on as well to see if upgrading might solve the problem you are experiencing.

We look forward to hearing back.

Cheers,

Dustin

Hi Andy,

Just a heads up, I tested this in my version/build and the field was immediately available to the sub query in my report.

This may be something that you can resolve simply by upgrading. Please let me know what you think.

Have a great day!

Regards,

Dustin

Hi,
Thanks, it seems that latest update helped (at least in test environment)
Next step is to to update also prod-environments. If problem still exists i let you know.

Br.Andy

And version where this problem was found was:

Application Version: 7.1
Build: 20150624

SORRY.

PROBLEM STILL EXISTS...

New objects in View not shown in Views behind the subqueries :(

Application Version: 7.1
Build: 20150902

Hi Andy,

I'm sorry to hear that upgrading your production environment didn't yield the results you were hoping for.

Do you think that you could attach some screenshots demonstrating what you are describing? They would be useful in further troubleshooting this issue.