This is regarding the CDT's. We have a database view and there is no d

narasimhaadityac

A Score Level 2

over 8 years ago

This is regarding the CDT's.
We have a database view and there is no defined identifier column hence we have defined one of the column as primary key while defining CDT. We observed that there are duplicate entries coming up for this column defined as primary key.
When using "Query Rule" the duplicates are eliminated and it is showing only one row
When using "Query Entity" we are been returned with all entries and its not honoring the primary key column.

Any idea on why this difference in behaviors?

Discussion posts and replies are publicly visible

Parents

0 ChristineH
Certified Lead Developer
over 8 years ago

That is as designed.... Depending on what you need to occur, will dictate which to use and maybe even what action to take (i.e. add a "unique" field to the view).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 8 years ago

That is as designed.... Depending on what you need to occur, will dictate which to use and maybe even what action to take (i.e. add a "unique" field to the view).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data