<div dir="ltr">Hi Gustav, thank you very much for your answer.<div><br></div><div>I tried your solution and added this code to my objectSynchronization/condition node:</div><div><br></div><div><div><i> shadowUid = basic.getIdentifierValue(shadow);</i></div><div><i> userInMPQuery = QueryBuilder.queryFor(UserType.class, midpoint.getPrismContext())</i></div><div><i> .item(UserType.F_NAME).eq(shadowUid)</i></div><div><i> .build();</i></div><div><i> userInMP = midpoint.searchObjects(UserType.class, userInMPQuery);</i></div><div><i> isInMP = userInMP?.size()>0 ? true : false;</i><br></div><div><br></div></div><div>I'm getting the following error:</div><div><br></div><div><div><i>Caused by: java.lang.IllegalArgumentException: Operation result must not be null.</i></div><div><i> at org.apache.commons.lang.Validate.notNull(Validate.java:192) ~[commons-lang-2.6.jar:2.6]</i></div><div><i> at com.evolveum.midpoint.model.impl.controller.ModelController.searchObjects(ModelController.java:743) [model-impl-3.4.jar:na]</i></div><div><i> at com.evolveum.midpoint.model.impl.expr.MidpointFunctionsImpl.searchObjects(MidpointFunctionsImpl.java:912) ~[model-impl-3.4.jar:na]</i></div><div><i> at com.evolveum.midpoint.model.api.expr.MidpointFunctions$searchObjects.call(Unknown Source) ~[na:na]</i></div><div><i> at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) ~[groovy-all-2.4.0.jar:2.4.0]</i></div><div><i> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) ~[groovy-all-2.4.0.jar:2.4.0]</i></div><div><i> at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128) ~[groovy-all-2.4.0.jar:2.4.0]</i></div><div><i> at Script33.run(Script33.groovy:19) ~[na:na]</i></div><div><i> at org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.eval(GroovyScriptEngineImpl.java:344) ~[groovy-all-2.4.0.jar:2.4.0]</i></div><div><i> ... 108 common frames omitted</i></div></div><div><br></div><div>And this is the query that's allocated in '<i>userInMPQuery'</i>:</div><div><i><br></i></div><div><div style="font-style:italic">2016-10-24 17:07:59,075 [] [http-bio-8080-exec-3] ERROR (com.evolveum.midpoint.expression): Query debug: Filter:</div><div style="font-style:italic"> EQUAL:</div><div style="font-style:italic"> PATH: name</div><div style="font-style:italic"> DEF: PPD:{.../common/common-3}name {<a href="http://prism.evolveum.com/xml/ns/public/types-3}PolyStringType[0,1],RAM">http://prism.evolveum.com/xml/ns/public/types-3}PolyStringType[0,1],RAM</a></div><div style="font-style:italic"> VALUE:</div><div style="font-style:italic"> userName</div><div style="font-style:italic">Paging: null</div><div style="font-style:italic"><br></div><div>Any ideas what this could be? I couldn't find a reason for this behaviour. Thanks in advance.</div><div><br></div><div>Regards</div><div style="font-style:italic"><br></div></div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-10-24 14:32 GMT-03:00 Pálos Gustáv <span dir="ltr"><<a href="mailto:gustav.palos@evolveum.com" target="_blank">gustav.palos@evolveum.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Ana,<div><br></div><div>I'm using for similar use case this condition in objectSynchronization:</div><div><br></div><div><div> <condition></div><div> <script></div><div> <code></div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> <span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>import com.evolveum.midpoint.xml.ns._<wbr>public.common.common_3.<wbr>UserType;</div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> <span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>import com.evolveum.midpoint.prism.<wbr>query.builder.QueryBuilder;</div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> <span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>import com.evolveum.midpoint.prism.<wbr>path.ItemPath;</div><div><br></div><div> STATUSS = basic.getAttributeValue(<wbr>shadow, 'STATUSS')<br></div><div><br></div><div> toImport = STATUSS == '01'</div><div><br></div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>// find user in MP, if exists syncronize it also </div><div> <a href="http://log.info" target="_blank">log.info</a>('shadow {}', shadow.asPrismObject().<wbr>debugDump())</div><div> activation = shadow.getActivation()</div><div> shadowUid = basic.getIdentifierValue(<wbr>shadow);</div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> userInMPQuery = QueryBuilder.queryFor(<wbr>UserType.class, midpoint.getPrismContext()).<wbr>item(UserType.F_EMPLOYEE_<wbr>NUMBER).eq(shadowUid).and().<wbr>item(UserType.F_EMPLOYEE_TYPE)<wbr>.eq("pavs").build()<br></div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> userInMP = midpoint.searchObjects(<wbr>UserType, userInMPQuery);<br></div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> isInMP = userInMP?.size()>0 ? true : false;<br></div><div><span class="m_5888580784213668121gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> <a href="http://log.info" target="_blank">log.info</a>('isInMP: '+isInMP);</div><div><br></div><div><br></div><div> toImport = isInMP || toImport;</div><div><br></div><div> return toImport;</div><div> </code></div><div> </script></div><div> </condition></div></div><div><br></div><div>In my case I need to have status=='01' (enabled), or already imported (variable isInMP)</div><div><br></div><div>Gustav</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">2016-10-24 19:21 GMT+02:00 Ana Pereyra <span dir="ltr"><<a href="mailto:apereyra@identicum.com" target="_blank">apereyra@identicum.com</a>></span>:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Hi everybody.<div><br></div><div>I have the following issue: I need to import users from two different database table resources. The problem is that I don't want to create in mipoint every user in the tables, I will create a user in midpoint only if the database field value that sets the validTo date attribute is lower than the current date.</div><div><br></div><div>But that's for the creation only, if the user already exists in midpoint, I want to link the account to that user, no matter if the validTo date is lower than the current date or not (because maybe I have to update the validTo date to disable the user).</div><div><br></div><div>I think I'll need some way to check if the user already exists in the synchronization/objectSynchron<wbr>ization/condition. Can anyone help me with this? Is this possible?</div><div>Thank you very much.</div><div><br></div><div>Regards</div><span class="m_5888580784213668121HOEnZb"><font color="#888888"><div><div><br></div>-- <br><div class="m_5888580784213668121m_-8080606788874628673gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><b style="font-size:12.8px">Ana Pereyra</b><br></div><div dir="ltr"><font face="verdana, sans-serif" style="font-size:12.8px"><img> Identicum S.A.<br><i><font color="#666666">Jorge Newbery 3226, Argentina<br>Tel: +54 (11) </font></i></font><font color="#666666" face="verdana, sans-serif" style="font-size:12.8px"><i>4552.3050</i></font><div style="font-size:12.8px"><font face="verdana, sans-serif"><i><font size="1"><a href="mailto:apereyra@identicum.com" style="color:rgb(17,85,204)" target="_blank">apereyra@identicum.com</a></font></i><br><a href="http://www.identicum.com/" style="color:rgb(17,85,204)" target="_blank"><font color="#000000">www.identicum.com</font></a></font></div></div></div></div></div></div></div></div></div></div></div>
</div></font></span></div>
<br></div></div>______________________________<wbr>_________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mail<wbr>man/listinfo/midpoint</a><br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div class="m_5888580784213668121gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div>Gustáv Pálos</div><div>Identity Engineer</div><a href="http://evolveum.com/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">evolveum.com</a><br></div></div>
</font></span></div>
<br>______________________________<wbr>_________________<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/<wbr>mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><b style="font-size:12.8px">Ana Pereyra</b><br></div><div dir="ltr"><font face="verdana, sans-serif" style="font-size:12.8px"><img src="http://www.identicum.com/img/favicon.ico"> Identicum S.A.<br><i><font color="#666666">Jorge Newbery 3226, Argentina<br>Tel: +54 (11) </font></i></font><font color="#666666" face="verdana, sans-serif" style="font-size:12.8px"><i>4552.3050</i></font><div style="font-size:12.8px"><font face="verdana, sans-serif"><i><font size="1"><a href="mailto:apereyra@identicum.com" style="color:rgb(17,85,204)" target="_blank">apereyra@identicum.com</a></font></i><br><a href="http://www.identicum.com/" style="color:rgb(17,85,204)" target="_blank"><font color="#000000">www.identicum.com</font></a></font></div></div></div></div></div></div></div></div></div></div></div>
</div>