How do i build a relation for the typed view(vwLatestAssuranceRequest ) in following query

select tblope.ope_id,Ope_name,vwLatestAssuranceRequest.Procl_date from tblCase inner join tblOpe on tblCase.ope_id = tblOpe.ope_id and ope_deleted = 'N' inner join vwLatestAssuranceRequest on vwLatestAssuranceRequest.case_guid = tblCase.Case_GUID where asss_code = 'SCH' and tblCase.Ope_id in ('ACA000','BGK000') order by ope_id

I am using llblgen version 2.5

Hi Clix,

At LLBLGenPro Designer you have to map your DatabaseView as an Entity (not TypedView), then you can add relations between that entity and other entities.

For the join you are proposing (ope_deleted = ´N´) please read LLBLGenPro Help - Using the generated code - (Adapter or SS) - Filtering and Sorting - Advance filtering usage - Custom filter for EntityRelations

Work on it and let us know if you need further assistance