Set filter with addin in RTC

Dynamics 365 Business Central/NAV Developers Forum
#1

Hello guys,

I tried to write an addin which sets a filter (I want to imitate the lovely classic client search on records) but it doesn’t work. My addin read out the current cell, get the column name (don’t know why but it works only on text columns, not on lookups) and write them back to the C/AL over OnControlAddIn-function. After this I tried to set the filter with C/AL (I send back the columnname and the searchterm) but… it’s very difficult to build this filter dynamic and I think not the “clean” way.

Did somebody know a way to set a filter in the RTC out of an addin?

And optional: I’m on the businessgrid and there in the currentcell. But on lookup columns I can’t get the headertext, why?

Thanks a lot an best regards,

Bastian

#2

Hey,

we’ve found a solution :slight_smile:

The problem was that I’ve set the filter on the field/recref and not to the rec. The solution was following line to copy the “filter” from the recref to rec with:

Rec.SETVIEW(RecordReference.GETVIEW());

CurrPage.UPDATE(FALSE);

Now we can search in the RTC like in the classic client :slight_smile:

best regards

#3

Hello,

can you share this add-in or can you give me any information about your solution.

many thanks

stony

#4

I tried to reply you by mail but your E-Mail adress didnt work! Maybe update it and send me an mail again :wink:

#5

OK, I have updated my profile. Now i should be ok.

Thanks,

stony