Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

filter problem in avid grid display

former_member420959
Participant
0 Kudos

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

4 REPLIES 4

sivaprasad_paruchuri
Active Participant
0 Kudos

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

0 Kudos

hi siva,

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

is there any other way

arivazhagan_sivasamy
Active Contributor
0 Kudos

Hi ujwal,

Assign same value to all the manufacturer code.

Arivazhagan S

raymond_giuseppi
Active Contributor
0 Kudos

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