Former_Member
9 years agoAccelerator III
Reports stylesheet question
I struggling with the stylesheet to filter so that for each Part in the example below only return EHT_Part Charactheristics.eht_char_value where EHT_Part Charactheristics.eht_char_name equals "Mounting" else empty.
Any suggestions?
Best Regards
Geir Tore Olsen
Using AML studio I do the following AML query:
<Item type='Part' id="5406FA0928544DC68F127D848C6B1FA3" action='GetItemRepeatConfig' select='item_number,name,major_rev,minor_rev,eht_production_lc_state, state, aut_purchase_critical'>
<Relationships>
<Item type='EHT_Part Characteristic' action='get' select='related_id(eht_char_name,eht_char_value)'/>
<Item type='Part AML' select='state,related_id(item_number,manufacturer,aut_rohs,aut_reach,aut_conflict_material)'></Item>
<Item type='Part BOM' select='sort_order,quantity,related_id, reference_designator' repeatProp='related_id' repeatTimes='6'>
<Relationships>
<Item type='BOM Instance' action='get' select='aut_approval_critical,aut_ex_critical,aut_purchase_critical,reference_designator'>
</Item>
</Relationships>
</Item>
</Relationships>
</Item>
I get the result below:
<SOAP-ENV:Envelope
xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../">
<SOAP-ENV:Body>
<Result>
<Item type="Part" typeId="4F1AC04A2B484F3ABA4E20DB63808A88" id="5406FA0928544DC68F127D848C6B1FA3">
<aut_purchase_critical>no</aut_purchase_critical>
<eht_production_lc_state>Prototype</eht_production_lc_state>
<id keyed_name="116-9212-413.1003 3 2 Electromechanical Components BSA-400A Basic Assembled PCB" type="Part">5406FA0928544DC68F127D848C6B1FA3</id>
<state>Released</state>
<item_number>116-9212-413.1003</item_number>
<major_rev>3</major_rev>
<minor_rev>2</minor_rev>
<name>BSA-400A Basic Assembled PCB</name>
<itemtype>4F1AC04A2B484F3ABA4E20DB63808A88</itemtype>
<Relationships>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="0432E4500423417B9AE081EED9A975DC">
<css is_null="1"> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mount Option</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value is_null="1" />
<eht_defn_source>AUT_AFS_Mount_Opt</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="0432E4500423417B9AE081EED9A975DC" type="EHT_Part Characteristic">0432E4500423417B9AE081EED9A975DC</id>
<related_id is_null="1" />
<source_id keyed_name="116-9212-413.1003 3 2 Electromechanical Components BSA-400A Basic Assembled PCB" type="Part">5406FA0928544DC68F127D848C6B1FA3</source_id>
</Item>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="466280BFD6C54F899CC3552F0B6E6220">
<css is_null="1"> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mounting</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value is_null="1" />
<eht_defn_source>AUT_AFS_Mounting</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="466280BFD6C54F899CC3552F0B6E6220" type="EHT_Part Characteristic">466280BFD6C54F899CC3552F0B6E6220</id>
<related_id is_null="1" />
<source_id keyed_name="116-9212-413.1003 3 2 Electromechanical Components BSA-400A Basic Assembled PCB" type="Part">5406FA0928544DC68F127D848C6B1FA3</source_id>
</Item>
<Item type="Part BOM" typeId="5E9C5A12CC58413A8670CF4003C57848" id="D6178007AD0B4FCFBB478260F51E5172">
<id keyed_name="D6178007AD0B4FCFBB478260F51E5172" type="Part BOM">D6178007AD0B4FCFBB478260F51E5172</id>
<quantity>45</quantity>
<reference_designator>C1-6,C8-10,C16,C36-38,C46-51,C82,C153-156,C158,C167-168,C330,C381-397</reference_designator>
<related_id keyed_name="116-8227-100.4410 1 1 Passive Electronic Components CAP CER SMD 10UF/X7R/0805/10V/10%" type="Part">
<Item type="Part" typeId="4F1AC04A2B484F3ABA4E20DB63808A88" id="EB794AF7D6874A228041EFF2DEDDDC2A">
<aut_purchase_critical is_null="1" />
<eht_production_lc_state>Approved</eht_production_lc_state>
<id keyed_name="116-8227-100.4410 1 1 Passive Electronic Components CAP CER SMD 10UF/X7R/0805/10V/10%" type="Part">EB794AF7D6874A228041EFF2DEDDDC2A</id>
<state>Released</state>
<item_number>116-8227-100.4410</item_number>
<major_rev>1</major_rev>
<minor_rev>1</minor_rev>
<name>CAP CER SMD 10UF/X7R/0805/10V/10%</name>
<itemtype>4F1AC04A2B484F3ABA4E20DB63808A88</itemtype>
<Relationships>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="4AD0B52C09614EC8A4548194DF5EE664">
<css> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mounting</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value>SMD</eht_char_value>
<eht_defn_source>AUT_AFS_Mounting</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="4AD0B52C09614EC8A4548194DF5EE664" type="EHT_Part Characteristic">4AD0B52C09614EC8A4548194DF5EE664</id>
<related_id is_null="1" />
<source_id keyed_name="116-8227-100.4410 1 1 Passive Electronic Components CAP CER SMD 10UF/X7R/0805/10V/10%" type="Part">EB794AF7D6874A228041EFF2DEDDDC2A</source_id>
</Item>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="17C5CDE213C14C5EB4FC8CA2F0DB88C7">
<css is_null="1"> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mount Option</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value is_null="1" />
<eht_defn_source>AUT_AFS_Mount_Opt</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="17C5CDE213C14C5EB4FC8CA2F0DB88C7" type="EHT_Part Characteristic">17C5CDE213C14C5EB4FC8CA2F0DB88C7</id>
<related_id is_null="1" />
<source_id keyed_name="116-8227-100.4410 1 1 Passive Electronic Components CAP CER SMD 10UF/X7R/0805/10V/10%" type="Part">EB794AF7D6874A228041EFF2DEDDDC2A</source_id>
</Item>
<Item type="Part AML" typeId="332F11B553BA4CCC892201C1FA51F056" id="86EF70E6A74C44C3BCE0E949C8294EBF">
<id keyed_name="86EF70E6A74C44C3BCE0E949C8294EBF" type="Part AML">86EF70E6A74C44C3BCE0E949C8294EBF</id>
<related_id keyed_name="LMK212AB7106KG-T LMK212AB7106KG-T" type="Manufacturer Part">
<Item type="Manufacturer Part" typeId="FDE9DA6F52C642EA807287C340EE0B72" id="C49265E3821449B79FBA7B161C8D6EBB">
<aut_conflict_material is_null="1" />
<aut_reach>Yes</aut_reach>
<aut_rohs>Yes</aut_rohs>
<id keyed_name="LMK212AB7106KG-T LMK212AB7106KG-T" type="Manufacturer Part">C49265E3821449B79FBA7B161C8D6EBB</id>
<manufacturer keyed_name="TAIYO YUDEN CO LTD" type="Manufacturer">2A01BBE1F897459187E2279E14F58231</manufacturer>
<item_number>LMK212AB7106KG-T</item_number>
<itemtype>FDE9DA6F52C642EA807287C340EE0B72</itemtype>
</Item>
</related_id>
<source_id keyed_name="116-8227-100.4410 1 1 Passive Electronic Components CAP CER SMD 10UF/X7R/0805/10V/10%" type="Part">EB794AF7D6874A228041EFF2DEDDDC2A</source_id>
<state>Approved</state>
</Item>
</Relationships>
<eht_attributes></eht_attributes>
</Item>
</related_id>
<sort_order>128</sort_order>
<source_id keyed_name="116-9212-413.1003 3 2 Electromechanical Components BSA-400A Basic Assembled PCB" type="Part">5406FA0928544DC68F127D848C6B1FA3</source_id>
<itemtype>5E9C5A12CC58413A8670CF4003C57848</itemtype>
</Item>
<Item type="Part BOM" typeId="5E9C5A12CC58413A8670CF4003C57848" id="03AD7DC0038C414A8996034455355CA2">
<id keyed_name="03AD7DC0038C414A8996034455355CA2" type="Part BOM">03AD7DC0038C414A8996034455355CA2</id>
<quantity>14</quantity>
<reference_designator>C7,C27-28,C39-42,C53,C93,C108,C163-166</reference_designator>
<related_id keyed_name="116-8227-103.4210 1 1 Passive Electronic Components CAP CER SMD 100NF/X7R/0603/50V/10%" type="Part">
<Item type="Part" typeId="4F1AC04A2B484F3ABA4E20DB63808A88" id="5A3CD0D60E69492E960903E8BEE365A5">
<aut_purchase_critical is_null="1" />
<eht_production_lc_state>Approved</eht_production_lc_state>
<id keyed_name="116-8227-103.4210 1 1 Passive Electronic Components CAP CER SMD 100NF/X7R/0603/50V/10%" type="Part">5A3CD0D60E69492E960903E8BEE365A5</id>
<state>Released</state>
<item_number>116-8227-103.4210</item_number>
<major_rev>1</major_rev>
<minor_rev>1</minor_rev>
<name>CAP CER SMD 100NF/X7R/0603/50V/10%</name>
<itemtype>4F1AC04A2B484F3ABA4E20DB63808A88</itemtype>
<Relationships>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="C972437BA65C4D968F45F7CCE067EA92">
<css> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mounting</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value>SMD</eht_char_value>
<eht_defn_source>AUT_AFS_Mounting</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="C972437BA65C4D968F45F7CCE067EA92" type="EHT_Part Characteristic">C972437BA65C4D968F45F7CCE067EA92</id>
<related_id is_null="1" />
<source_id keyed_name="116-8227-103.4210 1 1 Passive Electronic Components CAP CER SMD 100NF/X7R/0603/50V/10%" type="Part">5A3CD0D60E69492E960903E8BEE365A5</source_id>
</Item>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="66E8554C56404A5088E3EBACAE438170">
<css is_null="1"> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mount Option</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value is_null="1" />
<eht_defn_source>AUT_AFS_Mount_Opt</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="66E8554C56404A5088E3EBACAE438170" type="EHT_Part Characteristic">66E8554C56404A5088E3EBACAE438170</id>
<related_id is_null="1" />
<source_id keyed_name="116-8227-103.4210 1 1 Passive Electronic Components CAP CER SMD 100NF/X7R/0603/50V/10%" type="Part">5A3CD0D60E69492E960903E8BEE365A5</source_id>
</Item>
<Item type="Part AML" typeId="332F11B553BA4CCC892201C1FA51F056" id="889007A477B84E6BB2DC94751407184A">
<id keyed_name="889007A477B84E6BB2DC94751407184A" type="Part AML">889007A477B84E6BB2DC94751407184A</id>
<related_id keyed_name="CC0603KRX7R9BB104 CC0603KRX7R9BB104" type="Manufacturer Part">
<Item type="Manufacturer Part" typeId="FDE9DA6F52C642EA807287C340EE0B72" id="A6EE7F3B3E604D4E87AADE7F19641911">
<aut_conflict_material is_null="1" />
<aut_reach>Yes</aut_reach>
<aut_rohs>Yes</aut_rohs>
<id keyed_name="CC0603KRX7R9BB104 CC0603KRX7R9BB104" type="Manufacturer Part">A6EE7F3B3E604D4E87AADE7F19641911</id>
<manufacturer keyed_name="YAGEO CORP" type="Manufacturer">8598FB625E8246E7A2A52C0A91723168</manufacturer>
<item_number>CC0603KRX7R9BB104</item_number>
<itemtype>FDE9DA6F52C642EA807287C340EE0B72</itemtype>
</Item>
</related_id>
<source_id keyed_name="116-8227-103.4210 1 1 Passive Electronic Components CAP CER SMD 100NF/X7R/0603/50V/10%" type="Part">5A3CD0D60E69492E960903E8BEE365A5</source_id>
<state>Approved</state>
</Item>
</Relationships>
<eht_attributes></eht_attributes>
</Item>
</related_id>
<sort_order>256</sort_order>
<source_id keyed_name="116-9212-413.1003 3 2 Electromechanical Components BSA-400A Basic Assembled PCB" type="Part">5406FA0928544DC68F127D848C6B1FA3</source_id>
<itemtype>5E9C5A12CC58413A8670CF4003C57848</itemtype>
</Item>
<Item type="Part BOM" typeId="5E9C5A12CC58413A8670CF4003C57848" id="49C3F40A0E4C4D6BB285EB5AA483BE7A">
<id keyed_name="49C3F40A0E4C4D6BB285EB5AA483BE7A" type="Part BOM">49C3F40A0E4C4D6BB285EB5AA483BE7A</id>
<quantity>10</quantity>
<reference_designator>C17-26</reference_designator>
<related_id keyed_name="116-8227-099.4310 1 1 Passive Electronic Components CAP CER SMD 1UF/X7R/0603/16V/10%" type="Part">
<Item type="Part" typeId="4F1AC04A2B484F3ABA4E20DB63808A88" id="C9069E8BF4A1486B9FFF4A89F279A92C">
<aut_purchase_critical is_null="1" />
<eht_production_lc_state>Approved</eht_production_lc_state>
<id keyed_name="116-8227-099.4310 1 1 Passive Electronic Components CAP CER SMD 1UF/X7R/0603/16V/10%" type="Part">C9069E8BF4A1486B9FFF4A89F279A92C</id>
<state>Released</state>
<item_number>116-8227-099.4310</item_number>
<major_rev>1</major_rev>
<minor_rev>1</minor_rev>
<name>CAP CER SMD 1UF/X7R/0603/16V/10%</name>
<itemtype>4F1AC04A2B484F3ABA4E20DB63808A88</itemtype>
<Relationships>
<Item type="EHT_Part Characteristic" typeId="56CD05FFFEC048598358D8F38478F54D" id="AF2F5D0ADC7E41BB815E376872E3034B">
<css is_null="1"> .eht_defn_source {background-color:#BFE58F} .eht_char_name {background-color:#BFE58F} .eht_char_value {background-color:#BFE58F} .eht_upper_value {background-color:#FFFFFF} .eht_lower_value {background-color:#FFFFFF} .eht_neg_tolerance {background-color:#FFFFFF} .eht_pos_tolerance {background-color:#FFFFFF}</css>
<eht_char_name>Mount Option</eht_char_name>
<eht_char_type>EnumeratedCharacteristic</eht_char_type>
<eht_char_value is_null="1" />
<eht_defn_source>AUT_AFS_Mount_Opt</eht_defn_source>
<eht_exposeontop>0</eht_exposeontop>
<eht_lower_value is_null="1" />
<eht_neg_tolerance is_null="1" />
<eht_pos_tolerance is_null="1" />
<eht_required>0</eht_required>
<eht_upper_value is_null="1" />
<eht_valueasstored is_null="1" />
<id keyed_name="AF2F5D0ADC7E41BB815E376872E3034B" type="EHT_Part Characteristic">AF2F5D0ADC7E41BB815E376872E3034B</id>
<related_id is_null="1" />
<source_id keyed_name="116-8227-099.4310 1 1 Passive Electronic Components CAP CER SMD 1UF/X7R/0603/16V/10%" type="Part">C9069E8BF4A1486B9FFF4A89F279A92C</source_id>
</item>
<Item type="Part AML" typeId="332F11B553BA4CCC892201C1FA51F056" id="B2160806F5E5429AAB6D887C946369B4">
<id keyed_name="B2160806F5E5429AAB6D887C946369B4" type="Part AML">B2160806F5E5429AAB6D887C946369B4</id>
<related_id keyed_name="EMK107B7105KA-T EMK107B7105KA-T" type="Manufacturer Part">
<Item type="Manufacturer Part" typeId="FDE9DA6F52C642EA807287C340EE0B72" id="18F3EFDC801A421E85AD45C22FC78A13">
<aut_conflict_material is_null="1" />
<aut_reach>Yes</aut_reach>
<aut_rohs>Yes</aut_rohs>
<id keyed_name="EMK107B7105KA-T EMK107B7105KA-T" type="Manufacturer Part">18F3EFDC801A421E85AD45C22FC78A13</id>
<manufacturer keyed_name="TAIYO YUDEN CO LTD" type="Manufacturer">2A01BBE1F897459187E2279E14F58231</manufacturer>
<item_number>EMK107B7105KA-T</item_number>
<itemtype>FDE9DA6F52C642EA807287C340EE0B72</itemtype>
</Item>
</related_id>
<source_id keyed_name="116-8227-099.4310 1 1 Passive Electronic Components CAP CER SMD 1UF/X7R/0603/16V/10%" type="Part">C9069E8BF4A1486B9FFF4A89F279A92C</source_id>
<state>Approved</state>
</Item>
</Relationships>
<eht_attributes></eht_attributes>
</Item>
</related_id>
<sort_order>512</sort_order>
<source_id keyed_name="116-9212-413.1003 3 2 Electromechanical Components BSA-400A Basic Assembled PCB" type="Part">5406FA0928544DC68F127D848C6B1FA3</source_id>
<itemtype>5E9C5A12CC58413A8670CF4003C57848</itemtype>
</Relationships>
</Item>
</Result>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>