Creating xml file by passing parameter in runtime

One Star

Creating xml file by passing parameter in runtime

Hi,
Suppose we have following tables (Company,Project,Client Project,Internal Project,Project Details,Manager,Employee Details).Those tables have parent child relationship.
Company --> Project --> Client Project --> Project Details --> Manager --> Employee Details    
Will give the employee details for client projects.
Company --> Project --> Internal Project --> Project Details --> Manager --> Employee Details
Will give the employee details for Internal projects.
Now if I pass "Project" as parent and "Client Project" as child in runtime.It will invoke  
Project --> Client Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Or if I pass "Project" as parent and "Internal Project" as child in runtime.It will invoke  
Project --> Internal Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Either way if I pass company as parent and project as child in runtime. It will invoke all the information related to client project as well as internal project and store it in a xml file.
I am to pass those parameter (i.e Project, not any value related to project -->Project_id or Project_name etc)  in run time and it will create xml file accordingly.
Thanks
Babul
One Star

Re: Creating xml file by passing parameter in runtime

Hi,
Is there any way ??
Please help me .
Moderator

Re: Creating xml file by passing parameter in runtime

Hi,
Suppose we have following tables (Company,Project,Client Project,Internal Project,Project Details,Manager,Employee Details).Those tables have parent child relationship.
Company --> Project --> Client Project --> Project Details --> Manager --> Employee Details    
Will give the employee details for client projects.
Company --> Project --> Internal Project --> Project Details --> Manager --> Employee Details
Will give the employee details for Internal projects.
Now if I pass "Project" as parent and "Client Project" as child in runtime.It will invoke  
Project --> Client Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Or if I pass "Project" as parent and "Internal Project" as child in runtime.It will invoke  
Project --> Internal Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Either way if I pass company as parent and project as child in runtime. It will invoke all the information related to client project as well as internal project and store it in a xml file.
I am to pass those parameter (i.e Project, not any value related to project -->Project_id or Project_name etc)  in run time and it will create xml file accordingly.

Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.