using query build range with multi ranges

(0) Share

Report

Posted on by maram fraij

I have the below X++ code how can I apply the where clause using query build range.

select pionHCMVacationSettlement where pionHCMVacationSettlement.Worker==22565420970 && pionHCMVacationSettlement.posted==NoYes::No;

I try the following but it does not work

queryBuildRange = queryBuildDataSource.addRange(

FieldNum(PionHCMVacationSettlement,Worker));

queryBuildRange.value(strFmt('(%1 == %3) && (%4 == %5)',

fieldStr(PionHCMVacationSettlement, Worker),

queryvalue(22565420970),

fieldStr(PionHCMVacationSettlement, Posted),

queryvalue(NoYes::No)));

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

You can do in a more simply way :

queryBuildRange = queryBuildDataSource.addRange(FieldNum(PionHCMVacationSettlement,Worker));

queryBuildRange.value( queryvalue(22565420970) );

queryBuildRange = queryBuildDataSource.addRange(FieldNum(PionHCMVacationSettlement,Posted));

queryBuildRange.value( queryvalue( NoYes::No ) );

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

that means by adding two ranges to the same queryBuildRange the condition will be adding between the ranges not the second one overwrite the first one ?

Was this reply helpful? Yes No
mostafa mahmoud 5,125 on at

Like (0)

Report

DENIS MACCHINETTI is right , the piece of code he wrote is the correct one ,

you can also use the SysQueryRangeUtil Class for date ranges and other range scenarios

for more information use the below link

Link

Was this reply helpful? Yes No
Martin Dráb 237,970 Most Valuable Professional on at

Like (0)

Report

@Maram: Yes, if you set a value to one range object, it has no effect to other ranges. Nevertheless if you set value again on the same object, the previous value would be lost.

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

@Martin in this case "Nevertheless if you set value again on the same object, the previous value would be lost." How do we write two ranges on a same field ?

For example

Have a field Invoice on a form. I need to add a range on Invoice to display only the records which does not start with "Inv" AND don't show the records which has Invoice field as empty.

How can this be achieved if possible?

Thanks

Was this reply helpful? Yes No
Martin Dráb 237,970 Most Valuable Professional on at

Like (2)

Report
Simply call addRange() once more; it will create a new range object.

For example:

FieldId fieldId = ...; qbds.addRange(fieldId).value("First filter"); qbds.addRange(fieldId).value("Second filter");

Was this reply helpful? Yes No
Muhammad_Ali 353 on at

Like (0)

Report

Thanks Got it !!

Was this reply helpful? Yes No