Clarity Service Management

Expand all | Collapse all

Sorting data over LREL

Jump to Best Answer
  • 1.  Sorting data over LREL

    Posted 03-16-2016 03:24 AM

    Hello team,

    I have two factories (tableA, tableB) linked over LREL (which is stored in tableAB) and I'm looking a way to perform sorting tableAB by tableB.sequence attribute,

    sorting should work in SPEL too, that's the reason why I'm peeking so deep instead of using list sorting parameters in web forms.

     

    Looking for the same structure OOTB tables I have found Group Member table (grpmem) where sorting defined as:

    STANDARD_LISTS {

                SORT_BY "member=member.last_name";

    }

     

    But when I'm defining same condition, system crashing with FATAL error:

    6583 Unable to resolve dotted reference tableB.sequence in factory tableAB: top_ob is undefined.

     

    Seems that table should be defined in top object or I should publish sorting as domset, any ideas on this?

     

    Regards,

    Timur



  • 2.  Re: Sorting data over LREL

    Posted 03-21-2016 03:57 AM

    Hi cdtg,

     

    Maybe stupid question but do your tableAB contain an SREL back to tableB?

     

    I also see that the domset for grpmem contains:

      auto_assign STATIC

        List Cols: member

        Sort Cols: group

      STATIC_DISTINCT STATIC

      MLIST_DYNAMIC DYNAMIC

      RLIST_DYNAMIC DYNAMIC

      MLIST_STATIC STATIC

      RLIST_STATIC STATIC

     

    /J



  • 3.  Re: Sorting data over LREL

    Posted 03-21-2016 04:15 AM

    Sure, otherwise, how would I store the data?

    I have applied workaround solution:

    • published sequence attr in LREL table;
    • filling that sequence with value from tableB;


  • 4.  Re: Sorting data over LREL

    Posted 03-21-2016 04:32 AM

    Yep

    Interesting but must be a way to do without.

    Will try too when I get my hand on a dev env.

    /J



  • 5.  Re: Sorting data over LREL

    Posted 03-21-2016 04:52 AM

    I think that solution is in correct domset usage but I can't achieve it.

    Ways I tried:

    - sorting via STANDARD_LIST - gives error described in topic start;

    - via .mod file - gives error that factory is not registered (regular thing for custom factories);

    - manually created (via dbload) row in wspdomsets table with custom name - sync_fetch over custom domset can't build correct list;

    - created (via WSP) row in wspdomsets table with MLIST_STATIC - sync_fetch gives unsorted result.



  • 6.  Re: Sorting data over LREL
    Best Answer

    Posted 03-21-2016 05:42 AM

    Got it!

     

    Have created sla_rule_domset.maj with followed text:

    OBJECT z_sla_rules {
      FACTORY {
      DOMSET SEQUENCE_ORDER "sla_rule=sla_rule.sequence" "" DYNAMIC;
      };
    };
    

     

    Confirmed with bop_sinfo -l z_sla_rule, thanks TMACUL for SPEL LANGUAGE (domset's) 13/10/2015

     

    Used domset in sync fetch:

    send_wait(0, top_object(), "call_attr", "z_sla_rules", "sync_fetch", "SEQUENCE_ORDER", format("sla_pack = %d", pack_id),  -1, 0);
    


  • 7.  Re: Sorting data over LREL

    Posted 03-21-2016 05:53 AM

    Glad that you make it working this way.

    /J



  • 8.  Re: Sorting data over LREL

    Posted 03-21-2016 10:23 AM

    HI Timur,

     

    Great! It's aggrandizing to help.

     

    Was publish initially by Daniel Bighelini - 2015-10-13 16:06

    From: CA SDM Brasil - Facebook

     

    Regards