View Selection Criteria

Posted on 2006-06-01
Last Modified: 2013-12-18
Can someone tell me why this code doesn't work? I only want to show documents using form "Yieldsheet1" and only if fields "so" or "so2" have any values in them.

SELECT ((Form = "YieldSheet1")) & (!@Contains(so; "")) | ((Form = "YieldSheet1")) & (!@Contains(so2; ""))
Question by:schmad01
    LVL 14

    Expert Comment

    SELECT (Form = "YieldSheet1") & ((so !="") |(so2 !=""))
    LVL 46

    Expert Comment

    by:Sjef Bosman
    SELECT Form = "YieldSheet1" & @Implode(so:so2;"")!=""
    LVL 46

    Accepted Solution

    Trimming won't harm...

        SELECT Form = "YieldSheet1" & @Implode(@Trim(so:so2);"")!=""
    LVL 14

    Expert Comment

    If you wud be kind enough to see my questoin also


    Author Comment

    Thanks, why didn't I think of that?   :- ]

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses 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.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    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

    19 Experts available now in Live!

    Get 1:1 Help Now