?
Solved

Setting up a view to display NagList

Posted on 2005-05-04
4
Medium Priority
?
215 Views
Last Modified: 2013-12-18
qwaletee suggested creating a view with the following as the select formula

overdue := @Today <= DueDate;
naggies := @Trim(NagList);
empty := naggies = "";
SELECT overdue & !empty;

I have 2 questions -
1. The select is not picking a form?
2. what column needs to be in place to display the results? (NagList?)


0
Comment
Question by:Jaziar
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:HappyFunBall
ID: 13926425
You're not required to filter by form in a view, although often you will filter that way.  

You can use any columns you want.  The selection formula specifies what documents to show in the view.  For your columns, you can pick any fields from those documents.
0
 

Author Comment

by:Jaziar
ID: 13926547
How could I make this statement look for 1 day before the DueDate

overdue := @Today <= DueDate;
0
 
LVL 9

Accepted Solution

by:
HappyFunBall earned 500 total points
ID: 13926701
I assume you want "overdue" equal to True when the DueDate is tomorrow, today, or in the past.  Is that correct?


Here's the code for the that scenario:

overdue := @Adjust(@Today; 0;0;1;0;0;0) >= DueDate;
0
 

Author Comment

by:Jaziar
ID: 13926762
Happy you have been a great help to me - thanks for your promptness.  
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question