cancel
Showing results for 
Search instead for 
Did you mean: 

get parent ID using Report Builder

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hi

Using Report Builder

For a given child , Pl help on how to get its immediate Parent Item ID.

 

I am looking for the Syntax to extract the Parent Item ID

 

Regards

Vamsi Krishna

 

 

 

 

 

7 REPLIES

Re: get parent ID using Report Builder

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Hi Vamsi,

 

Try 'ps_parents' if you are dealing at item level.

 

Harish

Re: get parent ID using Report Builder

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hi Harish

Thanks , If can you pl help with Full Syntax

For a given BOM Line , we want to get parent Item ID

 

Is there any document for xsl compilation , that also will help

 

Thanks

Vamsi Krishna

Re: get parent ID using Report Builder

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Hi Vamsi,

 

 

I think the 'parentref' within the plmxml file (I assumed you are dealing with plmxml file) might help.

This would require multiple passes (you could use apply-template in xsl) on the plmxml file to lookup occurrenceref for each parentref.

 

 

Alternatively, you can develop a python code to parse plmxml for parentref information.

 

Harish

Re: get parent ID using Report Builder

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Thanks Harish

Yes , we are using plmxml , against Item revision

Tried this option parentRef , but exact Syntax is still a confusion

 

 

Regards

Vamsi Krishna

 

Re: get parent ID using Report Builder

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hi

I am able to extract the info by adding "BOM Line Property" to propertyset

Using the same in report Builder

 

Not sure if this is the correct or there is a better method.

Re: get parent ID using Report Builder

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Hi,

 

Yes, BOMLine Property (bl_parent) or occurrence level will help extract the information.

 

I think I misunderstood your question and thought it was about xsl stylesheet and that you are already extracting the parent information in plmxml.

 

Anyhow, glad it worked.

 

Harish

Re: get parent ID using Report Builder

Solution Partner Creator Solution Partner Creator
Solution Partner Creator

Hi

 

Yes included "bl_formatted_parent_name" in the same in xsl Style sheet , thanks

 

- Vamsi