Hi to all,

Am working on a T24 project (R09)

My question is :
For exemple we have an ENQUIRY that select data from CUSTOMER & SECTOR application.
First we should get the information from CUSTOMER(the main file) based on some criteria then we will get the DESCRIPTION from SECTOR using LINK function.

I need to apply a filter not on CUSTOMER fields but on the DESCRIPTION data that I got from SECTOR (ex : if the desctiption is empty i want to hide the line from my enquiry's result).

I was trying to use the REMOVE attribute on my enquiry but the help provided does not explain enough how to use this attribute.

Thanks in advance.
Regards.

Hi,
I'm afraid you have to write a conversion routine. Try set conversion
routine on last field in enquiry, check your condition using
FORMATTED.DATA variable and if the record is not suitable for you follow this:

1. reset FORMATTED.DATA = ''
2. reset O.DATA
3. if 1&2 doesn't work decrement LINE variable

All mentioned variables are global variables (I_ENQUIRY.COMMON)

Create J-Descriptor for CUSTOMER table that will link to DECRIPTION filed in SECTOR :

USR.FIELD.NAME. MY.CUST
USR.TYPE....... J
USR.FIELD.NO SECTOR>SECTOR>DESCRIPTION


and then use this J-Descriptor as fixed selection field in your enquiry.

It will slow down a bit the report.

I tried both of the answers, and it works.

Thanks.

did u checked if the records selected in ur enquiry are less then a dropdown list, do u see blank records in ur enquiry ?

yes I checked it, and it works perfectly. The result doesn't contain the deleted line. You just need to put your conversion routine in the last field.