Hello
I am using jdbc_static filter in Logstash for my mariaDB data . where I have define 2 local_lookups. Can I access data in my 2nd lookup using 1st lookup result fields ????????????????
local_lookups => [ {
id => "inventory-lookup-one"
query => "SELECT ip,ChainId from inventory WHERE ip = :ip "
parameters => {
ip => "[tag][ip]"
}
target => "server"
}
, {
id => "inventory-lookup-second"
query => "SELECT rowId,mac,ChainId from inventory WHERE rowId = :index AND ChainId = :chain_id "
parameters => {
index => "[tag][index]"
chain_id => "[server][ChainId]"
}
target => "server_2"
}
]
I have tried chain_id => "[server][0][ChainId]" Also
ERROR
lookup - Parameter field not found in event
Thanks