<div dir="ltr">I have ours setup the same way, we have a live sync task for a database table and then I also have a recon task for that same resource that runs nightly to handle the deleted situation.<div><br></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr">JASON</div></div></div>
<br><div class="gmail_quote">On Mon, May 9, 2016 at 7:50 AM, Ivan Noris <span dir="ltr"><<a href="mailto:ivan.noris@evolveum.com" target="_blank">ivan.noris@evolveum.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
There is nothing wrong in deleting the row from the table. The
situation will be evaluated as DELETED, but not for LiveSync +
DBTable connector. You will need reconciliation task for that.<br>
<br>
In my case I have setup livesync for (OpenLDAP) resource to detect
new and updates accounts, and a daily reconciliation task to
evaluate DELETED situation.<br>
<br>
As the DBTable connector fetches changes by doing SELECT and
searching for any record newer/changed after specific time, it will
not get any deleted ones.<br>
<br>
The other way of doing this is not using DELETED situation at all,
instead mark the rows as "deleted" by some column/attribute, and
process this as update from the account. In the inbound expression
of that resource or in template you can do anything you want. For
example the activation/administrativeStatus attribute can reflect
this.. or you can pass the information to some (e.g. extension) user
attribute in midPoint and object template can assign the roles
according to that...<br>
<br>
Regards,<br>
Ivan<div><div class="h5"><br>
<br>
<div>On 05/09/2016 02:37 PM, Marco Benucci
(Consulente) wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div>
<p class="MsoNormal"><span lang="EN-US">Ahhh...<br>
didn’t see this in the documentation, I suppose...<br>
<br>
I completely remove the row from the table, and this is not
the correct way to use it, am I wrong?<br>
<br>
How should I detect a deleted account in the correct way?<u></u><u></u></span></p>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><span class=""><pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</span></blockquote><span class="">
<br>
<pre cols="72">--
Ing. Ivan Noris
Senior Identity Management Engineer & IDM Architect
<a href="http://evolveum.com" target="_blank">evolveum.com</a> <a href="http://evolveum.com/blog/" target="_blank">evolveum.com/blog/</a>
___________________________________________________
"Semper ID(e)M Vix."
</pre>
</span></div>
<br>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br></div></div>
<br>
<font size="2"><br><br>CONFIDENTIALITY NOTICE:<br>This e-mail together with any attachments is proprietary and confidential; intended for only the recipient(s) named above and may contain information that is privileged. You should not retain, copy or use this e-mail or any attachments for any purpose, or disclose all or any part of the contents to any person. Any views or opinions expressed in this e-mail are those of the author and do not represent those of the Baptist School of Health Professions. If you have received this e-mail in error, or are not the named recipient(s), you are hereby notified that any review, dissemination, distribution or copying of this communication is prohibited by the sender and to do so might constitute a violation of the Electronic Communications Privacy Act, 18 U.S.C. section 2510-2521. Please immediately notify the sender and delete this e-mail and any attachments from your computer. </font><br>