Hi,
I am trying to build a dashboard with 4 MultiValue Input fields.
MV_field1 with Values MVF1_A, MVF1_B,..... MVF1_N (so on)
MV_field2 with Values MVF2_A,MVF2_B,......MVF2_N
MV_field3 with Values MVF3_A,MVF3_B,......MVF3_N
MV_field4 with Values MVF4_A,MVF4_B,......MVF4_N
MV_field2 values depend on MV_field1, MV_field3 depends on MV_field2 and so on..
The data is coming from a lookup and the field values are populating for MV_field1 based on this search
| inputlookup mylookup.csv
| fields "fieldA"
| dedup fieldA
MV_field2 values are dynamically getting populated by using below search, based on the values I chose from first multivalue input list
| inputlookup mylookup.csv
| search "fieldA" IN ($fieldA$)
| dedup fieldB
| fields "fieldB"
However, when I select multiple values in MV_field2 along with MV_field1, my third MV_field3 list doest get populated. It gets stuck with message, "Could not create Search." and mouse over shows the message, "Search is waiting for input"
The search I am using to populate the third input is as below:
| inputlookup mylookup.csv
| search ("fieldA" IN ($fieldA$)) AND (fieldB IN $fieldB$)
| fields fieldC
| dedup fieldC
Any pointers would be greatly appreciated.
... View more
