Setting up a view to display NagList

Posted on 2005-05-04
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?)

Question by:Jaziar
    LVL 9

    Expert Comment

    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.

    Author Comment

    How could I make this statement look for 1 day before the DueDate

    overdue := @Today <= DueDate;
    LVL 9

    Accepted Solution

    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;

    Author Comment

    Happy you have been a great help to me - thanks for your promptness.  

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now