Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Filter data in the look up tables using Select statements
    • Sign In

    • State Not Answered
    • Replies 3 replies
    • Subscribers 61 subscribers
    • Views 1945 views
    • Users 0 members are here
    • ProjectWise filter data

    Filter data in the look up tables using Select statements

    Qadeer Hussain
    Offline Qadeer Hussain over 9 years ago

    I have different Disciplines codes for each Project number. I have set up 2 look up tables, ProjectNo and Discipline. I want if I choose a project 0001, my discipline table only show me vaules related to project 0001. Can anyone explain me how can achieve it using Select statement filter?

    • Sign in to reply
    • Cancel
    Parents
    • Phil Chouinard
      0 Offline Phil Chouinard Tue, Jun 3 2014 5:52 PM
      Could you identify what Bentley product and product version you are using?
      ________________________________

      From: qadhusuk
      Sent: 6/3/2014 5:42 PM
      To: BeCommunitiesFeedback@communities.bentley.com
      Subject: [Be Communities Feedback Forum] Filter data in the look up tables using Select statements

      View and reply online
      Replying to this email posts your reply in the thread.
      ________________________________


      I have different Disciplines codes for each Project number. I have set up 2 look up tables, ProjectNo and Discipline. I want if I choose a project 0001, my discipline table only show me vaules related to project 0001. Can anyone explain me how can achieve it using Select statement filter?

        

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Qadeer Hussain
      0 Offline Qadeer Hussain Tue, Jun 3 2014 5:57 PM in reply to Phil Chouinard

      I am using ProjectWise SS4 version 081111579. I want second field only show data filtered by vaule in first field. something which has been done in BS1192 where Zones are filters by role code selected.

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Peter Willmen
      0 Offline Peter Willmen Wed, Jun 4 2014 3:21 AM in reply to Qadeer Hussain

      Are you able to provide an example of your lookup tables?

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Reply
    • Peter Willmen
      0 Offline Peter Willmen Wed, Jun 4 2014 3:21 AM in reply to Qadeer Hussain

      Are you able to provide an example of your lookup tables?

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    Children
    No Data

    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