Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problem with showing dox in a personal view

Posted on 2003-12-05
6
Medium Priority
?
208 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
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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 1400 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

926 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