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
7 subscribers
Views
3381 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Having trouble getting my Data Store for views to map a data type to an existing
judym598
Certified Senior Developer
over 9 years ago
Having trouble getting my Data Store for views to map a data type to an existing view. I created a view by joining data from 2 tables. I then created a data type to associate with that view so I could use it to display data in a dropdown list (or grid). When I add the data type to the DS for Views - it says the mappings cannot be verified. If I let it 'create' the table - it creates a new table (not the view). I downloaded the XSD from the data type I created and tried to manually map it to the view (as was suggested in another post), then deleted the data type and created it from the new XSD. Still doesn't work when I try to publish the DS.
Here's what I used to create my view:
CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `ipsproductsubmitter_v` AS SELECT `a`.`id`, concat (`a`.`id`, " - ", `a`.`productname`) AS `IP Name`, `a`.`productdescription`,`b`.`submittername1` AS `Submitter 1`, `b`.`submittername2` AS `Submitter 2` FROM `Appian`...
OriginalPostID-166396
OriginalPostID-166396
Discussion posts and replies are publicly visible
Parents
0
judym598
Certified Senior Developer
over 9 years ago
Just updated my xsd as suggested and also changed my 'ORDER BY' clause in the view to ORDER BY id. This worked! Thank you!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
judym598
Certified Senior Developer
over 9 years ago
Just updated my xsd as suggested and also changed my 'ORDER BY' clause in the view to ORDER BY id. This worked! Thank you!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data