Display PO Line Notes entries in Analytics with the newest notes first, to ensure their inclusion within the character limit
Currently the 'PO Line Notes' field in the Alma Analytics 'Funds Exchange' subject area, displays the content of all note entries attached to a particular PO Line as a single block of text, starting from the earliest-dated note and ending with the latest-dated note. However, as the field's display in Analytics is limited to 4000 characters, this means that the most recent notes are omitted from the report for any PO Lines that are particularly longstanding or have particularly copious notes. This is true both for the report as displayed within the Analytics interface, and for a version exported to Excel. Applying a formula such as RIGHT() to limit the displayed content to the last characters, is only applied by the system to the already-truncated content, and so does not enable the reporting of the most recent PO Line Notes.
Generally, the most up-to-date and relevant information is likely to be in the most recent PO Line Notes entries. This change would be helpful to make funds-focused reports more useful for a range of purposes. Additionally, a latest-to-earliest ordering of the notes in Analytics would bring this field's display into alignment with how the notes are ordered in the Alma interface, improving usability.