This has been driving me crazy! I know I’m probably overlooking something small!
I’ve created a view called “test”, which is categorized by “AccountNumber”. All the columns are fields from a form and the View Selection is set correctly.
I’ve created a form called “$$ViewTemplate for test”. In it, I’ve embedded the view “test”.
The problem is that I can’t seem to make the view only show one category at a time. I’ve even tried just putting “56698512” (a working account number) in “Show Single Category”, which SHOULD have returned 3 documents.
Anything I do results in the same – the entire view is shown, complete with twisties & everything.
I’ve even tried using &RestrictToCategory=56698512 in the URL …but that doesn’t work either.
Is there anything I’m leaving out? Thanks for your help!
Subject: Show Single Category – What am I doing wrong?
The “Show single category” formula does nothing when you call the view by URL. (If you had called the form, the formula would have worked.) RestrictToCategory will work, though. Is the category column the first sorted column in the view?
Subject: RE: Show Single Category – What am I doing wrong?
The category column (“AccountNumber”) IS the first column in the view. I just recreated the view to make sure everything was correct, too.
When I call the view->(test?OpenView&RestrictToCategory=56698512), ALL of the documents are shown, categorized, with twisties.
I created a from called “test” and embedded the view in it. I put “56698512” as the “Show single category” formula. When I call the form from the browser->(test?OpenForm), the same thing happens – ALL of the docs are shown, categorized, with twisties.
All of the settings for this DB are default… is there anything else that could be affecting this? …maybe some setting somewhere?
Thanks!
Subject: RE: Show Single Category – What am I doing wrong?
Although it oughtn’y matter with the URL – is the column text or a number? If it’s a number, try using @Text in the columnn formula.
Subject: RE: Show Single Category – What am I doing wrong?
I put a field on the form, above the embedded view, with the formula I wanted for the first column of the embedded view and single category formula. Then I used that field as the formula for that first column of the view.
Now, I have NO idea if this is how you’re supposed to do it, but I know it did work.
Subject: RE: Show Single Category – What am I doing wrong?
Did you try converting the AccountNumber field to have data type of text in the categorised column of the view?
Subject: Well, I’m a dummy!
Well, I decided to try this on another server and… it worked flawlessly!
As it turns out, the server I was developing on is running an older version of Notes. Of course, I had no idea about this, since the Notes servers are in another city and managed by other people.
Thanks for your help though people! I guess you learn something every day!
Subject: RE: Well, I’m a dummy!
You do actually have a way of knowing what versions your servers are. Open a NAB from any server in your domain. In the navigation outline, go to Configuration, then Servers, then All Server Documents. There should be a column called Release - this displays the server version for each server in your domain.