Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki A way to search documents in a specific version and showing related references (references and referenced by) on search results
    • 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. 

    A way to search documents in a specific version and showing related references (references and referenced by) on search results

    Just to share a way to search documents in a specific version and showing related references (references and referenced by)

    * select 'Search Builder' command

    * change dialog windows as attached image

    command text is :

    $FIELD$ IN (select distinct d.o_docguid from dms_doc d, dms_setm s where  (d.o_stateno=(select o_stateno from dms_stat where o_statename='State_to_Search' )) and   (d.o_docguid = s.o_pdocguid) OR (d.o_docguid = s.o_cdocguid))

    change text State_to_Search to state name to search for master documents.

    That is all. you also can add additional Criterias

    • queries projectwise sets references searchs
    • Share
    • History
    • More
    • Cancel
    • Rogerio Duarte Created by Bentley Colleague Rogerio Duarte
    • When: Mon, Feb 17 2014 3:57 PM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Fri, Sep 9 2022 11:40 AM
    • Revisions: 3
    • Comments: 0
    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