Query multiple conditionals

[donimos]

Hello,

I'm looking to apply multiple conditionals to the same column. The below example returns all configuration items or uses the second dictionary for name.

What's the best way to combine multiple conditionals for the same dictionary name? I need to combine them:

    query:
      - name: LIKE usfl
        install_status: = 1
      - name: NOT LIKE usga

    query:
      - name: LIKE usfl
        install_status: = 1
        name: NOT LIKE usga

Thank you

[donimos]

@juremedvesek or @tadeboro is anyone monitoring the discussions? where else can we request support for the codebase or documentation?

[tadeboro]

Hi @donimos!

I must admit that I stopped monitoring this repo almost a year and a half ago when I switched jobs. And I forgot most of the implementation details since then, but a quick look through the code seems to suggest that this is not currently possible because YAML documents cannot have duplicated dictionary keys.

To support your use case, the query syntax would need to be extended to support something like this:

    query:
      - name:
          - LIKE usfl
          - NOT LIKE usga
        install_status: = 1

This would result in a raw query similar to nameLIKEusfl^nameNOTLIKEusga^install_status=1 (it has been a while since I last touched ServiceNow, so my query-foo might be a bit rusty).

But I have no control over what is happening with the ServiceNow collection or its direction, so I cannot help much here.