Uploaded image for project: 'MidPoint'
  1. MidPoint
  2. MID-4537

UI table lists use m_object.name_orig

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.8
    • Component/s: Repository
    • Labels:
      None

      Description

      E.g. role list:

       select rrole0_.oid as col_0_0_, rrole0_3_.fullObject as col_1_0_, rrole0_3_.stringsCount as col_2_0_, rrole0_3_.longsCount as col_3_0_, rrole0_3_.datesCount as col_4_0_, rrole0_3_.referencesCount as col_5_0_, rrole0_3_.polysCount as col_6_0_, rrole0_3_.booleansCount as col_7_0_ 
       from m_role rrole0_ 
       inner join m_abstract_role rrole0_1_ on rrole0_.oid=rrole0_1_.oid
       inner join m_focus rrole0_2_ on rrole0_.oid=rrole0_2_.oid
       inner join m_object rrole0_3_ on rrole0_.oid=rrole0_3_.oid 
       order by rrole0_3_.name_orig asc limit 20
      

      switch order by to m_role.name_orig, create necessary indexes. Update query interpreter.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                lazyman Viliam Repan
                Reporter:
                lazyman Viliam Repan
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: