isin - from several parameters

I have a query like:

category in $L.file isin $G.list1

How can i set query for several global lists

something like category in $L.file isin {$G.list, $G.list2} - this is to understand my idea (this query not work)

i just hope to make shoter line for this query.

  • Hello,

    why not to use or?

    category in $L.file isin $G.list1  or category in $L.file isin $G.list2 .......

  • Because there is a significant restriction on the length of symbols in the condition field of the table slo.

    That why i used GlobalList variable wich contain several assignments groups and one more GlobalList with list of incident category.

     

    perhaps it is necessary to use a concatenation of two or more global lists in a new one.

  • Because there is a significant restriction on the length of symbols in the condition field of the table slo.

    That why i used GlobalList variable wich contain several assignments groups and one more GlobalList with list of incident category.

     

    perhaps it is necessary to use a concatenation of two or more global lists in a new one.

  • Or may be there is any other method to separate slo for assignments groups.

  • Or may be there is any other method to separate slo for assignments groups.

  • I'm not 100% sure I understood your issue correctly, but you could create a JS script, which purpose is only to return an array off searchable items.

    For example, I've a report with a following kind of query:

    orig.date.entered>=(tod()-'365 00:00:00') and location isin jscall("myCode.getLocations")

    JSCall section calls JS script, which purpose is to select certain locations and return an array of searchable location items to the query. Maybe this approach works for you? It should also remove the need of globallists, if you have no other purpose for them?

  • Intresting idea but i don't see any difference JS and GL

    in my case SLO based on assignment group wich selected in Incident (IM) and assignment group will not be reassigned..

    Using a global list I decrease number of characters for condition filed in SLO

    For example:

    several assignments groups stored in one GL if this groups have same SLO

    (so was: "Support team 1", "Engineer team 1", "Support team 2", "Support team 3" and became: $G.groupslo1)

    and same for category list.

  • You could implement a whole business logic in JS, not only the part that replaces globallists.

    I haven't tested how it behaves when dealing with SLO, but the JS script can return either false or true depending of your business logic. In your SLO expression, you only need a call like

    jscall("myCode.SLOLogic")

    and the expression will be evaluated true/false as well.

    Yes, I'm not sure if that solves anything in your case, but just wanted to rephrase my example. It wasn't just about replacing globallists, but moreover guiding to transfer business logic to JS.

  • it only remains to know whether the call of Javascript from the condition field of the SLO