Please allow us to use placeholders (question marks) within the From field when designing User Defined Lookups.
Giving us this flexibility would allow us to use functions as sources, just like we can in normal SQL code.
For people not familiar with how User Defined Lookups work, they are basically a place to define the "what the database presents" when a user taps F4 within a field.
The design is as follows:
From field: Usually a table name like "PREH"
Where field: Usually some kind of filter, like "PRCo=? and Employee=?"
Join field: Usually where other table are joined
Currently we can put placeholders (question marks) in the Where field, but not the From field.
We also cannot put placeholders in the Join field.
Nathan Sutherland
| Company | A-1 Plumbing |
| Job Title / Role | Developer |
| I need it... | Yesterday...Come on already |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.