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,