Wednesday, 17 August 2016

Working with Property Sets in Siebel

Hello All,

Siebel property set are indispensable when it comes to format data in hierarchical formats. Recently I had some requirement wherein I had to return output in hierarchical format.
The exact requirements was we have queried multiple SR's and return the result in a hierarchy.

so to format data i used Property Sets to convert  output data in required format

Format 1: 
  PropertySet [
 <?xml version="1.0" encoding="UTF-8"?>
 <?Siebel-Property-Set EscapeNames="true"?>
 <PropertySet>
 <SR1>
          <SRNumber>1-23245</SRNumber>
          <Status>Closed</Status>
          <Error></Error>
 </SR1>
 <SR2>
         <SRNumber>1-456386</SRNumber>
          <Status>Open</Status>
          <Error></Error>                                                                            
 </SR2>
 </PropertySet>]            

in this format Attributes appear as Separate Tags under parent SR tag.

Format 2: 
  PropertySet [
 <?xml version="1.0" encoding="UTF-8"?>
 <?Siebel-Property-Set EscapeNames="true"?>
 <PropertySet>
 <SR1 SRNumber="1-23245" Status="Closed" Error=""></SR1>
<SR2 SRNumber="1-23245" Status="Closed" Error=""></SR2>               
 </PropertySet>]            

in this format Attributes appear witin parent SR tag.

Depending on the requirement below code can be used to format the output.

Sample Code for Format 1:
  for(var x = 1; x <= NumberOfSR; x++)
{
     var outPropset = TheApplication().NewPropertySet() ;
     var outPropset1 = TheApplication().NewPropertySet() ;
     var outPropset2 = TheApplication().NewPropertySet() ;
     var outPropset3 = TheApplication().NewPropertySet() ;
       // oOutputs contains values of Multiple SR's,
    SR = oOutputs.GetProperty('SR '+x);
    var pInputs = TheApplication().NewPropertySet();
    var pOutputs = TheApplication().NewPropertySet();
    pInputs.SetProperty("ProcessName", "Process SR Workflow");
    pInputs.SetProperty("Object Id", SR);
    pService.InvokeMethod("RunProcess", pInputs, pOutputs);
    var SR = oOutputs.GetProperty("SRNumber");
    var Status = oOutputs.GetProperty("Status LIC");
    var Error = oOutputs.GetProperty("Error Code");

     outPropset.SetType('SR'+x) ;
   outPropset1.SetType("SRNumber") ;
   outPropset2.SetType("Status");
   outPropset3.SetType("Error");

   outPropset1.SetValue(SR) ;
   outPropset2.SetValue(Status) ;
   outPropset3.SetValue(Error) ;

   outPropset.AddChild(outPropset1) ;
   outPropset.AddChild(outPropset2) ;
   outPropset.AddChild(outPropset3) ;

   Outputs.AddChild(outPropset);  

}
   // After looping if you want to convert Property set to XML use XML Converter Business Service

Sample Code for Format 2:
 // Declaration same as above
    {
   outPropset.SetType('SR'+x) ;
 outPropset.SetProperty("SRNumber", SR);
 outPropset.SetProperty("Status", Status);
 outPropset.SetProperty("Error", Error);
 Outputs.AddChild(outPropset);

}
   // After looping if you want to convert Property set to XML use XML Converter Business Service 
various methods that can be used with Property sets are.
  • AddChild
  • SetType
  • SetProperty
  • GetProperty
  • SetValue


76 comments:

  1. I read that Post and got it fine and informative. Please share more like that... Affinity at Serangoon

    ReplyDelete
  2. Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work! Assertiveness Training Melbourne

    ReplyDelete
  3. Some people assess the potential income from a property by performing a series of complicated calculations and arriving at this Yield percentage, they already know their personal limits and may accept an 11% Yield but reject a 10% Yield.Land Clearing in Virginia

    ReplyDelete
  4. Our first mortgage and equity line balances we can simply pull from the post sale balance on the finance tab. We format each line in green to show that it is being pulled from another worksheet.Viking , Wolf, Dacor Stove & Range Repair Near Me

    ReplyDelete
  5. Costa Del Sol Property For Sale You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this...

    ReplyDelete
  6. Hi there, I discovered your blog per Google bit searching for such kinda educational advise moreover your inform beholds very remarkable for me. HMO properties

    ReplyDelete
  7. Maybe one of the most helpful employments of a property examination in a domain settlement, be that as it may, is that it removes all the feeling from the appraisal procedure and expels the chance of theory with respect to every beneficiary.bcpa

    ReplyDelete
  8. Legal charges: These are usually alluded to as rates and assessments. These will include matters, for example, water rates, land charge, chamber rates, https://yes-mallorca-property.com

    ReplyDelete
  9. Look for the location of public transport and its potential to enhance your property function. Many businesses need stable and frequent public transport to help employees access their jobs. townhouses for sale in burlignton

    ReplyDelete
  10. A lot of valuable information can be derived from the post. we provide real estate belize at affordable charges. to know more visit our website.

    ReplyDelete
  11. It is fine, nonetheless evaluate the information and facts around this correct. https://yes-mallorca-property.com/information/faq/general-issues/

    ReplyDelete
  12. offers many programs from relaxing spas to extreme sports. In the case of the men, we all know they never grow up - in many ways it doesn't matter how old they are, so we just let them play! They can be soldiers and play real to life war games with mock machine guns with Airsoft or Paintball. budapest rental

    ReplyDelete
  13. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. click here

    ReplyDelete
  14. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. poker ace 99

    ReplyDelete
  15. I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. https://157.230.38.54/

    ReplyDelete
  16. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. dewaqq

    ReplyDelete
  17. Proper triple bunk beds feature three separate beds, one stacked on top of another. Parents may consider these somewhat extreme as they are so high off the floor, but with proper safety precautions such as guard rails (these should be used with any bunk bed) the risk is greatly decreased. Another thing to keep in mind is that hot air rises, translating to what can be uncomfortably warm temperatures at the top of bunk beds bed with slide

    ReplyDelete
  18. I felt exceptionally cheerful while perusing this site. This was truly extremely instructive site for me. I truly enjoyed it. This was truly a sincere post. Much obliged!. situs pkv games (20%)

    ReplyDelete
  19. This is the reason the most widely recognized Buy To Let contract is worked out on a factor of 130%, the Lender anticipates Voids and accidental expenses and is working in a basic protect for their monetary presentation to you.Robb Leece

    ReplyDelete
  20. I recently found many useful information in your website especially this blog page. Among the lots of comments on your articles. Thanks for sharing. domino 102

    ReplyDelete
  21. This is just the information I am finding everywhere. Thanks for your blog, I just subscribe your blog. This is a nice blog.. bandarq

    ReplyDelete
  22. If you are looking for more information about flat rate locksmith Las Vegas check that right away. Agen Pkv Games

    ReplyDelete
  23. This particular papers fabulous, and My spouse and i enjoy each of the perform that you have placed into this. I’m sure that you will be making a really useful place. I has been additionally pleased. Good perform! Poker88

    ReplyDelete
  24. In the event that any easements or encumbrances exist across the property for power, at that point look to comprehend the rights and commitments that these archives make on the property proprietor.Lyford Cay Real Estate

    ReplyDelete
  25. Thank you very much for this useful article. I like it. Sobha windsor price

    ReplyDelete
  26. The term real estate covers private lodging, business workplaces and exchanging spaces like theaters, inns and eateries, retail outlets, mechanical structures like manufacturing plants and government structures. Haitch Convey

    ReplyDelete
  27. Foreign Investment Real Property Tax Act "FIRPTA" retaining and retaining exemptions.
    Haitch Convey

    ReplyDelete
  28. Decent article, your article has everything which I want. You have given a piece of useful information about the real estate.
    menlo park real estate listings
    .Excellent post. .

    ReplyDelete
  29. While the life of a mattress depends on it's material and how well it was manufactured, if you answered "yes" to Question 1, then chances that its time to start looking for a replacement. truck mattress

    ReplyDelete
  30. I think this is a standout amongst the most critical data for me. What"s more, i"m happy perusing your article. Be that as it may, ought to comment on some broad things immobilienmakler mülheim an der ruhr

    ReplyDelete
  31. This is a smart blog. I mean it. You have so much knowledge about this issue, and so much passion. You also know how to make people rally behind it, obviously from the responses. immobilienmakler mülheim

    ReplyDelete
  32. The FIRPTA Affidavit is a document that the seller fills out to certify that he or she is not an international seller under penalty of perjury. The escrow firm or brokers interested in the underlying transaction are typically in charge of facilitating signatures. You will learn more about this by visiting the website of Freedom Tax Accounting.

    ReplyDelete
  33. Interesting post. I Have Been wondering about this issue, so thanks for posting. Pretty cool post.It 's really very nice and Useful post.Thanks Property for sale in France

    ReplyDelete
  34. One real estate professional was in a home, garden and hardware store a few calendar weeks ago and went past a couple of guys in an aisle. A conversation was heard while he walked by, I overheard one state, "That is the real estate man". Now I had never known either of those men and have no idea who they are but that experience lets me acknowledge that I must be doing my business at letting the world to recognize my business is buying real estate in that area. There are many ways to let the area know that you are in the real estate investing profession and getting information out there that helps people realize you buy foreclosures, distressed real estate, do real estate short sales and have got a lot of real estate information and experience to flip properties. Some methods are cheap and some are more expensive. You are going to have to attempt many things and acquire a feel for what brings about for you the best results in your region to get the calls you require to transact real estate deals. I have tried many forms of marketing methods for real estate commercial enterprises of all varieties and have come back to a few that consistently create enough leads for me to purchase the 2 or 3 real estate holdings and houses I want to purchase every single calendar month. houses for sale in carlsbad ca

    ReplyDelete
  35. One real estate professional was in a home, garden and hardware store a few calendar weeks ago and went past a couple of guys in an aisle. A conversation was heard while he walked by, I overheard one state, "That is the real estate man". Now I had never known either of those men and have no idea who they are but that experience lets me acknowledge that I must be doing my business at letting the world to recognize my business is buying real estate in that area. There are many ways to let the area know that you are in the real estate investing profession and getting information out there that helps people realize you buy foreclosures, distressed real estate, do real estate short sales and have got a lot of real estate information and experience to flip properties. Some methods are cheap and some are more expensive. You are going to have to attempt many things and acquire a feel for what brings about for you the best results in your region to get the calls you require to transact real estate deals. I have tried many forms of marketing methods for real estate commercial enterprises of all varieties and have come back to a few that consistently create enough leads for me to purchase the 2 or 3 real estate holdings and houses I want to purchase every single calendar month. echinacea premium

    ReplyDelete
  36. Wonderful article. Fascinating to read. I love to read such an excellent article. Thanks! It has made my task more and extra easy. Keep rocking. Geosem Apartments

    ReplyDelete
  37. Property Digger is a search engine for property listings throughout the Arab Emirates. apartments in dubai silicon oasis

    ReplyDelete
  38. It is truly a well-researched content and excellent wording. I got so engaged in this material that I couldn’t wait to read. I am impressed with your work and skill. Thanks. Comox Valley home for sale

    ReplyDelete
  39. You make so many great points here that I read your article a couple of times. Your views are in accordance with my own for the most part. This is great content for your readers. Santa Rosalia Crystal Lagoons

    ReplyDelete
  40. I have recently started a blog, the info you provide on this site has helped me greatly. Thanks for all of your time & work. Gibraltar estate agency

    ReplyDelete
  41. There are plenty of dissertation web sites over the internet while you obtain not surprisingly detailed in the webpage. gibraltar property for sale

    ReplyDelete
  42. With these projections set up, we can start to bits together the pay proclamation and the asset report. Tree Removal Stockton

    ReplyDelete
  43. The inhabitance rate will gauge how well we keep the property leased (95% inhabitance will imply that there may be around 18 days that the property will go un-leased between inhabitants every year). nova city islamabad

    ReplyDelete
  44. Trees also help control soil erosion, thus, preventing floods during the rainy days. However, there are unavoidable instances where you need tree services to have the trees around your home removed. Tree Removal Garden Grove

    ReplyDelete
  45. The biggest reasons, of course, surround the need to change the look of your yard and might involve the moving instead of the removal of that giant. Tree Trimming team Long Beach

    ReplyDelete
  46. The majority of this is illustrated in the book, written in the 1970's designated, "American and Australian Cultural Differences".
    https://www.skymarketing.com.pk/rawalpindi/university-town/

    ReplyDelete
  47. This is highly informatics, crisp and clear. I think that everything has been described in systematic manner so that reader could get maximum information and learn many things. phuket property

    ReplyDelete
  48. I read the above article and I got some knowledge from your article. It's actually great and useful data for us. Thanks for share it. house clearance cornwall

    ReplyDelete
  49. Tajarat strives to be Pakistan's biggest real estate developer ever, guaranteeing the highest international standards, prompt execution, and lifetime customer loyalty. For further detail visit park view city islamabad cda

    ReplyDelete
  50. You will visit a portion of their past projects, to see direct their quality and emotional thoughts. home builders melbourne

    ReplyDelete
  51. Arranging is to a greater extent a need assuming you need to sell your home for the most cash conceivable in the briefest measure of time. Insulation Company Tampa

    ReplyDelete
  52. I just couldn't leave your website before telling you that I truly enjoyed the top quality info you present to your visitors? Will be back again frequently to check up on new posts. property developer

    ReplyDelete
  53. Fantastic blog! Do you have any tips and hints for aspiring writers? I’m planning to start my own website soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many options out there that I’m completely overwhelmed .. Any suggestions? Many thanks! get more info here

    ReplyDelete
  54. Superbly written article, if only all bloggers offered the same content as you, the internet would be a far better place.. https://www.smore.com/yxsec

    ReplyDelete
  55. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. La Manga Club Property For Sale

    ReplyDelete
  56. No doubt this is an excellent post I got a lot of knowledge after reading good luck. Theme of blog is excellent there is almost everything to read, Brilliant post. La Manga Club Property

    ReplyDelete
  57. I want to say thank you for your wonderful read! I absolutely loved every piece of it. I've bookmarked your website to go through your latest posts. hr services in pakistan

    ReplyDelete
  58. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. Santa Rosalia Lake & Life Resort

    ReplyDelete
  59. This is a smart blog. I mean it. You have so much knowledge about this issue, and so much passion. You also know how to make people rally behind it, obviously from the responses. Santa Rosalia Lake & Life Resort

    ReplyDelete
  60. Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post with people.. Property for sale in France

    ReplyDelete
  61. The primary service of real estate agents is to help their clients with the complicated process of buying or selling homes. They mainly act as a mediator between the buyer and seller. However, a licensed real estate agent often provides many other services.  New lenox IL realtors

    ReplyDelete
  62. Admiring the time and effort you put into your blog and detailed information you offer!.. Property for sale in France

    ReplyDelete
  63. What a well written and compassionate article. I found your ideas and wisdom encouraging and helpful.shops for sale in islamabad

    ReplyDelete
  64. This is very educational content and written well for a change. It's nice to see that some people still understand how to write a quality post.! Property for sale in France

    ReplyDelete
  65. You’ve got some interesting points in this article. I would have never considered any of these if I didn’t come across this. Thanks!. Las Colinas Property For Sale

    ReplyDelete
  66. You made such an interesting piece to read, giving every subject enlightenment for us to gain knowledge. Thanks for sharing the such information with us to read this... Property for sale in France

    ReplyDelete
  67. This type of message always inspiring and I prefer to read quality content, so happy to find good place to many here in the post, the writing is just great, thanks for the post. burbank houses for sale

    ReplyDelete
  68. Really a great addition. I have read this marvelous post. Thanks for sharing information about it. I really like that. Thanks so lot for your convene. Property for sale in France

    ReplyDelete
  69. Thank you ever so for you post. Really looking forward to read more.
    broker for commercial property loan

    ReplyDelete
  70. Excellent read, I just passed this onto a friend who was doing some research on that. I will learn a lot of new stuff right here! Best of luck for the next! Please visit my web whatsmyhousevalue.co.nz. Best house value estimate nz service provider.

    ReplyDelete
  71. There are many ways to let the area know that you are in the real estate investing profession and getting information out there that helps people realize you buy foreclosures, distressed real estate, do real estate short sales and have got a lot of real estate information and experience to flip properties. Some methods are cheap and some are more expensive.mykonos villas for sale

    ReplyDelete
  72. I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post. how to buy a house in indiana

    ReplyDelete
  73. I'm glad I found this web site, I couldn't find any knowledge on this matter prior to.Also operate a site and if you are ever interested in doing some visitor writing for me if possible feel free to let me know, im always look for people to check out my web site. Real Estate Charlotte North Carolina and surrounding areas

    ReplyDelete
  74. Assuming these individuals feel better about the property when they visit it or use it, then, at that point, you are well headed to great property execution.
    brian betsy london square

    ReplyDelete