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.

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.

A custom query may be your quickest way forward.

I have been using them more and more due to various limitations being inadvertently added as a result of the master-child behaviours added some months ago

1 Like

In PostgreSQL bigIncrements results in BigSerial field which eventually is threatened as string and not as number as it is a king of uuid.

So that is why you have the strings operations available only.

1 Like