<div dir="ltr"><div dir="ltr"><div>If I'm understanding correctly, you want to create a resource with multiple projections, and each projection would result in a roleAssignment.</div><div><br></div><div>Unfortunately that's not how resources in midPoint work. You can have multiple projections of the same objectType but only with multiple intents.</div><div><a href="https://wiki.evolveum.com/display/midPoint/Focus+and+Projections">https://wiki.evolveum.com/display/midPoint/Focus+and+Projections</a></div><div>If you try to import multiple projections to the same focus object, only one will be linked, the other will stay unlinked (i guess? maybe unmatched?)</div><div><br></div><div>You should struct your table/view like this:</div><div><br></div><div>USER ROLES LASTUPDATE</div><div>test student,employee datetime</div><div>test2 student datetime</div><div><br></div><div>There should be only one line per user. Then you would need to write a script to interpret the ROLES column, splitting it and searching for the roles.<br></div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em qua, 10 de abr de 2019 às 12:14, Justin Stanczak <<a href="mailto:rizenine@gmail.com">rizenine@gmail.com</a>> escreveu:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div>Here's the exact schemaHandling I'm using. So no on tolerant and not condition set. </div><div><br></div><div><i><schemaHandling></i></div><div><i> <objectType id="169"></i></div><div><i> <kind>account</kind></i></div><div><i> <default>true</default></i></div><div><i> <objectClass>ri:AccountObjectClass</objectClass></i></div><div><i> <attribute id="402"></i></div><div><i> <c:ref>ri:ROLE</c:ref></i></div><div><i> <tolerant>true</tolerant></i></div><div><i> <exclusiveStrong>false</exclusiveStrong></i></div><div><i> <inbound id="435"></i></div><div><i> <authoritative>false</authoritative></i></div><div><i> <exclusive>false</exclusive></i></div><div><i> <strength>normal</strength></i></div><div><i> <expression></i></div><div><i> <assignmentTargetSearch xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a>" xsi:type="c:AssignmentTargetSearchExpressionEvaluatorType"></i></div><div><i> <targetType>c:RoleType</targetType></i></div><div><i> <oid>afb77728-38c8-4f66-9668-b594c992cad2</oid></i></div><div><i> </assignmentTargetSearch></i></div><div><i> </expression></i></div><div><i> <target></i></div><div><i> <c:path>assignment</c:path></i></div><div><i> </target></i></div><div><i> </inbound></i></div><div><i> </attribute></i></div><div><i> </objectType></i></div><div><i> </schemaHandling></i></div><div><br></div><div><br></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 10, 2019 at 10:40 AM Jason Everling <<a href="mailto:jeverling@bshp.edu" target="_blank">jeverling@bshp.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr">You do not have any <tolerant>false</tolerant> anywhere right? Do you have the condition set? if so, with what?</div><div dir="ltr"><br></div><div dir="ltr"><div><div dir="ltr" class="gmail-m_7954327897093017788gmail-m_-7437061333218483359gmail_signature"><div dir="ltr"><br></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 10, 2019 at 9:24 AM Justin Stanczak <<a href="mailto:rizenine@gmail.com" target="_blank">rizenine@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div dir="ltr">Maybe an example not of my own making would help. </div><div dir="ltr"><br></div><div dir="ltr"><i><a href="https://raw.githubusercontent.com/Evolveum/midpoint/1c1975fa450bbee741314c2822c5715ebf68f6b2/samples/hogwarts/objects/resources/resource-csv.xml" target="_blank">https://raw.githubusercontent.com/Evolveum/midpoint/1c1975fa450bbee741314c2822c5715ebf68f6b2/samples/hogwarts/objects/resources/resource-csv.xml</a></i></div><div dir="ltr"><i><br></i></div><div dir="ltr"><div dir="ltr"><i><<b>inbound</b>></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span><expression></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span><assignmentTargetSearch></i></div><div dir="ltr"><i><targetType>c:RoleType</targetType></i></div><div dir="ltr"><i><oid>e2c88fea-db21-11e5-80ba-d7b2f1155264</oid></i></div><div dir="ltr"><i></assignmentTargetSearch> <span style="white-space:pre-wrap"> </span></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span></expression></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span><target></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span><path><b>assignment</b></path></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span><set>....</set></i></div><div dir="ltr"><i><span style="white-space:pre-wrap"> </span></target></i></div><div dir="ltr"><i></<b>inbound</b>></i></div><div dir="ltr"><br></div><div>If you scroll to the above section you'll find the inbound role assignment. This is basically what I'm trying to do but my resource is a database table. However, using this example just replaces all other assignments for that account and sets this one. That can't be how this example was intended to work? Where am I going wrong? </div><div><br></div><div>Thanks.</div><div>Justin Stanczak</div><div><br></div></div></div></div>_______________________________________________<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/mailman/listinfo/midpoint</a><br>
</blockquote></div>_______________________________________________<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/mailman/listinfo/midpoint</a><br>
</blockquote></div></div>
_______________________________________________<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/mailman/listinfo/midpoint</a><br>
</blockquote></div>