Platform
Learn
Community
Support
Partner Center
Sign up
or
Log in
logout
Account Settings
Profile
messages
Messages
logout
Logout
Platform
Home
Downloads
IPP
Licensing
Project Sizing
Learn
Training
Documentation
Evaluation Guide
What's New
Community
Home
Forums
Forge
Ideas
Members
Support
Partner Guide
Resources Library
Opportunities
Account Management
Sign up
or
Log in
Home
Forums
Forge
Ideas
Members
Dear ,
What would improve your OutSystems Community experience? Let us know by taking this 2-minute survey.
Pick up the survey
Community
›
Forums
›
Technology & Integration
test query output not same with application output
Community
›
Forums
›
Technology & Integration
test query output not same with application output
New Post
New Post
Diana Mae Benitez
Posted on 2015-03-23
Diana Mae Benitez
Rank: #8161
Posted on 2015-03-23
Hi,
I have this advanced query that fetched data from different joined tables. I used structured entity for the output, whenever I run the test query the output meets the expected result. However when the whole process runs in the application, the queried result weren't the same with the tested advanced query.
Here's the output from test query:
Here's the result from the application:
Note that there's no inialization used in displaying the records only the advanced query, both used the same parameter.
Pedro Coelho
Posted on 2015-03-23
Pedro Coelho
Rank: #64
Posted on 2015-03-23
Solution
Without more concrete details it's hard, my best guess is that the runtime variables used in the query don't have the same values that you expect when executing in test mode. It can also be a bug...
Btw there is a difference (and I'm not sure if this has changed so far) between the runtime sql execution and the sql test execution, being that the runtime is a bit more strick, not sure if that could explain it
Solution
Tiago Neves
mvp_badge
mvp_label
Posted on 2015-03-23
Tiago Neves
mvp_badge
mvp_label
Rank: #75
Posted on 2015-03-23
Solution
Diana,
Are the values different? I can see that until LoanId the result is the same... cannot see more to the right.
Maybe the order of the columns in the screen are just different from the structure order?
Solution
Diana Mae Benitez
Posted on 2015-03-24
Diana Mae Benitez
Rank: #8161
Posted on 2015-03-24
Solution
Hi Pedro and Tiago,
Thanks for your repsonse. Already tried to upgrade the platform server, that might solve this still got the same output. The Output Structured used here are all Identifiers, which was also used in displaying the values in Record List, same with the advanced query. I actually display the values accordingly.
Tiago,
Notice that from the Test Output Remittance_Batch.PaymentId and Remittance_Batch.PaymentDirect have values.
While the runtime sql execution the values produced '0', other columns showed the right values.
Thanks,
Solution
Diana Mae Benitez
Posted on 2015-03-24
Diana Mae Benitez
Rank: #8161
Posted on 2015-03-24
Solution
Hi Guys,
Thanks for your response, this is no longer an issue.
Solution
Tiago Neves
mvp_badge
mvp_label
Posted on 2015-03-25
Tiago Neves
mvp_badge
mvp_label
Rank: #75
Posted on 2015-03-25
Solution
Sometimes, all you have to do is talk about the subject, get other insights and you just magically realize what's the solution. ;)
Solution
Alexei
Posted on 2017-03-10
Alexei
Rank: #4706
Posted on 2017-03-10
Solution
Hi,
What was the issue? maybe you can remember I'm having the same kind of an issue
Solution
Quick Reply
attachment
Choose File
No file chosen
Submit
Login to reply
New Post
Available Forums
Technology & Integration
News and Announcements
Forge Discussions
Meta
Community Quick Guides
Usability
Installation Troubleshooting
Personal Environment Troubleshooting
Forum Notifications
Email Digest Settings
Loading...