Avatar of pratigan
pratigan
Flag for United States of America asked on

Sort by filter in a calendar view in lotus notes database.

I have a calendar view in notes that contains entries for staff for when they are going to be out of the office for vacation, dentist or whatever.  The view allows you to view it be 2 days, weekly, month, etc.  The entries in the view are sorted by Name (other than date of course).  The entries allow for an account name as well.  now the entries are listed by name and reason and account name such as accnt1 or accnt2 or accnt3 etc.  But the entries are only sorted by name so the accounts are inter mixed.  Is there a way that I can have a filter button at the top that would allow me to filter on account ???  This way the account managers could filter on just there account and see whom is out of the office easier for just their account ???
Lotus IBM

Avatar of undefined
Last Comment
Sjef Bosman

8/22/2022 - Mon
pratigan

ASKER
I'm thinking an action button at the top of the calendar view that contains something like this:
@Prompt([OKCANCELLISTMULT]; "Select a Name"; "Select one or more names as recipients for this request."; "Mary Tsen"; "Mary Tsen":"Bill Chu": "Michael Bowling":"Marian Woodward")

but using account name.  the user selects the account they want to see.  that value is then assigned to a variable that is assigned in a set view command like this:
choice:=@PickList([CUSTOM] : [SINGLE]; @DbName; "Resources";"View by Room or Resource";"Select the room or resource whose calendar you want to see:"; 1);
@SetViewInfo([SETVIEWFILTER];choice;"$20";0)
Sjef Bosman

See @SetViewInfo:
"In Calendar views, filters a view to display only documents that contain a specified string in a specified column."
ASKER CERTIFIED SOLUTION
Sjef Bosman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pratigan

ASKER
the $20 is just an example of the type of thing I'd do.   The actual prompt would be this:

choice@Prompt([OKCANCELLISTMULT]; "Select an Account to Filter on"; "Select one or more Accounts from the list."; "Accnt1"; "Accnt2":"Accnt3": "Accnt4":"Accnt5")

 @SetViewInfo([SETVIEWFILTER];choice;"OOaccount";1)

ooaccount is the column in the calendar view that contains the account names for the entries

I think that would work ??
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
pratigan

ASKER
lol... well I thought it would work.

It does nothing.  Here is a screen shot of the calendar view columns.
pratigan

ASKER
ooohhhhhhhhhhhhh... I GOT IT !!!!

the programatical column had and @If clause.  when I took that out and use the actual programmatic value..... the view filter worked !!
pratigan

ASKER
As always... your input and feedback is very much Appreciated !!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Sjef Bosman

Splendid! You see, you're a Notes programmer after all. ;-)