Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
1596 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
113779 - no subject - Hello..\n\nWe need to create tempo repor
varshaw
over 10 years ago
Hello..
We need to create tempo report ,which will show the details in grid.
How to fetch details from multiple tables in SAIL expression ?
...
OriginalPostID-113779
Discussion posts and replies are publicly visible
0
abhinavg
over 10 years ago
To fetch details from multiple table create a View as Views can join and simplify multiple tables into a single virtual table.
After that a create a query rule on table view entity and pull the records using single query rule
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
varshaw
over 10 years ago
Thanks Abhinav..
I created view and then datastore for it, but when I when I try to fetch data using query rule it giving empty result.. is there any limitation for view ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
varshaw
over 10 years ago
I was able to fetch data.. Thanks
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
abhinavg
over 10 years ago
Any changes you made .. ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
varshaw
over 10 years ago
Yes.. In datatype XSD @Table annotation was missing
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel