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
2 replies
Subscribers
7 subscribers
Views
1267 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
what should be the table name in select query of QueryDatabase smart service ? i
saratrk
over 10 years ago
what should be the table name in select query of QueryDatabase smart service ? is it the entityName or datasource.entity name or datatype name ? please let me know the format...
OriginalPostID-97055
OriginalPostID-97055
Discussion posts and replies are publicly visible
0
Tim Nguyen
Appian Employee
over 10 years ago
SQL query statement used by the Query Database Smart Service will vary according to the database, however the table name should be the table in the database. For more information check out our documentation on the smart service
forum.appian.com/.../Query_Database_Smart_Service
forum.appian.com/.../Query_Database_Tutorial
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saratrk
over 10 years ago
i was aware of thiese documentation links but "what should be the name of the table" is no where given in that documenttion. I just found the solution, it is "dbo.table name in the db" worked in the query. Thank you.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel