Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum IDEA: Query for Refs Outside of Project
    • Sign In

    • Replies 0 replies
    • Subscribers 60 subscribers
    • Views 447 views
    • Users 0 members are here
    • Reference
    • Saved Search
    • ProjectWise

    IDEA: Query for Refs Outside of Project

    Warren Malveau
    Offline Warren Malveau over 6 years ago

    Our datasources have a Project Property called “DWG NO” which is the same thing as a Project Number in most companies.   Our policy is that each PW project has a unique “DWG NO”, and that drawing sheet documents should NOT reference documents from outside the PW project.

     REQUEST: Create a way to specify a search that lists master documents whose references contain one or more documents that are NOT located in the same PW project as the master document.  This way, we can create saved searches that allow our users to check for discrepancies in their projects.

     Currently, I cannot write this search using the Design Search Dialog.   In the interim, I use a back-door approach of externally accessing and linking PW database tables in MS Access, creating queries, and generating reports like this:

    Note: Two drawing sheets in project 02-g-0101 are referencing files from project JO-g-1214.

    • Sign in to reply
    • Cancel

    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