In the CRM_JEST table, one lead document has two active user status. Thus the WEB UI search result shows two status for one status.
A lead document's status was automatically changed from "Open" to "Returned" using program. Then the status was changed to "Lost". So the active status of the document in the table should be "Lost". But the table shows both the Returned and Lost are active. Also if i the search the document in WEB UI, the status in the Reslt shows "Returned Lost".
How is this possible and how to rectify the same? Request your inputs.