[midPoint] Midpoint DBTablesConnector OrderBy attribute

[Dilek Gider]

Hi All,

Is there any OrderBy attribute in databasetable connector?
(org.identityconnectors.databasetable.DatabaseTableConnector 1.4.2.0)

I couldn't find it. I am creating organizations that are linked to each
other, top organization and its childs. But from the sql resultset, some
childs are coming to midpoint before their parent, and they are not linked.

I link them with org template , it is below:

   <name>Org Template</name>
   <metadata>
      <createTimestamp>2017-02-03T15:42:39.640+02:00</createTimestamp>
      <creatorRef oid="00000000-0000-0000-0000-000000000002"
type="c:UserType"><!-- administrator --></creatorRef>
      <createChannel>
http://midpoint.evolveum.com/xml/ns/public/model/channels-3#objectImport
</createChannel>
   </metadata>
   <mapping>
      <name>Link org parent</name>
      <strength>strong</strength>
      <source>
         <c:path>$focus/costCenter</c:path>
      </source>
      <expression>
         <assignmentTargetSearch>
            <targetType>c:OrgType</targetType>
            <filter>
               <q:equal>
                  <q:matching>polyStringNorm</q:matching>
                  <q:path>c:name</q:path>
                  <expression>
                     <c:path>$costCenter</c:path>
                  </expression>
               </q:equal>
            </filter>
         </assignmentTargetSearch>
      </expression>
      <target>
         <c:path>assignment</c:path>
      </target>
      <condition>
         <script>
            <code>costCenter != null</code>
         </script>
      </condition>
   </mapping>
</objectTemplate>

I set parent organiation's identifer for each record as costCenter
attribute. There exists four times hierarchy. Is there any idea to do this?

---Organization ABC
                   ----- Org X
                           ------ Dept Y
                                    -------- Dept J
                    ----- Org M
                            ------ Dept Z
                    ----- Org H
                            ------ Dept G
                            ------ Dept T
                                     ------ Dept F
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170504/384f06ae/attachment.htm>