Multiple ranges on form init method

(0) Share

Report

Posted on by D365 beginner

636

Hi Experts,

I have a customized form where I have created a range in the init method of the form to enable users to see only the records where the user's personnel number matches with the employee Id field in the table. below is the code that I have added and its works fine. Now I need to add one more range that there is a field named USERID in the table and match it with curUserId(). So the user will be able to view the records created by him and where ever his employee id is mentioned by some other user also. I hope the requirement is clear how Can I add it in the below code ?

public void init()
{
RecId EmployeeId;
HcmWorker _hcmWorker;

super();

EmployeeId = DirPersonUser::findUserWorkerReference();

select _hcmWorker where _hcmWorker.RecId == EmployeeId;

MyTable_Ds.query().dataSourceTable(Tablenum( MyTable)).addRange(fieldNum( MyTable,EmployeeId)).
value(SysQuery::value(_hcmWorker.PersonnelNumber));
}

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Suggested answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!

You can use expressions in query ranges

www.axaptapedia.com/Expressions_in_query_ranges

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

Like (0)

Report
Copy link

Link copied!

Hi Ergun,

Thanks for your response. In my case I need to add ranges in two fields with OR condition.

MyTable.Employee Id with User Personnel number

MyTable.User Id with Current user

Is this can be done using expressions ? Can you please help me to rewrite the above code.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,172 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi, yes it can be achieved by using Expressions in query ranges.

There's an example in the page that matches your requirement exactly (having OR range for two different fields).

This is the example - understanding it and applying the understanding to your requirement is your homework

Find records where the ItemType is Service or the ItemId is B-R14. Note the nesting of the parenthesis in this example.

queryBuildRange.value(strFmt('((ItemType == %1) || (ItemId == "%2"))', any2int(ItemType::Service), queryValue("B-R14")));

Was this reply helpful? Yes No
Verified answer

ergun sahin 8,826 Moderator on at

Like (0)

Report
Copy link

Link copied!
Yeap, You can do. Look for this lines

queryBuildRange.value(strFmt('((ItemType == %1) || (ItemId == "%2"))', any2int(ItemType::Service), queryValue("B-R14")));

in your case something like this;

queryBuildRange.value(strFmt('((EmployeeId == %1) || (UserId == "%2"))', queryValue(_hcmWorker.PersonnelNumber), queryValue(curUserId())));

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

Like (0)

Report
Copy link

Link copied!

Thanks for your support Ergun & Nikolaos. Its worked fine.

Was this reply helpful? Yes No