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