Skip to main content

Get specific user information out of lotus notes without traversing all documents

Getting specific user information out of lotus notes

I had the need of reading from lotus notes specific user information, the solution i had before was traversing whole lotus notes document inside $people view and getting one by one document and comparing if this is the document i need But the problem with that approach was 1) It was not proper of having a loop 2) It was too slow and my web service was getting timed out as it was traversing

There is a better way to do it like following 

var session = new NotesSession();
session.Initialize(password);
NotesDatabase _serverDatabase = session.GetDatabase(serverName, "names.nsf", false);
NotesView _peopleView = _serverDatabase.GetView("$Users");
// Searching using email, if any document matches with this email string
NotesDocumentCollection tmpDoc = _peopleView.GetAllDocumentsByKey(userMail, false);

// There could be multiple enteries
for (int i = 0; i < tmpDoc.Count; i++)
{
    NotesDocument tmpDoc1 = tmpDoc.GetNthDocument(i);
                    // Take full name of a user when firstname+lastname+email matches
    if (firstName.ToUpper() == Convert.ToString(tmpDoc1.GetItemValue("FirstName")[0]).ToUpper() 
       && lastName.ToUpper() == Convert.ToString(tmpDoc1.GetItemValue("LastName")[0]).ToUpper() 
          && userMail.ToUpper() == Convert.ToString(tmpDoc1.GetItemValue("InternetAddress")[0]).ToUpper())
              // Do your thing here
}

Above you can see i am loading a view called $Users and trying to getAllDocuments having a key, in my example i am passing an email, but you can have anything there and that key would be searched in whole document, so if you are passing a text which could be in many fields, multiple document would be returned containing those matches in different fields, and you can compare you condition to make sure you get the right document out of those multiple returned documents in this way you can avoid traversing through all the available documents and instead find one, i thought it would be helpful for others hence sharing it ;-)

Labels:

Comments

Post a Comment

Popular posts from this blog

Set up leprechaun code generation with Sitecore XM Cloud Starterkit

Hi Sitecorians, It has been amazing learning year so far and with the change in technology and shift of the focus on frontend frameworks and composable products, it has been market demand to keep learning and exploring new things. Reasons behind this blog Today's topic is something that was in my draft from April-May, and I always thought that there is already a good documentation out there for  Leprechaun  and a blog post is not needed, Until I realized that there was so many of us facing same kind of issues and same kind of problems and spending same amount of time, That is where I thought, if I could write something which can reduce that repetitive troubleshooting time, That would really help the community. 1)  In a project environment, if we get into some configuration issues, we resolve them, we make sure we are not blocked and continue, but if you think same issue, same step and same scenario will come to other people, so if we can draft it online, it will help othe...
Post a Comment
Read more

401.1 Unauthorized with windows authentication error code 0xc000006d

How many of you have faced this hosting issue when you do everything what it takes to run the site with windows authentication but still you are getting the same error again and again? If you think you also have faced the same issue and you tired of reading MSDN KBs for it and still have not found the issue (If KB has solved the issue, well and good, if not you can try this trick),Please Read below Typical scenario In typical hosting with IIS, i did every possible things like enabling windows authentication, changing it in web.config, configuring connection pool, authorization rules, it asks me for window authentication login and despite of entering correct credentials it always fails and keeps on asking for login, and when pressed cancel it gives 401.1 with 0xc000006d error code Solution (Which worked for me at-least after trying for almost 6-9 hrs) You need to change the Loop Back Check in registry so that it allows the host names which you are giving in url are allowed and au...
2 comments
Read more

Sitecore SXA creative exchange export appends hyphen(-) number to the static assets

Hello There, So, today i will be sharing some information which i think will be useful for many as this might come as a blocker just like me, where i was planning for a next sprint for which i was checking prerequisites and suddenly found out that, Export functionality of SXA is not working properly, it was exporting things but i open the page which was exported (index.html), it was loading without any CSS or JS functioning. Problem I have been using SXA but i never had this issue before, where page or site gets exported but when we open the page, it comes up without CSS or JS functioning properly on the page. So, first thing like any developer i opened up the source of the HTML and tried to see why CSS is not working properly and checked its path and found out following  I was surprised at first point as i never saw this behavior, but one thing was confirmed that, SXA is adding these "-number" at the end of CSS when we export so, i tried to de-assemble the DLL just to see wh...
Post a Comment
Read more