Hi I had a question on the get distinct records option available in the drill down tab of the summary view. on what basis does it removes the duplicate records. Does all the properties that are in the drill down needs to be same to be treated as duplicate .
I have 2 records where the pyid is same and wants only one of them to be visible . How can we achieve that.
That is the definition of the DISTINCT functionality in an SQL query. If more than one column is specified in the query, any record where all of the column values match those of another record will be omitted. I don't know of any way that a query can be constructed where multiple columns are selected but only one is specified as DISTINCT.
As there is no way to code the query, there is no way to provide this functionality.