In one of our applications I have a readers field that sometimes doesn’t evaluate and causes an error. I’ve modified it so that if that happens, it’ll contain an administrator’s name in it.
The problem that I have a view with a column among the others, that totals how many documents are in it. I see subcategories that say the total is 11 for example, but there are only 10 documents showing. I’ve tried everything that I could think of (updall, fixup, compact, recreating the column, …) but nothing seems to change the number. The only thing that I could think of is that there is one document that has a readers field that is either in error or corrupted and the doc doesn’t show up, but gets included in the count.
Can anyone recommend a way to go about finding these documents?
Thanks.
JohnD
Subject: Readers Field Problem
Also, (forgot to add to above response) if that’s the case, its kind of bad because this list shows potential sales for users of the sales group. If I’m not allowed to see the document, why does it show up as a count inthe view, worst it takes the potential sales $ and adds it to the user’s numbers. I thought if you weren’t allowed to see a document, it wouldn’t show up with any info in the view.
Subject: Readers Field Problem
It’s neither corrupted nor a bad view - there really ARE 11 documents in that view, but you are only authorised to see 10 of them
To get rid of it, you could replicate the database localyl, the remove the server one and replicate back - replication only brings down docs that you have authority to see
Or you could try opening this view on the Server’s ‘local’ client, in case the server is allowed to see it
Or you could write a backgrounmd agent that appends your Admin user (actually an [admin] role would be better) and sign this with te server id and run it scheduled on the server
If, however, there is only one reader field, and that field is blank, you’re NOT going to be able to see it at all.
I STONGLY recommend creating two reader fields instead of one.
The first has the stuff you want, the second is called something like adminReaders, and has the role [admin] in it
Then you can add whatevere you want to teh admin role to allow them to see all documents
Subject: RE: Readers Field Problem
Thanks for your reply Chris, I king of suspected that but wasn’t exactly sure. You have a good point, I have other forms with multiple readers fields, but this only has one. Do you think if I remove the readers field from the form and then rebuild the view index would those docs become visible?
JohnD
Subject: RE: Readers Field Problem
I’m afraid not - you have to separate in your mind the Form and the DocumentThat DOC has a readers field - it doesn’t matter what FORN you try to use to view it, it still has the same readers field
Do you think it is empty?
Subject: RE: Readers Field Problem
I think it has an error in it. However, I’ve seen cases in the past when the field contained an error, but I was still able to see the doc. Not sure why this is different.
JohnD
Subject: RE: Readers Field Problem
I heard that in R6 if you’re a full access administrator, that overrides all acl and reader field settings. Shouldn’t then I be able to see them, I’m in that field on the server doc.
Subject: RE: Readers Field Problem
That’s news to me - I’ve never heard that but it might be possibleHave you tried looking for these documents from the server client?
You couldalso carete a view, where the selecion criteria is that the readers field does NOT comain any of the ‘wat you think i should be’ values - and categorise it on thereaers field, see if any are visible from the server client that way, or at least find out what values are in these fields
Subject: Readers Field Problem (Solved)
here’s a workaround. In the database I had Consistent ACL checked. I unchecked it and went to the server and opened up the DB from there as local, that allowed me to see the docs. When I did that before, I had consistent ACL checked and that’s why it didn’t work.
Thanks.