I have a table with rides information It has many columns like pick up, drop-off, passengers, driver, amount e.t.c I am using API to get filtered data, as

Hello @Siddharth! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.

But Id is working, returns data of specific Id but dropoff or any other search value not working

Thread was archived by @Siddharth. Anyone can send a message to unarchive it.

As u can see in yellow background api not working and gives a error below, Again in first image when Id is used it sents filtered row, I have attached my tables columns with its data and type, Thanks

Look at the case of the column name, we suggest you to use snake_case always because other cases have issue when using Postgres unless you wrap them with quotes. But your query is using the wrong case for your column name.