Define Query to Delete SBO
Hello All
I have created a SBO query to delete the changed rows
Example:
1:user created a row Value1 = 12345, this Value1 is part of Component Search key so we have indexed it and pushed to ES server (Full Index).
2:user deleted or changed the Value1 to 99999 , so SBO query is written to check whether any row is updated or deleted from Audit table and ran the PTSF_GENFEED (Incremental index).
Now Value1 is deleted from ES Server but the new updated Value which is 99999 is not updated in ES Server.
How to achieve this ? And Whether SBO runs first before it push the incremental index ?