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 pavanik
Certified Senior Developer
over 8 years ago

Thanks everyone. It was view contain null value as a primary key causing the issue. Corrected it and the error is gone.

I want to know, why query entity works in the same scenario when view contain null as a primary key ?
Glad to know your solutions and thoughts!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 pavanik
Certified Senior Developer
over 8 years ago

Thanks everyone. It was view contain null value as a primary key causing the issue. Corrected it and the error is gone.

I want to know, why query entity works in the same scenario when view contain null as a primary key ?
Glad to know your solutions and thoughts!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data