Workflow form redirect shows all records.

(0) Share

Report

Posted on by vicky1234

Hi all,

I have created a custom workflow and it works perfectly .

The problem is that the approval manager when checks the "work items assigned to me " form , I tiwll show a record saying "abc submitted".

On click of this it actually opens the workflow list form which again has a hyperlink form to the main table but the problem is that when the main form is opened it shows all the records to the approval manager . I am not sure if we need to write some logic on init for this too as I was assuming that this works by std.

Am I missing any setting.

Below requirement when form is opened normally.

Also the custom form on which workflow is set needs to show records to users based on their userid only So user a will see 10 records submitted by him only and not of other users.

However the manager will see all the records whenever this form is open via normal ways.

Thanks,

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Dynamics Community 101 310 on at

Like (1)

Report
Copy link

Link copied!

Hi Vicky,

Please ensure that menu items assigned in workflow approval and workflow type are of detail page form and not list page forms.

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,190 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hello Vicky,

You need to have two form a detail page and a list page. On the detail page, you need to write a line of code on the form init, and on the datasource execute query.

RecId record; ///
/// Form init ///
public void init() { YourTable yourTable = element.args().record(); record = yourTable.RecId; super(); }

Datasource

///
/// Datasource ///
public void executeQuery() { QueryBuildRange qr; qr = this.Query().dataSourceTable(tableNum("yourTable")).addRange(fieldNum(yourTable,recid)); qr.value(SysQuery::value(record)); qr.status(RangeStatus::Locked); super(); }

Was this reply helpful? Yes No
Suggested answer

GirishS 27,833 Moderator on at

Like (2)

Report
Copy link

Link copied!

Hi vicky,

As per komi comment you need to add caller as query range to details form.

Also you mentioned another requirement - Show data based on the user ID. For this you need to enable created by property to yes on the table level.

On the execute query you need to check whether logged in user ID is not manager means - add the range to created by field and value should be curuserid() and on the else statement clear range.

Thanks,

Girish S.

Was this reply helpful? Yes No
vicky1234 68 on at

Like (0)

Report
Copy link

Link copied!

Thanks Komi and Girish

the above code works .

For the user filteration ssue I wrote another logic to fix it.

Was this reply helpful? Yes No