Skip to main content
Dave Giannone
New Participant
Oct 2, 2025 1:58 PM UTC

Can the cost fields displayed in WorkOrder Search Results or Work Order Entity Search Results be formatted as currency?

CityWorks 15.8.6/15.8.9. The cost fields that can be requested in a Work Order search result or a Work Order Entity search result display with six numbers after the decimal. Is it possible to display them as "$35.60" instead of "35.601233"? Customized cost fields on other screens using the format="c" on grid column controls, but don't see a way to do that here.

    1 reply

    Dave GiannoneAuthor
    New Participant
    Oct 2, 2025 4:07 PM UTC

    I was able to do this using javascript injection in a customization of the SearchResultsBase -> SearchResults.xml by finding the column position of cost columns, then updating each cost cell of each row of table with toFixed(2). Let me know if there is a better way to do this.

     

    Thanks

    Translate
    Terms & ConditionsAccessibility statement