Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Random range fields in dialog prompt

Posted on by 200

2017_2D00_10_2D00_20_5F00_11_2D00_17_2D00_03.png

Photo is pretty self explanatory.  I am getting range fields in my dialog prompt that I do not wish to be there? Can anybody tell me why they are showing up?

*This post is locked for comments

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Random range fields in dialog prompt

    Hi,

    I prefer to clear all the ranges on the datasource ReqTrans and add the required ranges through code like below

       QueryBuildDataSource qbdsReqTrans;

       QueryBuildRange qbr;

       qbdsReqTrans = this.Query().dataSourceTable(tableNum(ReqTrans));

       qbdsReqTrans.clearRanges();

       qbr = SysQuery::findOrCreateRange(qbdsReqTrans, fieldNum(ReqTrans, Plan*));

  • cowboyott Profile Picture
    cowboyott 200 on at
    RE: Random range fields in dialog prompt

    Resetting the usage data and clearing the cache did not work.  I tried manually hiding the range in the AOT for the specific field that was being displayed. That worked, but then two other random fields are added as ranges.  ???

    BEFORE - dialog

    2017_2D00_10_2D00_23_5F00_15_2D00_47_2D00_16.png

    CHANGE made

    2017_2D00_10_2D00_23_5F00_15_2D00_47_2D00_16.png

    AFTER - dialog

    2017_2D00_10_2D00_23_5F00_15_2D00_46_2D00_38.png

  • Suggested answer
    Chaitanya Golla Profile Picture
    Chaitanya Golla 17,225 on at
    RE: Random range fields in dialog prompt

    Hi,

    Please clear the usage data and refresh the cache to check if this range gets cleared. If you are not sure, from where the extra range is getting added probably you can remove range using the below code:

    this.Query().dataSourceTable(tableNum(ReqTrans)).clearRange(fieldNum(ReqTrans, Plan*));

  • cowboyott Profile Picture
    cowboyott 200 on at
    RE: Random range fields in dialog prompt

    No, all of the query was done in the AOT.  there is a small select statement in the fetch, but nothing that deals with the query itself.  Thanks, Tim

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans