How to exclude specific option from all option in dynamic drop-down?

[juvenile]

<input id="select_abc" type="multiselect" token="token_abc" searchWhenChanged="true">
    <label>ABC&#8205;</label>

    <default>*</default>

    <prefix>(</prefix>
    <suffix>)</suffix>
    <valuePrefix>"</valuePrefix>
    <valueSuffix>"</valueSuffix>

    <choice value="*">All</choice>
    <search base="base_search">
        <query>
            | stats count as count by some_field
            | sort 0 - count
        </query>
    </search>
    <fieldForLabel>some_field</fieldForLabel>
    <fieldForValue>some_field</fieldForValue>

    <delimiter>,</delimiter>

    <change>
        <condition label="All">
            <set token="token_abc">("*") AND some_field != "SomeArbitraryStringValue"</set>
        </condition>
    </change>
</input>

I was wondering how I can exclude a specific option from the asterisk (*) value of the "All" option? Also, how does it work with parantheses and also exlcuding it from the default value?

Thank you

[gcusello]

Hi @juvenile ,

create a more complicated value for All, e.g. if you want to exclude events with some_field="xxx":

<input id="select_abc" type="multiselect" token="token_abc" searchWhenChanged="true">
    <label>ABC&#8205;</label>

    <default>*</default>
    <prefix>(</prefix>
    <suffix>)</suffix>
    <choice value=* AND NOT some_field="SomeArbitraryStringValue">All</choice>
    <search base="base_search">
        <query>
            | stats count as count by some_field
            | sort 0 - count
        </query>
    </search>
    <fieldForLabel>some_field</fieldForLabel>
    <fieldForValue>some_field</fieldForValue>
</input>

Please adapt this solution to your requirements.

Ciao.

Giuseppe

[juvenile]

Hi @gcusello , thank you for your answer. What about the default value?

[gcusello]

Hi @juvenile ,

as you like: the same of All or one of the dinamic values.

Ciao.

Giuseppe