Solved

How to fix indexing issue when 'Private and Shared on First Use View' is being used?

Posted on 2011-03-14
13
614 Views
Last Modified: 2013-12-18
Hi,

The view 'vwAcc' is 'Shared and Private on first Use' . The Selection formula used is SELECT ((Form = "Account Profile")) & isbkp !="Yes" & (@Contains(@Name([CN];Author);@Name([CN];@UserName)) | @Contains(@Name([CN];Author1);@Name([CN];@UserName)))

The code is used -- Set picklist = workspace.PickListCollection( PICKLIST_CUSTOM,False, db.Server,db.FilePath,"vwAcc", _
      "Document picker",       "Please select one Profile,  to create checklist.")  

Issue is - This view is empty at times for the user.  When we use 'Shift+F9' the index is rebuilt and the documents are populated. Surprisingly, its working fine for me on the Development copy but for a few users across locations this is a major issue.

Can anyone suggest how to avoid this issue?  Without using 'Shift+F9' the view must populate all the documents. If a design change has to be made so as not to use the 'Private and Shared view' please do let me know.
0
Comment
Question by:shals0628
  • 6
  • 5
  • 2
13 Comments
 
LVL 13

Expert Comment

by:CRAK
ID: 35136042
The phenomenon is unknown to me, but are you sure that those users private views have the same design version as all other users? Such views do not inherit design changes (like refresh details).
My 1st attempt at this point would be the removal of those users' private views (so they would get recreated).
0
 
LVL 10

Expert Comment

by:larsberntrop
ID: 35136152
Private on First Use are handy yet problematic.

You are better off using an embedded view, categorized on User.  Or use an XPage
0
 

Author Comment

by:shals0628
ID: 35136460
@CRAK - yes, a few users use lower version that could also be another reason for this issue. How do I resolve this issue?
@Larsberntrop - I cannot use embedded view - the scenario is -- View action button - when the action button is clicked - user is populated with a list of documents in the Document Picker to choose from. How do I use an embedded view here?
0
 
LVL 10

Expert Comment

by:larsberntrop
ID: 35136653
Use a dialog form for the picker => you can use an embedded view on that
0
 

Author Comment

by:shals0628
ID: 35136834
okay, thanks. But how do I get to use that same selection formula? SELECT ((Form = "Account Profile")) & isbkp !="Yes" & (@Contains(@Name([CN];Author);@Name([CN];@UserName)) | @Contains(@Name([CN];Author1);@Name([CN];@UserName))) ---- is not giving the same out put as the 'Shared and Private on first use view - Aim is to populate only those documents in the view which have username in the names field 'Author' or 'Author1'.
0
 
LVL 10

Accepted Solution

by:
larsberntrop earned 125 total points
ID: 35136913
for view use:
SELECT Form = "Account Profile" & isbkp !="Yes" & @Trim(Author:Author1)!=""

in view 1st column:
@Trim(@Name([CN];Author):@Name([CN];Author1))

In embedded view properties, show single category:
@Name([CN];@UserName)
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 10

Expert Comment

by:larsberntrop
ID: 35136915
and 1st column must be categorized...
0
 

Author Comment

by:shals0628
ID: 35137292
Let me re-phrase - the view should populate documents if and only if user's name is present in the 'Author' or 'Author1' field. i.e. if my name is present in the 'Author' or 'Author1' field only then I can view the document, other documents I should not be able to view. So, can I use the above for this case?
0
 
LVL 10

Expert Comment

by:larsberntrop
ID: 35137569
try it.
0
 
LVL 13

Expert Comment

by:CRAK
ID: 35138447
To remove the private view, following link might help:
http://www.breakingpar.com/bkp/home.nsf/0/87256B280015193F87256B880071F14F
0
 

Author Comment

by:shals0628
ID: 35155271
@Larsberntrop - I cannot use embedded view. When the action button is clicked the view is opened in with the documents for user to choose. So I cannot use the embedded view formula for that column. I have tried the view selection formula, but its showing all documents, not the expected output i.e. 'the view should contain documents in which user's name is present in the 'Author' or 'Author1' names field'. please help.
0
 
LVL 10

Expert Comment

by:larsberntrop
ID: 35155325
looking in Designer help, i see:

Set notesDocumentCollection = notesUIWorkspace.PickListCollection( type% [, multipleSelection ], server$, databaseFileName$, viewName$, title$, prompt$ [, Singlecategory$ ] )

Notice the [, Singlecategory$ ] ??

All you need to do is build the view as specified, and add the canonical username as the SingleCategory parameter.

Done!
0
 

Author Closing Comment

by:shals0628
ID: 35168013
Thanks a lot!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now