Can I access data in my 2nd lookup using 1st lookup result using jdbc_static filter in Logstash for my mariaDB data

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

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.