How to restrict to see another user request( record) in prepared by me form in ax 2012

(0) Share

Report

Posted on by Naveen Mishra

Dear Expertise ,

I have setup a Maintenance Request form where user can create a request for any maintenance . This system is like Purchase Requisition .

For this I am showing three form on front like below screenshot .

1 - In All Maintenance Ticket - Manager can see All the Maintenance Ticket created by all users in Company .

2 - In Maintenance Assign to Me - Users Like mangers can see the ticket assign to him for approval .

3 - In Maintenance Ticket Prepared by me - User can see only self created ticket .

Now 1 & 2 points are working very fine , But the issue in 3rd point is currently all users able to see self and other users ticket as well .

Now all users is able to see each other tickets in this form , My requirement is how to restrict other users ticket to other users .

Please suggest .

All responses (16)

Answers (2)

Naveen Mishra 4 on at

Like (1)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Dear Gunjan,

I got the solution .

I check in Purchreqtable there is a field named Originator , and i follow same in my custom table create a new filed Originator and make relation with HcmWorker and Restore my Query , Set the same like below screenshot and Now its working fine .

Note - still not understand why this not working with created By field .

Thanks.
Naveen Mishra 4 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Yes , In created by field have value (My ID) .

in my case the problem is when i left blank in value property , and then create any record , all my record and other users record is displaying .

But , when i set the curUserId() in value property in created by and go on the form all record is invisible the form and if i create new record that is also not display .
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Naveen,

I tried a list page with the range set to curUserId() and it works perfectly fine. Not sure why it is not working for you.

You can open the table browser and check for the CreatedBy field, if it is showing the values correctly.
Suggested answer

nmaenpaa 101,158 Moderator on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

I searched the web for "dynamics ax x++ form add range" and this was among the first results: hellodax.com/.../
Naveen Mishra 4 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Dear Nikolaos Mäenpää ,

Can you please suggest how to assign the range in runtime (when the form is opened).
Naveen Mishra 4 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Hi Gunjan ,

When i putting value like (curUserId()) and press enter , system is generating below error .

Please suggest .
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Naveen,

Please change the value to (curUserId()), with the brackets, and check if that works.
Naveen Mishra 4 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Hi Gunjan ,

I am creating new record after set range and value like above , but the record is not displaying .
Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Sorry, I didn't see your earlier post.

For the user you are testing with, has any records been created? Can you created a new record and test?
Naveen Mishra 4 on at

Like (0)

Report

RE: How to restrict to see another user request( record) in prepared by me form in ax 2012

Not understand sir . Please explain .