View Single Post
  #1  
Old 20th June 2019, 07:42
DDPatel's Avatar
DDPatel DDPatel is offline
Member
 
Join Date: Dec 2018
Location: India,Gujarat,Umbergaon 396150
Posts: 33
DDPatel is on a distinguished road
Baan: LN10.3 - DB: SQL SERVER 2008 R2 - OS: WINDOW SERVER 2008 R2
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
Reply With Quote