Solved

Problem with showing dox in a personal view

Posted on 2003-12-05
6
204 Views
Last Modified: 2013-12-18
Hi Guys



I have two views that are essentially the same. Thet are calendar views. The selection formula is the same for both except on the second view it only returns the document for the person based on @UserName, in other words a personal view.

In the first view I can see my dox as expected in the second view I cannot

First view
SELECT ((Form = "leave_fm": "LSF":"olrf") & Approvalstatus="Approved")|form ="Event"

Second view
SELECT (Form = "leave_fm":"LSF":"olrf" & Approvalstatus="Approved") &( NameFull = @Name([CN];@UserName))|(Form="Event")

I inherited this application and there is something I do not understand I designer there are two designs for the second view
Both have a key Icon Beside them(??) and one has a 1 above the key what the hell is this.
I have tried rebuilding the second view by deleting both views from design and it still does not work

Any ideas

James
0
Comment
Question by:adspmo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9883396
I think this should be correct selection for 2nd view

SELECT Form = "leave_fm":"LSF":"olrf":"Event" & Approvalstatus="Approved" & NameFull = @Name([CN];@UserName)

Is this personal views built inside the database or on desktop ?

~Hemanth
0
 

Author Comment

by:adspmo
ID: 9883448
In the desktop

Event is a separate form that does not have an approvalstatus field that is why it is at the end

I should be able to see my dox,, they are not there.
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 9883521
Try this, Select NameFull = @Name([CN];@UserName)  & (@LowerCase(Form) = @Lowercase("leave_fm":"LSF":"olrf") & Approvalstatus="Approved") | Form = "Event")

If there are any other case sensitive fields like ApprovalStatus and NameFull.. convert it accordingly for comparison



0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:adspmo
ID: 9883547
HEy I got it working


i had forgotten that I should go in the database and delete the old personal view and replace it withe design change

James
0
 

Author Comment

by:adspmo
ID: 9883548
HEy I got it working


i had forgotten that I should go in the database and delete the old personal view and replace it withe design change

James
0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 350 total points
ID: 9883582
That is what I was targeting When I meant if it is in DB or desktop.. but you mentioned

>I have tried rebuilding the second view by deleting both views from design and it still does not work

Which is misleading in case of personal views.. where personal view have main design template and other functional views per user.

Always Personal views are dangerous.. as they won't update dynamically when the main design of the view is changed
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 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