Use `eq` [Jul 02]

:person_tipping_hand: o1lab asked

use eq

:raising_hand_man: Paweł replied

it does not work

`{

“msg”: “select "sheet1"."created_at" as "CreatedAt", "sheet1"."updated_at" as "UpdatedAt", "sheet1"."json" as "json", "sheet1"."status" as "status", "sheet1"."receipt_id" as "receipt_id", "sheet1"."source_system" as "source_system" from "sheet1" where (((("receipt_id" in (select "sheet1_id" from "etsy_payment" where "payment_id" = ‘null’))))) order by "created_at" asc limit 1 - invalid input syntax for integer: "null"”

}`

:raising_hand_man: wkw replied

<@708648416145702952> please create an issue. seems it s not expected. will take a look

:raising_hand_man: Paweł replied

Filtering by null in nested column not possible using API · Issue #2516 · nocodb/nocodb · GitHub

:raising_hand_man: wkw replied

thanks. will investigate

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs