view entity

[sreejithpallikkara]

Hi
I am a fresher to Ofbiz, I want to create view entity for the following SQL Query,

create view newView as (SELECT pr_id FROM span_purchase_request where pr_id not in(SELECT distinct pr_id FROM span_request_for_quotation))


I have tried it in Ofbiz, but not able to get the propper output.

Plaese help me on this...


Thanks & Regards
Sreejith P