1 of 1 people found this helpful
If the calculation you have on a business object attribute is set to "After Read" this should then calculate when you run the query as you are effectively "Reading" the attribute.
As for the urgency rank but displaying the title, just do the following:
- Add the title and rank to your query fields.
- Go to the properties of the rank field and under the Appearance tab remove the tick from "Show Column"
- Apply sorting to the field "rank" as normal!
Hope that helps!
Brilliant solution to the Urgency (title vs rank), that can be very useful. My client wants to be able to sort by other fields as well (from the web access), so I don't necessarily want to the query sorted on one specific field all the time. I'll try your suggestion and see if that can possibly allow resorting (or changing from ascending to descending).
The calculation I was hoping to do was on the query itself, if that's even possible, I suppose I could add an attribute if that's the only way to get this to work.
Thanks for your reply!
I doun't believe you can do the calculation directly in the query designer, so you will need to add an attribute to the object the query is being written on and make it an after read calc as Terry suggested.
As to the sorting, you can again follow Terry's suggestion as this will in effect be the default sorting. Anyone running the query in webdesk has the option of changing the sort order by right clicking the column headings.