Case search is incorrect - CRM 8.9 /9.0

While searching for Cases in call center case modules, the users see different search results which are not searched in the criteria.

Solution:
One of the reasons could be the Syncid used on RC_CASE table.
There might be duplicate syncids present in the RC_CASE table.
Though syncid is used in mobile applications, unfortunately call center uses Sync id in the search views also.

In RC_CASE record properties, the system updated field is Syncid and the max(syncid) in the case table is same as PTNEXTSYSTEMID value for RC_CASE in PSSYSTEMID table.

Make sure both are in sync and also write a script to make sure one Syncid is present only for one case in RC_cASE table.