Baanboard.com

Go Back   Baanboard.com > Blogs > DDPatel's blog

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
100%
Handover everything to System Integrator from drawing BP till implementation of ERP
0%
Hire more inhouse skilled & capable IT Resource to work directly with SI
0%
Rely on SI Architects/Consultants
0%
Total votes: 1

Baanboard at LinkedIn


Reference Content

 
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

0
No votes yet

by oirfeodent on July 8, 2019 - 7:06am
oirfeodent's picture
Quote:
Originally Posted by DDPatel View Post
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,

by DDPatel on April 30, 2020 - 12:44pm
Quote:
Originally Posted by oirfeodent View Post
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

by bhushanchanda on May 15, 2020 - 10:40am
bhushanchanda's picture
Please post your questions in correct forums and not as blogs.

Moved this to Tools Dev.


All times are GMT +2. The time now is 12:01.


©2001-2018 - Baanboard.com - Baanforums.com