Link to home
Start Free TrialLog in
Avatar of adspmo
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))|(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
Avatar of HemanthaKumar
HemanthaKumar

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
Avatar of adspmo

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



Avatar of adspmo

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
Avatar of adspmo

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
ASKER CERTIFIED SOLUTION
Avatar of HemanthaKumar
HemanthaKumar

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial