I have reviewed the duplicate cases supplied here and they all have very pertinent information, but just not the exact result we are looking for.
This solution was the closest: Remove Duplicate Records on Custom Record Saved Search
Adding the System Notes recommendation, removes the lines where there isn't an approved for posting line.
We have a JE View that is pulling the created by and approved by lines from the System Information Subtab.
We are getting duplicate lines that that is the exact number of line items on the System Information subtab. I can understand this, as NS is iterating through each line to determine if the line in the system information meets the criteria.
Taking JNLBRPG00185 as an example:
Note 11 lines on System Information, and 11 lines on the view:
Per Troubleshooting Steps when Search Results display duplicate/multiple lines
solution the recommendation of using the summary tools are not acceptable, as summarizing the view, inputs two additional steps into the process.
- Opens a new sheet with the summarized data that the user then has to click through
- The click through is not necessary and an additional step
In order to get one line per record with the Created By and Approved By from the System Information, I though to create a custom field that 'pulls' the created by and approved by from the System Information into a Transaction body field, reducing the duplication from multiple lines to one line pulled from one custom field.
Theoretically, that would work? right?
This field is successfully pulling the information into the custom field on the JE record:
In Summary, since we are pulling from these 2 custom fields, (that are iterating through the System Notes), there should only be one line, however we are still pulling multiple lines in the view and it appears to be the iteration through the System Notes.
I even tried to summarize the Approved By custom field by adding a MAX parameter around the case when, but haven't successfully been able to get that to work.
I am going to try and recreate from scratch to see if I can get only 1 line per record.
I thought the custom field would have worked.
Any suggestions?