Skip to main content
smorla11-Garnet
11-Garnet
Mar 1, 2017 2:02 PM UTC
Question

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

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?

4 replies

sshankaracharya10-Marble
10-Marble
Mar 2, 2017 4:58 AM UTC

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

Translate
smorla11-GarnetAuthor
11-Garnet
Mar 2, 2017 9:42 AM UTC

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>"

Translate
sshankaracharya10-Marble
10-Marble
Mar 3, 2017 9:25 AM UTC

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

Translate
PASI-Consulting1-Visitor
1-Visitor
Mar 3, 2017 10:19 PM UTC

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,

Translate
Terms & ConditionsAccessibility statement