Need help with Views

30 pts.
Tags:
Domino Designer
Formula Language
Lotus Domino Server 6.x
Lotus Notes View
Very new to dominio designer I am creating a view for ‘Open’ documents that is based on a ‘Target Date’ field I got the "<30 days" view working and the ">90 day" view working , cant figure out the "30- 90 days" My formula for <30 day view is: SELECT Form = "Form Name" & ProjectStatus = "Open" & @IF (targetdate) <= @Adjust(@Today;0;0;90;0;0;0) Any help is really appreciated
ASKED: April 17, 2008  5:50 PM
UPDATED: April 18, 2008  10:01 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Despite the possibility of doing this, the recommendation absolutely has to be to never do this. Never use any reference to the current date in a view selection formula. If you have more than a few hundred documents in this database, it can kill the performance of the server. Instead, use the suggestion of using a status field. Another good addition is to categorize by the year and month so that users can drill down to a specific month. Another flourish to this idea is to wrap it in a form using a single-category embedded view.

<HR>

dt1:=@Adjust(@Today;0;0;29;0;0;0);
dt2:=@Adjust(@Today;0;0;91;0;0;0) ;
SELECT Form = “Form Name” &
@uppercase(ProjectStatus) = “OPEN” &
targetdate> dt1 &
targetdate< dt2

NOTE: I’d try an actual hardcoded date first
The compare @NOW or @Today to the hardcoded date

Hardcode a date like this [04/17/2008] being today

you might need
@date(targetdate)

Also, you may want to use a single view that includes all open items instead of having a view for each category. For instance, the selection criteria would be

SELECT Form = “Form Name” &
@uppercase(ProjectStatus) = “OPEN”

Then add a category with this code:
dt1:=@Adjust(@Today;0;0;29;0;0;0);
dt2:=@Adjust(@Today;0;0;91;0;0;0) ;
@if(
targetdate< dt1;
“1. Less Than 30 days”;
targetdate> dt1 & targetdate < dt2;
“2. 30 – 90 days”;
targetdate > dt2;
“3. Greater Than 90 days”;
“Not Categorized”)

Thank you both for helping me, I ended up doing the single view using the categories. I do reallly appreciate the time you took out of your busy schedules to help me.

thanks again

Matjo

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Matjo
    Thank you both for helping me, I ended up doing the single view using the categories. I do reallly appreciate the time you took out of your busy schedules to help me. thanks again Matjo
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following