Fetch Data From View Using Query Rule

pavanik

Certified Senior Developer

over 8 years ago

Hi,

I am fetching employee data from view using query rule .. I am facing fallowing error.
-----------------------------------------

Expression evaluation error in rule 'kp_ial_getempdetailsfromview' at function 'queryruleexec': Error evaluating function 'queryruleexec' : Error converting query output (rule: [KP_IAL_getEmpDetailsFromView], type: [KPIALSearchForEmployeeDT8936], objects successfully converted: [9])

If I used query entity its working fine. Any suggestions to get this to work?

Please find following screenshot.

Thanks in advance

Discussion posts and replies are publicly visible

Parents

0 chetany
A Score Level 1
over 8 years ago

I think you have a View based on some table(s). The primary key in a table cannot be null. But, in the CDT used for the view - you have mapped some column as @Id. And somehow a row for that column (which is annotated with @Id) turned out to be null.. You will need some more time to debug why that happened
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chetany
A Score Level 1
over 8 years ago

I think you have a View based on some table(s). The primary key in a table cannot be null. But, in the CDT used for the view - you have mapped some column as @Id. And somehow a row for that column (which is annotated with @Id) turned out to be null.. You will need some more time to debug why that happened
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data