I have a view in DB which have values, I am trying to fetch the values from view

Navajith K over 10 years ago

I have a view in DB which have values, I am trying to fetch the values from view using a query rule, however only the first row is returned by the query rule as output, I have 3 rows in view which satisfies the queryrule condition. Any thoughts?...

Discussion posts and replies are publicly visible

0 hayleyw over 10 years ago

Hi

Does the database that the cdt maps to have an ID with unique values in it? We came across a very similar problem and it was because it didn't have a unique id.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cichy
Appian Employee
over 10 years ago

Are you testing in process or in rules interface? If in process, make sure you select your input type (acp) in your node as type "multiple" and make sure your pv is also of type "multiple".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Navajith K over 10 years ago

Hi Hayleyw, The CDT is mapped to a View in Database, There is no Unique values in the view...

Hi Mike, I am trying to display the query rule outpu in a paging grid, I have even tried to test this query rule in an expression rule, Its just retreiving one row
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cichy
Appian Employee
over 10 years ago

You still need to define a unique key in the view and identify the column in xsd using @Id. Without a unique column, your query rules will not work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel