duplicate record in query.extend.where.in.zoom

[DDPatel]

A new blog entry has been added:

duplicate record in query.extend.where.in.zoom

hiii gurus,

I need a help in query.extend.where.in.zoom.
(Scenario)
field.orno.from:
   before.zoom:
   selection.filter:
      query.extend.select.in.zoom("tdcsl491.orno")
      query.extend.from.in.zoom("tdcsl491")
      query.extend.where.in.zoom("tdpur400.orno = tdcsl491.orno)
- i have used two table in query.extend.
- on above example tdpur400.orno has only one record but tdcsl491.orno has a multiple record.
So, When i am trying to open the zoom button,it show me many duplicate record...

Is that possible to get single/Unique record on  "query.extend.where.in.zoom" ???


Thanks in Advance,
DPatel

[oirfeodent]

Originally Posted by DDPatel

A new blog entry has been added:

duplicate record in query.extend.where.in.zoom

An easy approach would be to use exists in the where clause instead of equi-join.
However the above approach could become costly on the DB.

Regards,

[DDPatel]

Originally Posted by oirfeodent

An easy approach would be to use exists in the where clause instead of equi-join.
However the above approach could become costly on the DB.

Regards,

Thanks for your reply and sorry for my late reply.

how do we use equi-join in my previous example?
Could you please write sample code?

Thanks and Regards,
DDPatel

[bhushanchanda]

Please post your questions in correct forums and not as blogs.

Moved this to Tools Dev.