{"id":27193,"date":"2022-04-11T09:00:22","date_gmt":"2022-04-11T04:00:22","guid":{"rendered":"https:\/\/staging.tech-beta.com\/sns2\/?p=27193"},"modified":"2022-04-11T09:00:22","modified_gmt":"2022-04-11T04:00:22","slug":"service-layer-supports-sql-queries","status":"publish","type":"post","link":"https:\/\/global-supernova.com\/ksa\/service-layer-supports-sql-queries\/","title":{"rendered":"Service Layer Supports SQL Queries"},"content":{"rendered":"<p>How many times did you want to create and run a SQL query in the service layer? Now you can!<\/p>\n<p>The Service Layer for both MS SQL and SAP HANA was enhanced with the ability to generate highly flexible SQL Queries and reduce the manual effort to deploy views.<\/p>\n<p>Want to know more? Check out this video for a detailed tutorial and example:<\/p>\n<p><a href=\"https:\/\/www.youtube.com\/watch?v=CNNv4y8mPQc\" target=\"_blank\" rel=\"noopener\">https:\/\/www.youtube.com\/watch?v=CNNv4y8mPQc<\/a><\/p>\n<p>Available in SAP Business One 10.0 FP 2011 and SAP Business One 10.0 FP 2011, version for SAP HANA.<\/p>\n<p>Subscribe to the\u00a0<a href=\"https:\/\/www.youtube.com\/channel\/UCOgUq5yOy1LfTqgMAFdeRyA\" target=\"_blank\" rel=\"noopener\">Official SAP Business One YouTube channel<\/a> and stay informed &#8211; Remember,\u00a0it&#8217;s available for everyone<\/p>\n<p>This tip and all the other tips are available on <a href=\"https:\/\/staging.tech-beta.com\/sns2\/tips-and-tricks\/\" target=\"_blank\" rel=\"nofollow noopener\">SAP Business One Tips by SuperNova Solutions.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>How many times did you want to create and run a SQL query in the service layer? Now you can! The Service Layer for both MS SQL and SAP HANA was enhanced with the ability to generate highly flexible SQL Queries and reduce the manual effort to deploy views. Want to know more? Check out [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[13],"tags":[],"class_list":["post-27193","post","type-post","status-publish","format-standard","hentry","category-sap-business-one-tip-trick"],"acf":[],"_links":{"self":[{"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/posts\/27193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/comments?post=27193"}],"version-history":[{"count":0,"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/posts\/27193\/revisions"}],"wp:attachment":[{"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/media?parent=27193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/categories?post=27193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/global-supernova.com\/ksa\/wp-json\/wp\/v2\/tags?post=27193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}