I have an Opportunity, under which I had initially added two Opportunity split records. But later I deleted one of the Split records among them using the delete button in the UI, as I didn't need it anymore.
But after that when I query for the Opportunity split records for this particular Opportunity using the following query,
SELECT Id, SplitOwnerId, OpportunityId, SplitPercentage, SplitOwner.Id, SplitOwner.FirstName, SplitOwner.LastName, SplitOwner.Email, isDeleted FROM OpportunitySplit WHERE Opportunity.Id = '0062h00000RHMH9AAP'
I am still receiving the deleted record too. And the 'isDeleted' value is false too. I am attaching the screenshot of the same below.
can someone please let me know why is the query returning the deleted record too with the existing record? Thanks in advance.
The above image is of the existing single split in the UI after deleting another split.
The above image shows another split returning through query even after deletion.