where clause in entity views

[lemine youssef]

Hi all,
Simply, Iwant to get a view representing teh result of this query:
Select *
 From PosTerminalState PTS
Join PosTerminalLog PTL on (PTS.posTerminalId=(PTL.posTerminalId)
WHERE PTL.transactionId>=PTS.startingTxId and
PTL.transactionId<=PTS.endingTxId

Is there anyway to do this in entitymodel, dynamic view findbycondition ?
Any idea will be appreciated .
Best regards.