If we have a great query in VA Inquiries, why can't we also use it to populate a lookup?
In UD UserDefined Lookop I'd expect
Any input? How tricky would this be to implement?
Nathan Sutherland
| Company | Cutting Edge Plumbing & Mechanical |
| Job Title / Role | Developer |
| I need it... | 1 month |
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.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
Viewpoint, an alternative to allowing us to use VA Inqueiries would be to modify your "Parse the data in UD User Defined Lookups" function so that it swaps out the "?" in the FROM line, just like it currently does in the WHERE line. This would allow us to at least use functions for User Defined Lookups.
Just ran across this need again. I have a great function, but no way to call it from within a "User Defined Lookup".
In this case, I do have a view with almost exactly the same underlying code, but it has to union a bunch of data together before it can filter it.
With the function, I can do the filters WITHIN the underlying code, significantly decreasing the cost (500x or so).
Viewpoint, Is there any chance that we'll get the ability to use VA Inquiries within "User Defined Lookups"?
Sometimes I need to call a FUNCTION or STORED PROCEDURE to create values to display in a lookup. This is not easy to do with a view.
That's why I'm asking for the ability to use VA Inquiry, as they allow one to enter much more flexible SQL.
Maybe your inquiry is fancier than I imagine, but perhaps you could create a View from that inquiry and select from there...