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
adspmoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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



Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.