search

simov / express-admin

MySQL, MariaDB, PostgreSQL, SQLite admin for Node.js
MIT License
1.17k stars 222 forks source link

Incorrect query is built when primary key is not integer #111

Open piyushsf opened 8 years ago

piyushsf commented 8 years ago

I tried implementing search functionality by adding listview by following link: https://github.com/simov/express-admin-examples/blob/master/config/mysql/settings.json#L145-L156

But, the query build is incorrect by the framework as it does not add ""(quotes) over the value of primary key. for example, in the where condition of query I get sender_id=o45d45fe445erwt45 without quotes. e I I am not using integer type for primary key but varchar(32). I tried fixing it but not sure which file is relevant. Any help would be appreciated.

stanzahk commented 6 years ago

Hi, i'm experiencing this too.

Any change to get this bug fixed?

Thanks