adspmo
asked on
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))|(Fo rm="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
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")
Second view
SELECT (Form = "leave_fm":"LSF":"olrf" & Approvalstatus="Approved")
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
ASKER
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.
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.
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
If there are any other case sensitive fields like ApprovalStatus and NameFull.. convert it accordingly for comparison
ASKER
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
i had forgotten that I should go in the database and delete the old personal view and replace it withe design change
James
ASKER
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
i had forgotten that I should go in the database and delete the old personal view and replace it withe design change
James
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SELECT Form = "leave_fm":"LSF":"olrf":"E
Is this personal views built inside the database or on desktop ?
~Hemanth