I have created a filter module , but how can i add the filter module into the app table to find the value that i searched for

How to write query for the filter in retool app

You can make a temporary state and set it to the current value of the select input. To do this you have to create an event handler on the select input under interactions. Choose temporary state and select the temporary state you created. After that you’ll have to use {{self.value}} as the value you set.

In your table query you can use the state value as your variable. Something like:
SELECT * FROM table WHERE column=myTemporaryState.value

More info:

You can also try out an example template. They usually have a filter with a table:

Try it out. Then look under the hood.