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?

Thanks,

Beginner Asked on August 20, 2021 in Saved Searches.
Add Comment
1 Answer(s)

Hello VishalThoughts,

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.

 

Rookie Answered on August 31, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor