{"id":5891,"date":"2020-01-14T11:26:35","date_gmt":"2020-01-14T16:26:35","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=5891"},"modified":"2020-01-14T11:26:35","modified_gmt":"2020-01-14T16:26:35","slug":"metasolv-solutions-service-request-search-status-buttons","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=5891","title":{"rendered":"MetaSolv Solutions Service Request Search Status Buttons"},"content":{"rendered":"<p>I\u2019m working on a project to automate the creation of work orders in MetaSolv \u2013 it was going well until I tried to <em>find<\/em> one of the work orders I created within the GUI. Aaand \u2026 they don\u2019t show up. Before bothering sys admins with silly questions, I wanted to make sure I wasn\u2019t somehow searching <em>wrong<\/em>. While most of the search dialog is easily correlated to the <a href=\"https:\/\/docs.oracle.com\/communications\/E69835_01\/latest\/doc.63\/e69851\/engineering-work-order-web-service-reference1.htm#MSSWS1248\">API XML input<\/a> (responsible party is responsiblePerson from the XML, work order number is orderNumber, Description is description) \u2026 the little status buttons don\u2019t have convenient tooltips to help decipher their meaning.<\/p>\n<p>Ten minutes perusing the internal training documents yielded \u201cselect them all\u201d which \u2026 yeah, I get. And it was nice to confirm that the \u201cpushed in\u201d button is selected. But that still doesn\u2019t tell me what the little pictures <em>mean<\/em>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"828\" height=\"347\" class=\"wp-image-5892\" src=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/01\/word-image-4.png\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/01\/word-image-4.png 828w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/01\/word-image-4-300x126.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/01\/word-image-4-768x322.png 768w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2020\/01\/word-image-4-500x210.png 500w\" sizes=\"auto, (max-width: 828px) 100vw, 828px\" \/><\/p>\n<p>So I searched the Internet, Oracle\u2019s generally excellent documentation online, the F1 help within the app \u2026 nothing. Either these status values are so obvious to people who regularly use MetaSolv that it\u2019s not worth mentioning or no one knows what these little buttons mean.<\/p>\n<p>Which just made me <em>more<\/em> curious. So I performed a search limited to a single button, got a few work order numbers, and then looked the things up in the database tables. Numbering the buttons from left to right, I now have corresponding service_request_status values for each one:<\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>Button #<\/strong><\/td>\n<td><strong>service_request_status<\/strong><\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>101<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>0<\/td>\n<\/tr>\n<tr>\n<td>4<\/td>\n<td>801<\/td>\n<\/tr>\n<tr>\n<td>5<\/td>\n<td>901<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Fortunately, <a href=\"https:\/\/support.oracle.com\/knowledge\/More%20Applications%20and%20Technologies\/778981_1.html\">the back-end MSS documentation tells me what these status values <em>mean<\/em><\/a>:<\/p>\n<p>0 &#8211; The service request has been entered and the tasks have been successfully generated and distributed to work queues.<\/p>\n<p>1-99 &#8211; The service request is still being entered (tasks have not been generated and distributed to work queues).<\/p>\n<p>101 &#8211; The service request has been electronically received but has not been processed.<\/p>\n<p>801 &#8211; The service request has had its Due Date task completed.<\/p>\n<p>901 &#8211; The service request has had all of its tasks, including billing, completed.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I\u2019m working on a project to automate the creation of work orders in MetaSolv \u2013 it was going well until I tried to find one of the work orders I created within the GUI. Aaand \u2026 they don\u2019t show up. Before bothering sys admins with silly questions, I wanted to make sure I wasn\u2019t somehow &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[889,890,888],"class_list":["post-5891","post","type-post","status-publish","format-standard","hentry","category-technology","tag-metasolv","tag-metasolv-solutions","tag-mss"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/5891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5891"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/5891\/revisions"}],"predecessor-version":[{"id":5893,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/5891\/revisions\/5893"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}