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
2 REPLIES
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.