User login
|
|
|
|
Frontpage Sponsor
|
|
|
|
Poll
|
How big is your Baan-DB (just Data AND Indexes) 0 - 200 GB 18% 200 - 500 GB 28% 500 - 800 GB 3% 800 - 1200 GB 7% 1200 - 1500 GB 7% 1500 - 2000 GB 13% > 2000 GB 24% Total votes: 71 |
|
Baanboard at LinkedIn
|
|
|
|
|
duplicate record in query.extend.where.in.zoom
|
|
By DDPatel at 20 Jun 2019 - 06:42
|
|
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
|
|
|
|
All times are GMT +2. The time now is 00:25.
duplicate record in query.extend.where.in.zoom
However the above approach could become costly on the DB.
Regards,