{"id":2630,"date":"2011-01-11T15:40:27","date_gmt":"2011-01-11T23:40:27","guid":{"rendered":"http:\/\/www.sapien.com\/blog\/2011\/01\/11\/feature-peek-2011-primalsql-exporting-powershell-guis\/"},"modified":"2011-01-11T15:40:27","modified_gmt":"2011-01-11T23:40:27","slug":"feature-peek-2011-primalsql-exporting-powershell-guis","status":"publish","type":"post","link":"https:\/\/dev.sapien.com\/blog\/2011\/01\/11\/feature-peek-2011-primalsql-exporting-powershell-guis\/","title":{"rendered":"Feature Peek 2011: PrimalSQL &#8211; Exporting PowerShell GUIs"},"content":{"rendered":"<p>Similar to PrimalForms 2011, PrimalSQL 2011 will allow you to export PowerShell GUI scripts that run your queries.<\/p>\n<p>Simply design your query in PrimalSQL\u2019s Query builder and press the \u201cExport Query Form\u201d button.<\/p>\n<p><a href=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2011\/01\/Export-Query-Form.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px\" title=\"Export Query Form\" border=\"0\" alt=\"Export Query Form\" src=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2011\/01\/Export-Query-Form_thumb.png\" width=\"244\" height=\"180\" \/><\/a><\/p>\n<p>(Fig 1: Export the Query into a PowerShell GUI)<\/p>\n<p>PrimalSQL 2011 will then generate a PowerShell script (ps1) or a PrimalForms Form (pff)&#160; depending on the option you select.<\/p>\n<p><a href=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2011\/01\/Select-Form-Type.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px\" title=\"Select Form Type\" border=\"0\" alt=\"Select Form Type\" src=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2011\/01\/Select-Form-Type_thumb.png\" width=\"244\" height=\"180\" \/><\/a><\/p>\n<p>(Fig 2: Select PS1 Script or PrimalForms File)<\/p>\n<p>And finally you can edit and run the script in your favorite PowerShell editor:<\/p>\n<p><a href=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2011\/01\/Running-Query-Form.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; border-bottom: 0px; border-left: 0px; padding-left: 0px; padding-right: 0px; display: inline; border-top: 0px; border-right: 0px; padding-top: 0px\" title=\"Running Query Form\" border=\"0\" alt=\"Running Query Form\" src=\"http:\/\/www.sapien.com\/blog\/wp-content\/uploads\/2011\/01\/Running-Query-Form_thumb.png\" width=\"244\" height=\"184\" \/><\/a><\/p>\n<p>(Fig 2: Running the PowerShell Query GUI in PrimalForms 2011)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Similar to PrimalForms 2011, PrimalSQL 2011 will allow you to export PowerShell GUI scripts that run your queries. Simply design your query in PrimalSQL\u2019s Query builder and press the \u201cExport Query Form\u201d button. (Fig 1: Export the Query into a PowerShell GUI) PrimalSQL 2011 will then generate a PowerShell script (ps1) or a PrimalForms Form [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[582,575,325,21,25],"tags":[564,28,314,1004,38],"class_list":["post-2630","post","type-post","status-publish","format-standard","hentry","category-feature-peek","category-primalforms-2011-software-news","category-primalsql","category-software-news","category-windows-powershell","tag-564","tag-powershell","tag-primalforms","tag-primalsql","tag-sql"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/2630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/comments?post=2630"}],"version-history":[{"count":0,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/posts\/2630\/revisions"}],"wp:attachment":[{"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/media?parent=2630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/categories?post=2630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.sapien.com\/blog\/wp-json\/wp\/v2\/tags?post=2630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}