Dynamics Community Forum Thread Details

Filtering Lookup for String x++

I had lookup fields (type:int64, Extended from RefRecId) and I had written lookup filtering code for them but I had to convert them into strings ( I had added relations to make them lookup fields) But since they are "String" instead of "reference group" my code doesn't work. How can I filter them when they are 'string'. Here is my code for filtering for reference groups:

[FormControlEventHandler(formControlStr(InventSite, InventSite_MyField), FormControlEventType::Lookup)]
    public static void InventSite_MAndEDay_OnLookup(FormControl sender, FormControlEventArgs e)

    {
        SysReferenceTableLookup tableLookup = SysReferenceTableLookup::newParameters(tableNum(ReferenceTables), sender);
        Query query = new Query();
        InventSite inventSite;


        QueryBuildDataSource qbds = query.addDataSource(tableNum(ReferenceTables));

        qbds.addRange(fieldNum(ReferenceTables,ReferenceTablesType )).value(queryValue(ReferenceTablesTypeBaseEnum::MyField));

        tableLookup.addLookupField(fieldNum(ReferenceTables, Name ));
        tableLookup.addLookupField(fieldNum(ReferenceTables, Description ));


        tableLookup.parmQuery(query);
        tableLookup.performFormLookup();

        FormControlCancelableSuperEventArgs ce = e as FormControlCancelableSuperEventArgs;
        ce.CancelSuperCall();
    }

Screen-Shot-2021_2D00_10_2D00_18-at-15.29.35.png