Hi,
I want to know how to use a filter in zoom .

For example,
A filed named warehouse, value is A
A filled named warehouse item

I want the warehouse item filed to use zoom, zoom session is using warehouse + warehouse item . So I want in the zoom session only to display the data in warehouse A , not to display all data in all warehouse.

How to do it ?

Thank you.

Jeffers

query.extend.where("<your condition>")

Hi en@frrom
where to put the code : query.extend.where("<your condition>") ?

Now I am only use dfe to modify the field to use zoom. and can i use program script to put the code ?

Hi en@frrom
where to put the code : query.extend.where("<your condition>") ?

Now I am only use dfe to modify the field to use zoom. and can i use program script to put the code ?


query.extend.where(), query.extend.where.in.zoom()

--------------------------------------------------------------------------------

Syntax
void query.extend.where( string extension_string [, mode] )
void query.extend.where.in.zoom( string extension_string )

Description
Use this to construct a query extension for the WHERE clause of a database query. Use query.extend.where() for non-zoom sessions. Use query.extend.where.in.zoom() for defining query filters for zoom sessions.

Arguments
extension_string
A string containing the names of the fields to be included in the WHERE statement. Use commas [,] to separate the field names.

mode
This optional argument can have one of the following values:

EXTEND_OVERWRITE replaces any existing query extension
(this is the default mode)

EXTEND_APPEND appends this extension to the existing extension


Note
In BaanERP, this function replaces the predefined variable query.extension that was used in earlier versions of the software.

Regards

in the zoomed to session. Another option to point the warehouse/item combination at item A, is to use resular zoom functionality, and in the before.zoom section, you say tablename.item = "A"... This will make sure (in most cases) that the zoom session will point to "A", however it is not filtering, other items are still visible

Hi,
I attach a part from the SoftwareProgrammingStandards.
This gives you a lot of info.

Regards, Adriaan

Hi,Dear All

I define the zoom in dfe, And I put the query.extend.where.in.zoom() in the program script,selection.filter Section. But i find it can not work.

And I don't know how to use set.browse.filter. Is there must put DAL Script in the table which zoom to ?
And if not I can not complie the script just like in the Word Document.

Thank you.

Hi,

It is not mandatory to put the filter in the dal. The reason for this is to have consistency between check and filter. You don't want to show data during zooming which is rejected by the dal-checks after selecting it.
If you want to use the macro then you also need to define the include "itcmcs2000".

Just using the standard toolsfunction query.extend.where.in.zoom in the selection.filter hook should be sufficient.
This selection.filter hook will also be used during the autocomplete.

Adriaan

Hi, All,
I had tried the way selection.filter hook, but it can not work.
I had recorded the screen. Could you help to find the mistakes ?

Thank you .

So use:

item.f.segement.2:
filter.selection:
query.extend.in....

I don't know exactly when to use this segment but i tested it and this did work for me.

Regards, Adriaan

Yeah, it really works , thank you very much!

So use:

item.f.segement.2:
filter.selection:
query.extend.in....

I don't know exactly when to use this segment but i tested it and this did work for me.

Regards, Adriaan