60
Views
8
Comments
Same input but difference result between run test outsystem and UI
Question

Hi every body i have an issue

with same inputs but when set to params and run test SQL advance query in outsystem return result difference  when input UI and debug

SQL

1. Test outsystem

---------------------------------------

2. Debug with value input UI

Result

Some body have occur problem like me?

Please explain it for me thanks

mvp_badge
MVP
Rank: #5

Hello,

1. Are you really sure you are passing the same value in the parameter that you used in the test? I ask because it seems  you are showing a value after the query in the code, and we can't be sure this is the value passed to the query.

2. Is the query connected to a table/list records in screen that has a line count set to 2?

3. Is this a multitenant app?

(can't see the images right because I'm on phone, sorry)

Cheers

mvp_badge
MVP
Rank: #5

P.S. You should use an aggregate for this query.

mvp_badge
MVP
Rank: #5

The line count property will limit the number of lines fetched by the aggregate/sql.

Rank: #14954

Hi,

This probably caused by number of max records in your SQL.
Make sure 'max records' is empty to get all records.

If it has any value (for example : 2), and the actual records are 10, then it will return 2 records only.

Good luck!

mvp_badge
MVP
Rank: #2

Hi Tung,

The best advise I can give is to create a new screen by dragging the User Entity onto the Flow canvas. The auto-schaffolding intelliwizzard will create pagination for you, so you can check how it's done.