Hi All,

I have used query.extend.where.in.zoom to filterout item based on product type and product line. But its not working.

My Code is as follows:
field.item.f:
selection.filter:
query.extend.where.in.zoom("tcibd001.ctyp = " & quoted.string(ctyp.f) & " and " &
"tcibd001.cpln = " & quoted.string(cpln.f))

item.f, ctyp.f, and cpln.f are all form fields having standard domains tcitem, tcctyp and tcmcs.cpln respectively.

I am zooming to session tcibd0501m000.

I checked query on session tcibd0501m000 after zooming to that session using ctrl + shift + 8, but it is not showing query extension part mentioned above.

Only doubt in my mind is, Is it because segmented domain??

I also tried to write above code in selection.filter for field.item.f.2 as it is segmented domain.

Pls Help..

Regards,
MilindV

Hi All,

I have used query.extend.where.in.zoom to filterout item based on product type and product line. But its not working.

My Code is as follows:
field.item.f:
selection.filter:
query.extend.where.in.zoom("tcibd001.ctyp = " & quoted.string(ctyp.f) & " and " &
"tcibd001.cpln = " & quoted.string(cpln.f))

item.f, ctyp.f, and cpln.f are all form fields having standard domains tcitem, tcctyp and tcmcs.cpln respectively.

I am zooming to session tcibd0501m000.

I checked query on session tcibd0501m000 after zooming to that session using ctrl + shift + 8, but it is not showing query extension part mentioned above.

Only doubt in my mind is, Is it because segmented domain??

I also tried to write above code in selection.filter for field.item.f.2 as it is segmented domain.

Pls Help..

Regards,
MilindV

Hi,

Of course, when you apply a query.extension("") to field with segment domain , you have to explicit the segment number applying the query.

Hi,

I have mentioned earlier that I tried using selection.filter with segment No. as well in field section as..

field.item.f.2:
selection.filter:
query.extend.where.in.zoom("tcibd001.ctyp = " & quoted.string(ctyp.f) & " and " &
"tcibd001.cpln = " & quoted.string(cpln.f))

But ctrl is not going to selection.filter section.
selection.filter section is not hitting when i do zoom. even i checked before.zoom section is also not getting hit.

Regards,
MilindV

Hi Milind,
Use the selection filter as follows:

field.item.f.segment.2:
selection.filter:
query.extend.where.in.zoom("tcibd001.ctyp = " & quoted.string(ctyp.f) & " and " &
"tcibd001.cpln = " & quoted.string(cpln.f))


That might be the reason for the before.zoom section not getting executed.

Regards,
Amit

Thanks sir,

I ll try it out n ll let you know.

i missed that 'segment' word :o