topic Re: filter problem in avid grid display in Application Development and Automation Discussions

filter problem in avid grid display

former_member420959 — Fri, 03 Jan 2014 11:14:09 GMT

Hi all,

i got a report as support issue and it looks like below

here, the 4th column is address of vendor which goes for 4 lines and remaining columns data donot repeat.

now when i add filter on the non repeating columns i am getting only the first line.

but i need to get the whole set of 4 lines of the vendor.

eg : if set filter on manufactur code as 91579 only 1st line is coming.

my requirement is to get the complete first 4 lines.

please help,

ujwal

Re: filter problem in avid grid display

sivaprasad_paruchuri — Fri, 03 Jan 2014 11:21:38 GMT

hi,

do one thing what ever the field u r filtering make that field value also repeat along with the address lines, and try to use sort functionality on that column in the grid display then it will display single time only and if u go for filtering also it shows four line of address...

regards,

Siva

Re: filter problem in avid grid display

arivazhagan_sivasamy — Fri, 03 Jan 2014 11:28:43 GMT

Hi ujwal,

Assign same value to all the manufacturer code.

Arivazhagan S

Re: filter problem in avid grid display

former_member420959 — Fri, 03 Jan 2014 11:44:20 GMT

hi siva,

i suggested sort functionality but the business is not ok with it.

is there any other way

Re: filter problem in avid grid display

RaymondGiuseppi — Fri, 03 Jan 2014 13:03:04 GMT

As suggested, standard solution is to have same values in every record of a same manufacturer and hide duplicate with sort option. Else you have to go to a long painly development handling event like AFTER_REFRESH and the like...

Else you could just deactivate filter options...

APPEND grid->mc_fc_filter TO gt_toolbar_excluding.
APPEND grid->mc_fc_delete_filter TO gt_toolbar_excluding.

Regards,

Raymond