get distinct items in a collection if other item is not null
- by Anurag Sharma
I have a collection like this
{
Country : 'XYZ'
Books : [
{"name" : "book1", "url" : "book1url", "auth_email" : "emailid1"},
{"name" : "book2", "url" : "book2url", "auth_email" : "emailid2"},
{"name" : "book3", "url" : "book3url", "auth_email" : "emailid3"},
{"name" : "book4", "url" : "book4url", "auth_email" : "emailid4"}
..........................................
]
}
I want to extract distinct 'Books.name' and corresponding 'Books.email' only if 'Books.email' is not = ''
