Saturday, September 8, 2018

Show the Latest Detail of an Issue in a Saved Search

To create the search, perform the following steps:

     1. Navigate to Lists > Search > Saved Searches > New.

     2. Select Issue.

     3. Provide a Search Title.

     4. In the Results tab > Columns subtab, add the following:

Field

Summary Type

Formula

Number

Group

 

User Notes : Date

Maximum

 

Formula (Text)

Maximum

max(to_char(substr({usernotes.note},1,3900))) keep(dense_rank last order by{usernotes.notedate})


     5. Click Save and Run.

No comments:

Post a Comment