Baanboard.com

Baanboard.com (http://www.baanboard.com/baanboard/index.php)
-   Tools Development (http://www.baanboard.com/baanboard/forumdisplay.php?f=8)
-   -   duplicate record in query.extend.where.in.zoom (http://www.baanboard.com/baanboard/showthread.php?t=71996)

DDPatel 20th June 2019 07:42

duplicate record in query.extend.where.in.zoom
 
A new blog entry has been added:

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

Quote:

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 8th July 2019 08:06

Quote:

Originally Posted by DDPatel (Post 212422)
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 30th April 2020 13:44

Quote:

Originally Posted by oirfeodent (Post 212536)
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 15th May 2020 11:40

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

Moved this to Tools Dev.

DDPatel 4th July 2020 09:31

1 Attachment(s)
I am already on Tools Dev forum @bhushanchanda.
Please guide me if still i am going wrong....


Now come back on thread,
Still haven't solved the thread...
Again i am trying to explain the scenario with better clarification.

I have below code,
HTML Code:

field.orno.from:
  before.zoom:
  selection.filter:
      query.extend.select.in.zoom("tdpur400.orno")
      query.extend.from.in.zoom("tdcsl491, tdpur400")
      query.extend.where.in.zoom("tdpur400.orno = tdcsl491.orno")

- On above code tdpur400.orno (have 1 Matching Record) = tccsl491.orno(Have 4 Matching Record)

- So when i click on Zoom button , The same record has repeated 4 times in a row.
- Have attached the Snap Shot for more reference.


Could you please help me out of this??




Thanks in advance,
Regard,
DDPatel


All times are GMT +2. The time now is 17:45.


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