[Filter][Expression Builder] About Evaluating Numeric Conditions.

[HNAKAGAW]

Hello support team

[Environment]

Source : Oracle 19c

Target : Oracle 19c

Qlik Replicate 2026.05

It seems that the Test Expression feature in Expression Builder does not work properly with numeric types.

ID column data type is INT1. (Oracle Datatype is number(1))

1. For $ID==1, the result is false (0) whether ID value is 1 or 0.

2. For $ID=1, the result is false (0) whether ID value is 1 or 0.

* Since I wasn’t sure whether to use “==” or “=” for numeric comparisons, I tried both.

* In both cases, adding spaces before or after the equals sign did not change the result.

I expected that at least one of these two cases would return true (1) when ID value is 1. Am I misunderstanding something?

Best Regards

Nakagawa

[DesmondWOO]

Hi @HNAKAGAW  san,

Using $ID == 1 is correct, you can ignore the failed test result. While adding double quotes (e.g., $ID == "1") allows the test to pass, it will cause the actual comparison logic to fail while the task is running.

Regards,
Desmond

[HNAKAGAW]

Hi Desmond san

Thank you for your reply.

Is the fact that “$ID == 1” isn’t evaluated correctly (the test expression returns false (0) when the ID value is 1) a bug in Replicate?

Best Regards

Nakagawa

[DesmondWOO · Accepted solution]

Hi Nakagawa san @HNAKAGAW,

I searched the user guide but couldn't find this specific limitation documented. I recommend opening a support ticket so we can verify this behavior for you.

Regards,
Desmond

[HNAKAGAW]

Hi Desmond san

Thank you for your reply.

I created a support ticket, and they are currently looking into it.

Best Regards

Nakagawa