May 18, 2016, 11:24 AM
61 Posts
topic has been resolvedResolved

Is it possible to build a view in the PAB that sorts by date added, not date created?

  • Category: Domino Designer
  • Platform: Windows Phone
  • Release: 9.0.1
  • Role: Administrator,Developer
  • Tags:
  • Replies: 5

It appears that a week ago someone fired up an old installation of Lotus Notes and appears to have had the replication options to send to the server for the address book.

We have a number of old person documents that have been added back to the database.

I'm not a developer, but I've asked our contract developer about building me a view with the Added date and he says that field isn't available in View Creation.

Does anyone know if there's a way?  

One good thing is these additions don't appear to have replicated to other servers.

 

May 18, 2016, 2:03 PM
212 Posts
Unwanted replication

I am not sure how to build the view you are looking for, but have you considered enabling PIRC on the Database.  PIRC is Purge Interval Replication Control, and it will stop old/outdated documents from replicating around your environment.

Look at this technote:

http://www-01.ibm.com/support/docview.wss?uid=swg21501675

May 18, 2016, 3:53 PM
307 Posts
Approach

You can export the people view into excel from both nabs and compare what is in this "corrupt: nab to see if they are in the prod nab.  You can do the same in lotus script if you have the ability to write some code

 

The other approach is to copy over a new rep copy of the nab to this server

May 19, 2016, 9:01 AM
260 Posts
Not sorting -- but a folder can be created that'll retrieve docs, then use an agent to sel...

LotusScript inherently looks at the last-modified value in the "added" section.

So while it'll take time to run, you can look for "date added", compare with date created, and figure out a cutoff date to show which docs probably came from the errant replication.

Also -- if it's only one server -- you could get a replica or OS-level copy from one of your other servers. One that you're sure has the proper set of docs.

Make backups of both "bad" & "good" Address Books.

May 19, 2016, 1:23 PM
61 Posts
I have a view that worked

Because we are a smallish company, the view that the developer did built me worked for me.

Because the docs that got copied back in had newer NotesIDs, they were at the bottom of the view.

I was able to locate the name of the last new user created and determine that all names following were the added "bad" names.

Jun 2, 2016, 4:10 PM
190 Posts
View by Date Modified

I assume that the view your developer provided was by Date Modified. If the Domino Directory is full-text indexed, you will see the option to search by date.  You can then change the criteria from date added to date modified.