• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

Problem with showing dox in a personal view

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
adspmo
Asked:
adspmo
  • 3
  • 3
1 Solution
 
HemanthaKumarCommented:
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
 
adspmoAuthor Commented:
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
 
HemanthaKumarCommented:
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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
adspmoAuthor Commented:
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
 
adspmoAuthor Commented:
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
 
HemanthaKumarCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now