Using 2 RADIOBUTTONS and using them in the query

[abhinav_aashish]

I'm having 3 indexes A(SUPER-SET),  B(SUBSET-1),  C(SUBSET-2).

I'm having 2 radio button groups: Group1 and Group2

Group1 has 2 options: YES and NO

When "YES" is selected then it performs A intersection B and "NO" does not perform any search.

Group2 has 2 options: YES and NO

When "YES" is selected then it performs A intersection C "NO" does not perform any search.

I'm having the following SOURCE CODE for it :

      <input type="radio" token="field1" searchWhenChanged="true">
        <label>Present in AB</label>
        <choice value="Yes">Yes</choice>
        <choice value="No">No</choice>
        <change>
          <condition value="Yes">
            <set token="mysearch">
                index=a   .....................
                | join <common_column> type=outer [| search index= B]
                | where check_column_value="BBBBBBBBBBB"
                | table <list of columns>
            </set>
          </condition>
          <condition value="No">
            <set token="mysearch"></set>
          </condition>
        </change>
      </input>




      <input type="radio" token="field2" searchWhenChanged="true">
        <label>Present in AC</label>
        <choice value="Yes">Yes</choice>
        <choice value="No">No</choice>
        <change>
          <condition value="Yes">
            <set token="mysearch">
                index=a   .....................
                | join <common_column> type=outer [| search index= C]
                | where check_column_value="CCCCCCCCCCCC"
                | table <list of columns>
            </set>
          </condition>
          <condition value="No">
            <set token="mysearch"></set>
          </condition>
        </change>
      </input>




      <table>
        <search>
          <query>$mysearch$</query>
        </search>
      </table>

When i click on YES buttons for the two groups :

When I select both the YES options the result I get is from the index which is last selected as YES option only, i.e. in any case i'm not getting the result from both the sources even after selecting "YES" option.

I feel there is some issue with the token value in the last part of the code shared above.(Not sure!!)

Can anyone help me with this please?

Thanks

[abhinav_aashish]

Thanks man it worked.

Instead of this

<set token="whereB">check_column_value="BBBBBBBBBBB"</set>

I was doing

<set token="whereB">| where check_column_value="BBBBBBBBBBB"</set>

This "| where" thing here was creating issues.

Thanks for the help.

[ITWhisperer]

Please carefully check for any typos / mis-copies of code as this works for me - this is what is generated for me

index=a   .....................
| join common_column type=outer [| search index= B]
| join common_column type=outer [| search index= C]
| where check_column_value="BBBBBBBBBBB" OR check_column_value="CCCCCCCCCCCC"
| table list of columns

[abhinav_aashish]

My code works properly when done without the use of radio buttons and I've applied the same logic.

I'm facing the issue with the use of 2 radio button groups.

Also I wanted the result this way:

Join field

Field match from B

Field match from C

Keep B or C

Keep B and C

A

CCCCCCCCCCCC

Y

N