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


85 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. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. It is fine, nonetheless evaluate the information and facts around this correct. https://yes-mallorca-property.com/information/faq/general-issues/

    ReplyDelete
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. If you are looking for more information about flat rate locksmith Las Vegas check that right away. Agen Pkv Games

    ReplyDelete
  22. 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
  23. 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
  24. Thank you very much for this useful article. I like it. Sobha windsor price

    ReplyDelete
  25. 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
  26. Foreign Investment Real Property Tax Act "FIRPTA" retaining and retaining exemptions.
    Haitch Convey

    ReplyDelete
  27. 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
  28. 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
  29. 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
  30. 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
  31. 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
  32. 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
  33. 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
  34. 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
  35. 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
  36. 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
  37. There are plenty of dissertation web sites over the internet while you obtain not surprisingly detailed in the webpage. gibraltar property for sale

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

    ReplyDelete
  39. 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
  40. 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
  41. 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
  42. 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
  43. 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
  44. 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
  45. You will visit a portion of their past projects, to see direct their quality and emotional thoughts. home builders melbourne

    ReplyDelete
  46. 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
  47. 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
  48. 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
  49. 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
  50. 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
  51. 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
  52. 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
  53. 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
  54. 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
  55. 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
  56. 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
  57. 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
  58. 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
  59. 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
  60. Thank you ever so for you post. Really looking forward to read more.
    broker for commercial property loan

    ReplyDelete
  61. 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
  62. 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
  63. 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
  64. The retailer ought to be taught by you in regards to the utilization of the carpet that you mean to buy and the conceivable recurrence of its use
    Sell My House Fast

    ReplyDelete
  65. I read your post and got it quite informative. I couldn't find any knowledge on this matter prior to. I would like to thanks for sharing this article here Ready Mix Terdekat Jakarta

    ReplyDelete
  66. The Freddie Macintosh mortgage-upheld bond is connected to mortgage-supported bonds through Freddie Macintosh. TopRankinMortgages

    ReplyDelete
  67. Since we have set up our time names on the "Property" worksheet, we are prepared to start our projections.
    How to sell your house without a realtor in Pennsylvania

    ReplyDelete
  68. At the gathering, the lawyer will try primer or critical guidance and foster out forward methodology. www.frouharlaw.com/

    ReplyDelete
  69. I recommend that as opposed to selling your home, simply renegotiate it, and utilize the cash from the renegotiate as an up front installment on your next house. Presently, you own two houses and you can simply transform your old home into a rental house. UniformLiving

    ReplyDelete
  70. The main point I would make to you is: research, research, research commercial property.
    https://districtrealty.com/

    ReplyDelete
  71. We should utilize the property estimation that we guage to have the option to compute property charges, so we must form the model in a specific request. Osgoode Properties

    ReplyDelete
  72. As in anything, the quality is in individuals and it is then smart thought, no fundamental, to ask companions and family members, particularly the people who have as of late gone through the cycle, to suggest a mortgage proficient.
    http://toprankinmortgages.com/

    ReplyDelete
  73. Real estate is commonly traded either through an authorized real estate specialist or straight by the proprietor. Complete Real Estate Pros

    ReplyDelete
  74. Buying a home can be a great way to establish roots in a community and build lasting relationships with neighbors. http://www.districtrealty.com

    ReplyDelete
  75. Real estate can provide a sense of stability and security that other investments may not offer. www.realestatelawyerottawa.ca

    ReplyDelete
  76. "Homeownership allows you to personalize your space and create a place that truly feels like home." www.spencerp.net

    ReplyDelete
  77. So you get in the negotiations process. As a hint, when you realize the over pricing phenomenon, you have to understand that this happens when the real estate agent , or seller is aware of the real estate property's value, and he tries his luck in a raising price.I also position a sign in the front yard immediately after purchasing any house. I have purchased several homes in the same regions as a result of marketing this way. Form Follows Efficiency

    ReplyDelete
  78. "Innovative co-living spaces are redefining communal living, and I'm all for it!" estate planning lawyer chandler

    ReplyDelete
  79. I also position a sign in the front yard immediately after purchasing any house. I have purchased several homes in the same regions as a result of marketing this way. suburb reviews

    ReplyDelete
  80. They often have relationships with multiple lenders, giving borrowers more options. toprankinmortgages.com

    ReplyDelete
  81. Consider the demographics of your target tenant market when choosing a rental property. Luxury Property Rental Market in Dubai

    ReplyDelete
  82. I love coming home to a warm shower after a long day. water heater replacement plano

    ReplyDelete
  83. Regular maintenance of your heater ensures it runs efficiently. water heater replacement berkeley

    ReplyDelete
  84. you’re actually a good webmaster. The website loading speed is amazing. It sort of feels that you’re doing any unique trick. Also, The contents are masterpiece. you’ve performed a excellent process on this subject! Dumpster Rental Prices Near Me Detroit

    ReplyDelete

Siebel GoTo View - Handling Realtime cases

 Hello All,  We all must have used GoTo view functionality of siebel to navigate to a particular view from current view. What if the require...