Share
Report
2Added a range in newly created AOT query for field AccountNum.
Need to add one more range with OR condition ,for field /InvoiceLocation/, If I add one more range its taking as /and/ condition.
Using SysRangeUtil class method for passing range value.
Trying to use below code for Range value:
[ExtensionOf(classStr(SysQueryRangeUtil))]
final class TestSysQueryRangeUtil_Extension
{
[QueryRangeFunctionAttribute()]
public static str getVendorAccountNum()
{
RecId partyRecID;
AccountNum vendorAccount;
str vendorWarehouse;
XdsVendorwarehouseSetup userWarehouse;
userWarehouse = XdsVendorwarehouseSetup::find(curUserId());
final class TestSysQueryRangeUtil_Extension
{
[QueryRangeFunctionAttribute()]
public static str getVendorAccountNum()
{
RecId partyRecID;
AccountNum vendorAccount;
str vendorWarehouse;
XdsVendorwarehouseSetup userWarehouse;
userWarehouse = XdsVendorwarehouseSetup::find(curUserId());
// vendorWarehouse = strfmt('(/%1/ || (%2 == /%3/))',userWarehouse.VendAccount,fieldstr(VendTable,InventLocation),userWarehouse.InventLocationId);
vendorWarehouse = strfmt('(%1 == /%2/ || (%3 == /%4/))',
fieldstr(VendTable,AccountNum),
userWarehouse.VendAccount,fieldstr(VendTable,InventLocation),
userWarehouse.InventLocationId);
return vendorWarehouse;
}
}
No records coming for the above.
All responses (
Answers (
