web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Multi select in dialog...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Multi select in dialog field

(0) ShareShare
ReportReport
Posted on by PrachiGupta97 152

I have a field in my dialog named "item id"

The input should be 112..115 from the dialog.

So that 112,113,114,115 are selected .

So how do I create the field to accept the format "112..115"?

Can you give me the code? I was told to use a query but how to use it to accept a range?

I have the same question (0)
  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi PrachiGupta97,

    Here is an example of how to create a query for RunBase dialogs.

    jkmsdax2012.wordpress.com/.../

    In your case, you can use InventTable as a root data source for the table and the user can add "112..115" by pressing "select" button on the dialog and putting filter to ItemId field.

  • PrachiGupta97 Profile Picture
    PrachiGupta97 152 on at

    I already have another query for syslookupmultisect control. will the method initparmdefault effect my other query?

  • PrachiGupta97 Profile Picture
    PrachiGupta97 152 on at

    Hi I am also getting an error when I used the blog.

    Error:the qualifier queryRun is not valid in this context. Use a variable of this type instead

    Same error is coming for queryRun.

    Also in the blog .. we are creating a range for date..

    I am already getting a range for the item id.

    So do i need to add

    queryRun.query().datasourceno(1).addrange(fieldnum(inventable,itemid)).value()+'..'?

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi PrachiGupta97,

    The range value should be passed as a parameter to the "value" method.

    queryRun.query().datasourceno(1).addrange(fieldnum(inventable,itemid)).value(SysQuery::range('item01', 'item10'))

    To be honest, using ranges for strings is a doubtable feature, or at least you need to be sure that the item number is properly numerated.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans