False negative in test case assertion comparison

[daviddavila_12451 (David Davila)]

I am experiencing a false negative in my automated test results.
You can review the execution here:
[Test Report Link] (Apidog)

In the 4th test case (Get List Reward Coupon With Filters), both the database query and the API response return a value of 0.
However, the test result fails with the following message:

AssertionError: expected ‘0’ to deeply equal ‘1’

Expected Behavior:

If both the count from the database query and the value from the response ($.pagination.total) are 0, the assertion should pass.

Actual Behavior:

The test incorrectly fails and displays a mismatch, even though both values are 0.

Attachments:

Screenshots showing:

• Database query returning reward_count = 0
• Response JSON showing “total”: 0
• Assertion configuration ($.pagination.total == {{count_db}})
  
  
  
  
  
  
  
  
  
  
  

[Apidog Support]

Hello, the report link you shared can only be viewed by your team members. Could you please provide screenshots showing the details of the steps? Specifically, we’d like to check how the count_db variable expression is written in the database step to confirm if it’s correctly configured.

[daviddavila_12451 (David Davila)]

[Apidog Support]

To help diagnose the issue, could you add the following to your post-request script and check the console output?

console.log("env=", pm.environment.get("count_db"));
console.log("variables=", pm.variables.get("count_db"));

This will confirm if there are any conflicting variable values.

[daviddavila_12451 (David Davila)]

Now I cannot replciate the error… I f I had any other issue I will let you know