How can we use List, Map or Container in D365 for the custom Values of LookUp.

(5) Share

Report

Posted on by bilal170795

185

I want to use the custom values for lookup, not want to make the table. How can I achieve this through Coding? I have tried the following code but it's quite old and not working in D365. Actually, there is no method such as SysLookup::lookupList().

public void lookup()
{
    Counter yearCount;
    List    valueList = new List(Types::String);

    for (yearCount = 0; yearCount < 5; yearCount++)
    {
        valueList.addEnd(strFmt("Year %1", year(SystemDateGet()) - yearCount));
    }

    SysLookup::lookupList(this, valueList, "List of years");
}

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (1)

Report

Hi Bilal,

Have you considered creating a temporary table; then fill this table with the values dynamically and then use it for the lookup?

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi,

Check class SysPickList and especially how it's used in DirPartyLookupFormEventHandler_CopyCustVend.CopyCustFrom_OnLookup method.

Was this reply helpful? Yes No
Blue Wang on at

Like (2)

Report
Hi Bilal,

Are you looking for a non-database lookup?

You can check Global :: Picklist () if it's meet your needs.

A simple example:

Map lookupmap = new Map(Types::Integer, Types::String); lookupmap.insert(1,"First"); lookupmap.insert(2,"Second"); lookupmap.insert(3,"Third"); Global::picklist(lookupmap);

Was this reply helpful? Yes No
bilal170795 185 on at

Like (0)

Report

Thanks, Sergei

Was this reply helpful? Yes No
bilal170795 185 on at

Like (1)

Report
Hi Blue,

where I will place this piece of code? because i tried an example like that in the event handler it didn't work.
[quote user="Blue Wang"]
Hi Bilal,

Are you looking for a non-database lookup?

You can check Global :: Picklist () if it's meet your needs.

A simple example:

Fullscreen
1
2
3
4
5
6
7
Map lookupmap = new Map(Types::Integer, Types::String);
lookupmap.insert(1,"First");
lookupmap.insert(2,"Second");
lookupmap.insert(3,"Third");
Global::picklist(lookupmap);
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Map lookupmap = new Map(Types::Integer, Types::String); lookupmap.insert(1,"First"); lookupmap.insert(2,"Second"); lookupmap.insert(3,"Third"); Global::picklist(lookupmap);

[/quote]

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

Hi Bilal,

Override your control's lookup().

Was this reply helpful? Yes No