View not displaying data even with correct Formula

Hi,

I am having a weird issue with Notes 8.5. Apparently we have a long history of upgrading slowly from 6.5 and it appeared that only those views that have been created in previous version can display data properly.

I tried to create a new view (8.5) with very simple selection and it shows blank in Notes Client, even though with many refresh.

I tried to search on the view and it can show result that means selection formula is correct, just the view does not know how to display them.

Can anyone help me with this issue ? Now I am forced to copy all view and modified data to make them work only.

Thanks

Subject: Re: View not displaying data even with correct Formula

I have not been able to reproduce this issue on 8.5. Here are my steps:

Created a new database from the discussion template.

Added a few Main Topic and Response documents

Created a new View (myView) with a simple view selection formula:

SELECT (form = “MainTopic”)

When I open myView, documents are appearing as expected

One thing to check for if you are using the Form field in your selection criteria, the selection needs to be against the alias name (not the form name).

In a discussion database, the Main Topic form name has a blank space but the alias does not:. So,

SELECT (form = “Main Topic”) → This view selection does not work

SELECT (form = “MainTopic”) → This works

If this does not help, please provide me with more specific steps and I will be happy to investigate further.

Thanks