CA Service Management

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

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

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;

Yep

Interesting but must be a way to do without.

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

/J

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.

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);

Glad that you make it working this way.

/J

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