Skip to main content
S
smorla11-Garnet
11-Garnet
March 1, 2017
Question

How to view Applied Effectivity for Part under Part Structure Tab?

  • March 1, 2017
  • 2 replies
  • 2298 views

How to view my Service Effectivities [i.e. Serial Numbers, Model Numbers] applied on Parts? under Structure Tab or any layouts? or any DB query to extract Effectivity on Parts?

2 replies

S
sshankaracharya10-Marble
10-Marble
March 2, 2017

You can use CS209206 to build QML report, just you have to change is object type.

S
smorla11-GarnetAuthor
11-Garnet
March 2, 2017

Thanks Shashi..

One question, in the QML query it shows for Date Effectvity. How do i include Serial Number, Model number Object & Column Tags?

"

<column

                    alias="Date Effectivity (wt.effectivity.WTDatedEffectivity)"

                    heading="Eff Type Modifier"

                    propertyName="effTypeModifier" type="wt.eff.EffTypeModifier">effTypeModifier</column>

                <object

                    alias="Date Effectivity (wt.effectivity.WTDatedEffectivity)"

                    heading="Type (type)" propertyName="type">

                    <property name="type"/>

                </object>"

S
sshankaracharya10-Marble
10-Marble
March 3, 2017

Hi Srinivas,

Its possible, since we don't use lot number  / serial numbers and instead only Date Effectivity, i need to check with some parts.

Regards,

Shashi

P
PASI-Consulting1-Visitor
1-Visitor
March 3, 2017

Hi

I think you can create a custom virtual attribute with a specific DataUtility to do so. But you should know that the effectivity is not a value on the part itself but related to the Product it belongs to, except for date effectivity. That means you should implement your specific case in the Utility code if for example you have only one Product instance.

Regards,

Terms & ConditionsCookie settingsAccessibility statement