How to pass more than one column as search terms in Gate Module table drill down - Sideview Utils

[pradeepkumarg]

I have a SimpleResultsTable with the below query in my Advancedxml

index=myindex sourcetype=mysourcetype | search FILE_ID="xyz" | table fieldA, fieldB, fieldC, fieldD, fieldE, fieldF

Im using a gate module to drill down to a different table on selecting a row. Below is my drilldown query on gate target module

index=myindex sourcetype=mysourcetype $row.searchTerms$ | search FILE_ID="xyz" | table fieldG, fieldH, fieldI, fieldJ

Now the $row.searchTerms$ gets only fieldA, how can I pass fieldB & fieldC along with fieldA ?

[martin_mueller · Accepted solution]

You should be able to access those field values through $row.fields.fieldB$, $row.fields.fieldC$, etc.

Have you considered using Sideview's Table module rather than the SimpleResultsTable module?

[pradeepkumarg]

$click.fields.fieldB$ worked for SimpleResultsTable. Thanks again!

[martin_mueller]

That's possible, it's been too long though since I used SimpleResultsTable... just try it out 😛

[pradeepkumarg]

Thanks Martin, Will I be able to use $row.fields.fieldB$, $row.fields.fieldC$ only through Sideview's Table module?