Microsoft Dynamics AX (Archived)

X++ Get Production Unit of a Production Order

(0) Share

Report

Posted on by HAIRUL HAZRI

1,214

Hi,

I'd like to get the Production Unit of a Production Order from Applicable resources form as in screenshot below:

2844.produnit.png

The form path is Production Order -> Production route -> Applicable resources.

The query in Applicable resources form starts with WrkCtrTable so I figured I need to join WrkCtrTable from ProdRoute but I couldn't find the correct relation between these two tables anywhere.

That's weird. I don't see any other way to get to the Production Unit.

Has anyone ever done this?

Thank You.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

Hi HAIRUL HAZRI!

The Production Unit field it's a field from WrkCtrTableIndividualView view. This view joined to WrkCtrTable.

Was this reply helpful? Yes No
HAIRUL HAZRI 1,214 on at

Like (0)

Report

Hi Rustem Galiamov,

Yes, I'm aware of that. My problem is I couldn't see how can I join WrkCtrTable from ProdRoute even though the Applicable resources form is called directly from Production route form.

From Production Route form, I did find following relations:

ProdRoute -> WrkCtrProdRouteActivity -> WrkCtrActivity -> WrkCtrActivityRequirementSet

But from WrkCtrActivityRequirementSet I didn't find the relation to WrkCtrTable.

Any idea?

Best Regards.

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report

There is no relation between WrkCtrActivityRequirementSet and WrkCtrTable.

When you open Applicable resources form from Production Route form the init() method of WrkCtrActivityRequirementSet DS adding a link between caller record and WrkCtrActivityRequirementSet in Applicable resources form:

Was this reply helpful? Yes No
HAIRUL HAZRI 1,214 on at

Like (0)

Report

You're right I can see that. But then how can I join from ProdRoute to WrkCtrTable and WrkCtrTableIndividualView?

Do you know any workaround?

Was this reply helpful? Yes No
Rustem Galiamov 8,072 on at

Like (0)

Report
I think there is no direct link between ProdRoute and WrkCtrTable.

This is the generated query when you open the form from ProdRoute:

SELECT * FROM WrkCtrTable(WrkCtrTable_1) WHERE ((IsIndividualResource = 1)) EXISTS JOIN * FROM WrkCtrResourceGroupResource(WrkCtrResourceGroupResource_1) WHERE WrkCtrTable.WrkCtrId = WrkCtrResourceGroupResource.WrkCtrId EXISTS JOIN * FROM WrkCtrResourceGroup(WrkCtrResourceGroup_1) WHERE WrkCtrResourceGroupResource.ResourceGroup = WrkCtrResourceGroup.RecId AND ((SiteId = N'Общий')) AND ((IsWorkCell = 0)) JOIN * FROM WrkCtrTableIndividualView(WrkCtrTableIndividualView_1) ON WrkCtrTable.WrkCtrId = WrkCtrTableIndividualView.WrkCtrId AND ((ValidFrom<={ts '2018-10-02 00:00:00.000'})) AND ((ValidTo>={ts '2018-10-02 00:00:00.000'}))

Was this reply helpful? Yes No
HAIRUL HAZRI 1,214 on at

Like (0)

Report

Hmm now that makes it even more weird. How can the form possibly get the Applicable resources when it has no relation with ProdRoute in the first place?

Is there any workaround for this? I just want to get the Production unit(s) given a Production Order number (ProdId).

I don't see any other way I can do it.

Was this reply helpful? Yes No
Verified answer

Rustem Galiamov 8,072 on at

Like (0)

Report

Applicable resources depends from Resource requirements (Resource requirements tab in Production Route form).

Was this reply helpful? Yes No
HAIRUL HAZRI 1,214 on at

Like (0)

Report

Okay that's new. Can you elaborate more?

So I was referring this link to get the Resource requirements. But then still, I don't see any way I can relate the record to the Applicable resources.

How exactly does the Applicable resources depend on Resource requirements?

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (1)

Report

You can set breakpoint to the WrkCtrApplicableResourceQuery class query() method and you will see how query will be generated when you open Applicable resources form from Production Route form.

Was this reply helpful? Yes No
Verified answer

HAIRUL HAZRI 1,214 on at

Like (1)

Report
I discovered that the following query works. It's the continuation from the Resource requirement job from the link in my previous comment. For now, this solves my problem.

static void ProdRoute_Resources(Args _args) { ProdRoute prodRoute; RecId activityRequirementSetRecId; WrkCtrActivityRequirementEdit requirementEdit; ProdId prodId = "GF-BO-000100"; WrkCtrActivityRequirementType relationShipType; WrkCtrActivityRequirement wrkCtrActivityRequirement; WrkCtrCapability wrkCtrCapability; WrkCtrCapabilityResource wrkCtrCapabilityResource; WrkCtrTableIndividualView wrkCtrTableIndividualView; while select prodRoute where prodRoute.ProdId == prodId { activityRequirementSetRecId = prodRoute.activityRequirementSet().RecId; select WrkCtrActivityRequirement where WrkCtrActivityRequirement.ActivityRequirementSet == activityRequirementSetRecId; requirementEdit = WrkCtrActivityRequirement.requirementEdit(); relationShipType = WrkCtrActivityRequirement.RelationshipType; info(strFmt("%1, %2",relationShipType, requirementEdit)); while select wrkCtrCapability where wrkCtrCapability.Name == requirementEdit join wrkCtrCapabilityResource where wrkCtrCapabilityResource.Capability == wrkCtrCapability.RecId join WrkCtrId,ProdUnitId from wrkCtrTableIndividualView group by wrkCtrTableIndividualView.ProdUnitId where wrkCtrTableIndividualView.WrkCtrId == wrkCtrCapabilityResource.WrkCtrId { info(strFmt("%1", wrkCtrTableIndividualView.ProdUnitId)); } } }

Thank you for pointing out that WrkCtrApplicableResourceQuery class. I can use it to double confirm my findings. Cheers :)

Was this reply helpful? Yes No