Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki How to do a smart search that doesn't include a "or" but a "and"
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • -ProjectWise Explorer Client
      • +ProjectWise Client
      • +Featured Articles - Projectwise Explorer
      • +Audit Trail - ProjectWise Explorer Client
      • +Bentley IMS Login
      • +BS1192 Rules Engine - ProjectWise Explorer Client
      • +Check In Dialog - ProjectWise Explorer Client
      • +Document Code - ProjectWise Explorer Client
      • +Document Creation - ProjectWise Explorer Client
      • +Documentation & Help - ProjectWise Explorer Client
      • +Environments and Attributes - PWE
      • +Export / Import Tool - ProjectWise Explorer Client
      • +Folders / Subfolders - ProjectWise Explorer Client
      • +GUI - ProjectWise Explorer Client
      • +Installation - ProjectWise Explorer Client
      • +Integration - General
      • +Integration - AutoCAD - ProjectWise Explorer Client
      • +Integration - Civil 3D - ProjectWise Explorer Client
      • +Integration - DGN Platform - ProjectWise Explorer Client
      • +Integration - MicroStation - ProjectWise Explorer Client
      • +Integration - Office - ProjectWise Explorer Client
      • +Integration - Revit - ProjectWise Explorer Client
      • +Logs Troubleshooting- ProjectWise Explorer Client
      • +Messaging Service - ProjectWise Explorer Client
      • +MISC - ProjectWise Explorer Client
      • +Open / Save / Copy / Move - ProjectWise Explorer Client
      • +Photo Preview - ProjectWise Explorer Client
      • +ProjectWise Managed Workspaces
      • +Project - ProjectWise Explorer Client
      • -Search - ProjectWise Explorer Client
        • A way to search documents in a specific version and showing related references (references and referenced by) on search results
        • A way to search only document versions in PW
        • How do I see what files a user has checked out, copied out, or exported
        • How to do a smart search that doesn't include a "or" but a "and"
        • Last Error [-1] The view contains invalid column '{name}.
        • Saved Searches in Projects
        • Saved Searches Permissions
        • Unable to create Global Searches within a project even as an administrator
      • +Security and Permissions - ProjectWise Explorer Client
      • +User Tools - ProjectWise Explorer Client
      • +Views - ProjectWise Explorer Client
      • +Workflows & States - ProjectWise Explorer Client
      • +Network Configuration - Client
    • +ProjectWise Administrator
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services
    • +ProjectWise Logging and Tools

     
     Questions about this article, topic, or product? Click here. 

    How to do a smart search that doesn't include a "or" but a "and"

      Product(s): ProjectWise Explorer Client
      Version(s): 08.11.11.574
      Area:  Search
      Original Author: Marty Nickel, Bentley Technical Support Group

    How to do a smart search that doesn’t include a “or” but a “and”

    Example

    Document Description: NOT LIKE’*NOTE TO BE USED*’, NOT LIKE’*Withdrawn*’

    Steps to Accomplish

    Input the following string in either the regular search or the advanced search builder in the Document Description:

    $FIELD$ NOT LIKE'%NOTE TO BE USED%' AND $FIELD$ NOT LIKE'%Withdrawn%'

    • search
    • how to
    • ProjectWise Explorer Client
    • SELECTsupport
    • Share
    • History
    • More
    • Cancel
    • Marty.Nickel Created by Bentley Colleague Marty.Nickel
    • When: Wed, Feb 12 2014 10:58 AM
    • Thomas Hess Last revision by Thomas Hess
    • When: Wed, Aug 3 2016 10:35 AM
    • Revisions: 4
    • Comments: 2
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies