Adding ranges on Forms

(0) Share

Report

Posted on by D365 beginner

634

Hi Guys,

I just need to add a range while opening a form, I am trying to do it through Init and Execute methods. Kindly let me know how I can add more records in the range.

init method :

VariableQBR=
this.query().dataSourceName('PBATableInstance').addRange(fieldnum(PBATableInstance,Variable));

Execute method:

VariableQBR.value(queryvalue('Test1'));

In the above, string Test1 is my variable to be displayed on the form (its working fine). How can I display variables Test1 and Test2 in the form ? how the code should be ?

Thanks in Advance

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Alex,

If you look at the General journal form, there is a neat example. On this form you can select to see Open, Posted or all Journals.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Hi!

For example how add some range values

class SysQuery

Method

// Can't be an instance method because new queryRun() until takes a query! static void addRangesFromKeyData( QueryBuildDataSource qbds, KeyData keyData // Must be a unique list of values! ) { Map keyDataMap; MapEnumerator me; // A local a method is used because the a variable can change type for each while loop anytype a() { anytype a; [a] = me.currentValue(); return a; } //Only do Map::create() when container has at least 4 parameters. version,domain type, //range type and size if (conLen(keyData) >= 4) { keyDataMap = Map::create(keyData); me = keyDataMap.getEnumerator(); while (me.moveNext()) { qbds.addRange(me.currentKey()).value(queryValue(a())); } } }

Was this reply helpful? Yes No
D365 beginner 634 on at

Like (0)

Report

Hi Andre,

Thanks for the reply.

I am looking on it as you said. Anyway can you share with me if its possible to do by a simple code ?

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report
Hi Alex Antony,

Here is simple code

VariableQBR.value(strFmt('((Variable == "%1") || (Variable == "%2"))', queryValue("Test1"), queryValue("Test2")));

Was this reply helpful? Yes No
Suggested answer

D365 beginner 634 on at

Like (0)

Report

Thanks a lot Mr. Ievgen Miroshnikov. It works fine.

You are always there with great support for AX beginners.

Was this reply helpful? Yes No