Implied functionality of placeholder text used on the dispatch board to filter on SM Division requires adjustment.
The actual functionality is it doesn't even exist. It just looks like it does but when you use it, it does not actually filter results based on scope divisions that exist on a WO.
Please add this parameter so it works the same way as the Service Center one does. Without it, even your own default queries don't return precise results when more than one division is present on the same WO. We can write our own queries to give our users precise information after you add this - you don't have to fix your default queries if you don't want to. Just put the parameter in place please.
Veronica Healey
| Company | Troy Life & Fire Safety Ltd. |
| Job Title / Role | Director, Business Information Systems |
| 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.
© 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.
In addition, since the following code is what is used for the {{FilterByDivision}} replacement in the executable
" inner join (select WorkOrder, SMCo, MIN(scope.Scope) as minScope " +
" from dbo.SMWorkOrderScope scope " +
" where scope.Division = '" + board.Division + "'" +
" group by WorkOrder, SMCo) scopeDivision " +
" on scopeDivision.SMCo = wod.SMCo and scopeDivision.WorkOrder = wod.WorkOrder");
The easy fix would be to add additional code for a new {{Division}} parameter
"and wod.Division = '" + board.Division + "'";
which would put it in line with the code that the FilterByServiceCenter is replaced with.
" and ServiceCenter = '" + board.ServiceCenter + "'");
Attachments Open full size