# Can I access data in my 2nd lookup using 1st lookup result using jdbc\_static filter in Logstash for my mariaDB data

**URL:** <https://discuss.elastic.co/t/can-i-access-data-in-my-2nd-lookup-using-1st-lookup-result-using-jdbc-static-filter-in-logstash-for-my-mariadb-data/340977>\
**Category:** Logstash\
**Tags:** jdbc\
**Created:** [August 17, 2023, 7:32am UTC](https://discuss.elastic.co/t/can-i-access-data-in-my-2nd-lookup-using-1st-lookup-result-using-jdbc-static-filter-in-logstash-for-my-mariadb-data/340977 "2023-08-17T07:32:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![aurangzeb99](https://avatars.discourse-cdn.com/v4/letter/a/6bbea6/32.png) [@aurangzeb99](https://discuss.elastic.co/u/aurangzeb99)\
**Post date:** [August 17, 2023, 7:32am UTC](https://discuss.elastic.co/t/can-i-access-data-in-my-2nd-lookup-using-1st-lookup-result-using-jdbc-static-filter-in-logstash-for-my-mariadb-data/340977/1 "2023-08-17T07:32:20Z")

</div>

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 ????????????????

```auto
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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 14, 2023, 7:32am UTC](https://discuss.elastic.co/t/can-i-access-data-in-my-2nd-lookup-using-1st-lookup-result-using-jdbc-static-filter-in-logstash-for-my-mariadb-data/340977/2 "2023-09-14T07:32:52Z")

</div>

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