Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum Lookup Tables: A slightly more complex SELECT statement?
    • Sign In

    • Replies 5 replies
    • Subscribers 62 subscribers
    • Views 3391 views
    • Users 0 members are here
    • lookup tables
    • ProjectWise

    Lookup Tables: A slightly more complex SELECT statement?

    Paul Patterson
    Paul Patterson over 8 years ago

    Morning Everyone,

    We introduced a lookup table some time ago to allow for drop down menu's in our interfaces, configured at the project level. So far, this has worked as expected. If you haven't looked into this, I highly suggest it.

    The basic select statement we have is the usual..

    SELECT value, value_description FROM LOOKUP_TABLE where ATTRIBUTE='AREA' AND PROJ_NO=$PROJECT#PROJECT_Project_Number$ ORDER BY SORT_ORDER

    So far so good.. the query above finds the records that are related to the project number the user is working in. check.

    What I'd like to do is have a query that will query the records as above, but if the results are null, query a second set of records where PROJ_NO = 000000. This would allow us to have a default set of values, where not overridden by values defined by the project.

    Any thoughts on how to achieve this?

    Paul Patterson

    • 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