Hi aras community,
Would you please help this issue?
Thank you so much in advance.
Hi Joseph
I guess the result what you are getting is correct.
Part 10000 Revision A and Generation 1 has --> MFN0001
Part 10000 Revision A and Generation 2 has --> MFN0002
Which means, MFN0002 should show Part 10000 Revision A and Generation 2 and MFN0001 should show Part 10000 Revision A and Generation 1.
MFN0001 is still connected to Part 1000 older generation. In order to maintain the history it is working this way (example: which Manufacturer Part is deleted or added on which generation)
I quickly tested and If you still want to change this functionality, I assume you are using Innovator 12 version. Follow below steps
Step 1: Search and open PE_ReverseItemsFed_OnGet Method
Step 2: Go to line number 102 and add below if condition (highlighted text is the only change we need to include in this method).
GROUP BY item.CONFIG_ID
) groupeditem ON groupeditem.CONFIG_ID = item.CONFIG_ID AND groupeditem.GENERATION = item.GENERATION",
startItemId, QuoteName(relationshipTableName), QuoteName(sourceTableName));
if (sourceTableName == "PART" && relationshipTableName == "PART_AML")
{
sql = sql + " AND IS_CURRENT = '1'";
}
Step 3: Save and unlock method
Try and let me know if it works for you.
Thank You
Gopikrishnan R
Hi Gopikrishnan,
Thank you for your reply.
Unfortunately, I couldn't find 'PE_ReverseItemsFed_OnGet' method in ARAS system(Aras Innovator Version 11.0 SP9 Build: 6549).
However, I really appreciate your sincere reply.
Thank you.
Hi Joseph
Above solution is applicable for ARAS V12 version. No Worries. Try below solution for V11
Step 1: Search and open PE_GetRelatedParts Method
Step 2: Go to line number 172 and add below if condition (highlighted text is the only change we need to include in this method).
sqlQuery = String.Format(CultureInfo.InvariantCulture, sqlQuery,
this.ID,
this.RelationshipItem.SourceItem.TableName,
this.RelationshipItem.TableName
);
if (this.RelationshipItem.SourceItem.Type == "Part" && this.RelationshipItem.Type == "Part AML")
{
sqlQuery = sqlQuery + " AND IS_CURRENT = '1'";
}
Step 3: Save and unlock method
Try now and hit like if it works [emoticon:c4563cd7d5574777a71c318021cbbcc8]
