I was asked an interesting question on LinkedIn yesterday, is there a way to find out duplicates via AL? So in this post I would like to briefly talk about this topic.
First of all, as test data, I use the copy feature on the Item list page to create multiple items with the same Description, and we need to filter for these lines.