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
Ad-hoc queries on entities
entity
AdvancedQuery
SQL
Community
›
Forums
›
Technology & Integration
Ad-hoc queries on entities
entity
AdvancedQuery
SQL
New Post
New Post
George LeBlanc
Posted on 2014-04-10
George LeBlanc
Rank: #11488
Posted on 2014-04-10
I am trying to create a web service in OS that basically returns all of my entity data to the caller. In order to do that dynamically, are there ways for me to:
1) get a list of entities in my eSpace?
2) iterate over that list and dynamically create queries that select all of the records for each entity in the list?
At this point, i can get the data back if i manually configure the web service to query each table in my eSpace, by creating a separate query for each one.
Just to clarify why i even want to do this, we have an offline reporting system that needs csv files as input. So i have a Java program that calls the web service and creates a file for each of the entities returned. I use CSV extension to format the data before sending. It works fine, but i want a solution that doesnt have to be different for each espace where it is used.
Curt Raddatz
Posted on 2014-04-11
Curt Raddatz
Rank: #97
Posted on 2014-04-11
Solution
The Record Introspect component (
http://www.outsystems.com/forge/component/484/record-introspect
) will probably have the logic you need to do this.
Solution
George LeBlanc
Posted on 2014-04-11
George LeBlanc
Rank: #11488
Posted on 2014-04-11
Solution
Curt,
Thanks for the pointer. I will check it out tomorrow.
George
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...