Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Unanswered

Filtering Lookup for String x++

Posted on by 65

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

Can you help me with this, please?

Thanks and regards...

  • Martin Dráb Profile Picture
    Martin Dráb 225,588 Super User on at
    RE: Filtering Lookup for String x++

    Your code looks all right to me for an RefRecId field; I suspect that the probem lies somewhere else.

    What do you mean by "I had to convert them into strings ( I had added relations to make them lookup fields)". It sounds strange - and it's probably wrong.

    Can you please confirm the type of InventSite_MyField? Your code expects that is a reference group and it'll fail if not.

    By the way, please ask questions about D365FO in D365FO forums (such as Dynamics 365 Finance Forum), not in the Dynamics AX forum.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans