System note data in one line on saved search
We have a three level approval for purchase orders. I have received a requirement to show who approved at each level and the timestamp against every PO in saved search,
When I started creating this search, I am struggling to get the data for every PO in one line, as the system note data has one line each for every approval.
Can you please advise on how to get these multiplelines on a single line for every PO?
Beginner Asked on August 20, 2021 in Saved Searches.
You should be able to use NSCONCAT for that. If you provide a screenshot of the system notes and outline requirements I should be able to help out with this.