Skip to Content (Press Enter)
2018-05-16 11-16-36
João Heleno
 
MVP
0Views
6Comments
Query returns different results when testing in s.studio and when it's published
Question
I have a query in my preparation screen that gives me 6 results when I access the page in the browser and 14 results when I test it in service studio.



The search keyword is supposed to be a session variable but right now I'm just passing an empty string...

Can someone shed some thoughts on this?
0
0
20 Apr 2011
Copy Link
2016-04-21 20-09-55
J.
 
MVP
What version of OUTsystems are you using?

Are you by any chance limiting the number of rows on your screen/query ?
When debugging, do you still get 6 results or does the debugger show 14results as well?
What do you fill in as test-input-var? nothing or 2quotes?
If you delete the espace and publish it again, does it happen again?

With the screenshot you have attached is nothing strange, but it's the context that is more interesting :)

Can you provide a skeleton-oml of that particular problem where it happens :)


I vaguely remember it might has to do with multiple tables of your entity (that happens after adding/removing columns on an already  filled table)

1
0
20 Apr 2011
Copy Link
2018-05-16 11-16-36
João Heleno
 
MVP
I'm using a Basic Edition of the Platform Server together with Service Studio 5.1.1.13.

I'm not limiting the number of rows... the debugger shows 14 results.

I'm passing double quotes.

Right now I cannot delete the eSpace nor provide an example oml (sorry)...

I'll have to dig in deeper into this situation...

Thanks Joost.
0
0
20 Apr 2011
Copy Link
2019-08-20 01-57-17
RafaOutSystems
 
MVP
Hi João,

1) The session variable that you've mentioned, its a simple session based on simple data type (Text) or an session based on some structure?
2) Don't you have an "Default value" associated with your session variable?
3) Don't you have any assignment to your session variable before the query execution? 
4) Don't you have any input widget associated with your session variable? 

Regards,
Rafael Pereira
Lisbon Solutions
https://www.lisbonsolutions.pt
1
0
20 Apr 2011
Copy Link
2018-05-16 11-16-36
João Heleno
 
MVP
Actually the session variable's type is record with a structure as rec. definition.

This structure has text, decimals, dates... all with blank 'default value'... in debug the variable in question always showed up blank.
0
0
20 Apr 2011
Copy Link
2019-08-20 01-57-17
RafaOutSystems
 
MVP
Quoting Joost

"Can you provide a skeleton-oml of that particular problem where it happens :)"

Without an sample eSpace it's hard to figure out...even without the same data it's important for troubleshooting. 

Regards,
Rafael Pereira
Lisbon Solutions
https://www.lisbonsolutions.pt
0
0
20 Apr 2011
Copy Link
2020-09-03 07-38-30
Frank Burm
Dear Joao,

Were you able to resolve this issue? I am having the exact same issue. Test results in 76 records, but runtime return only 21.

Kind regards,

Frank Burm
0
0
11 Oct 2011
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.