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 sparshs over 8 years ago

Use UUID() to create a unique column for the view, it will give you a unique field for each row of view. This function is simple sql function only.
@Christineh: is it like query rule eliminate duplicate values from the returned datasubset?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sparshs over 8 years ago

Use UUID() to create a unique column for the view, it will give you a unique field for each row of view. This function is simple sql function only.
@Christineh: is it like query rule eliminate duplicate values from the returned datasubset?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data