Can't use 'greater than' or 'less than' operators with big int fields in the Database Query Manager

Wappler Version : 5.0.2
Operating System : MacOS Monterey - M1
Server Model: NodeJS
Database Type: Postgres
Hosting Type: Own Server

Expected behavior

I have tables with bigIncrement id fields, if I’m looking for records created after a specific record, should be able to query the database for values greater than that record’s id.

Actual behavior

However, I’m only presented with string operators in the query manager.

Screen Shot 2022-08-25 at 4.08.00 PM
Screen Shot 2022-08-25 at 4.08.00 PM1562×902 128 KB

I believe this is because with NodeJS, the database driver converts the BigInt to a string, so it is currently set up to only use string operators.

Community Page
Last updated: