Finance | Project Operations, Human Resources, ...

Add Different Values In Range Of query Or Table

(0) Share

Report

Posted on by sylvesterPowerBi

384

Dear Gentlemen,

I want to create a new range On InventTransferTable which includes 2 different values, below is my code please advise if this is possible:

sender.query().dataSourceName(sender.name()).addRange(fieldnum(InventTransferTable, Transferstatus)).value('(TransferStatus=="Shipped") && (Inventlocationidfrom=="Location1") ||(TransferStatus=="Received") && (Inventlocationidfrom=="Location2") ');

The Point is, i want to assign this query range to a certain user to see only the Shipped from location 1 and the Received from location 2, on the Invent Trans Order Form.

Please Note that i also tried to create a new AOT Query and to add the same filter in range but it didn't work.

The results are always blank form with no data.

Appreciate your help.

All responses (3)

Answers (0)

Sort by

Suggested answer

nmaenpaa 101,172 Moderator on at

Like (2)

Report
Copy link

Link copied!

This doc is what you need: docs.microsoft.com/.../using-expressions-in-query-ranges
sylvesterPowerBi 384 on at

Like (0)

Report
Copy link

Link copied!

It's Not working when i insert && instead of || , the return is always Null.

this is my code :

sender.query().dataSourceName(sender.name()).addRange(fieldnum(InventTransferTable, Transferstatus)).value(
strFmt('((%1=="Shipped" )&&(%2=="Location1"))',fieldStr(InventTransferTable, TransferStatus),fieldStr(InventTransferTable, InventlocationidFrom)));

Please Advise.
Suggested answer

nmaenpaa 101,172 Moderator on at

Like (0)

Report
Copy link

Link copied!

It's useful to try to print your range to infolog to see what is wrong with it.

Perhaps the range is different than you intended.

Or perhaps there is no data that corresponds to you range.

And when using enum values in ranges, use enum2str(EnumName::EnumValue) instead of hardcoded strings.

If you need more help, please share all your range from infolog, and screenshot of your data so that we can see if you should get results with that range or not.