Xavier Zwirtz xavierzwirtz
xavierzwirtz
/ gist:00186e42eb314dbec7b1
Created
June 13, 2015 21:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use ts95pro; | |
| GO | |
| SELECT | |
| obj.name AS trigger_name | |
| ,USER_NAME(obj.uid) AS trigger_owner | |
| ,s.name AS table_schema | |
| ,comments.text AS text | |
| ,OBJECT_NAME(parent_obj) AS table_name | |
| ,OBJECTPROPERTY( obj.id, 'ExecIsUpdateTrigger') AS isupdate |
xavierzwirtz
/ gist:bd3f56f8753765ca2bd3
Created
June 13, 2015 21:24
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use ts95pro; | |
| GO | |
| SELECT | |
| obj.name AS trigger_name | |
| ,USER_NAME(obj.uid) AS trigger_owner | |
| ,s.name AS table_schema | |
| ,comments.text AS text | |
| ,OBJECT_NAME(parent_obj) AS table_name | |
| ,OBJECTPROPERTY( obj.id, 'ExecIsUpdateTrigger') AS isupdate |
xavierzwirtz
/ gist:963b5ac8267bb4e24841
Created
June 13, 2015 21:54
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select * from information_schema.columns where table_name in ('bdcarts', 'bdtriggerauditbdcarts') | |
| order by table_name, ordinal_position |
xavierzwirtz
/ gist:811265b1621cfc7d0c73
Created
June 23, 2015 20:56
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1935099-po-edit-vendno-blanking | |
| 4138599-OrderEntry-Missing-RequiredPO-Validator | |
| 4343470-ForgotPasswordRequest-Update-To-Secure-Standards | |
| 6173840 Obj Ref error on WebContext.get_CurrentCustomer | |
| 6268109-change-template-on-print | |
| 6293691 - Google product feed not handing web price (rounding error) | |
| 6341457-OrderEntry-AddCustomer-Via-OrderInfo | |
| 6395297 JobMaster Error Releasing On Hold Orders | |
| 6467260 Post Credit Memo should handle Serial / Lot Master not existing | |
| 6523098 Verify handling of dim weight items with US Post Office |
xavierzwirtz
/ gist:7bb6342a57ba78edf609
Created
July 9, 2015 21:55
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 6165310 Import Items from Canopy | |
| 6235929 Convert consolodation to create sales orders instead of the XML file | |
| 6269483-checkout-settings | |
| 6352647 Create process to calculate weekly sales and store in Customer Item fields | |
| 6378399-myaccount-settings | |
| 6408959-PFG-Transmission-File | |
| 6540833 Add Marel Consolidation process to Web | |
| 6540852 Add Permissions Import to the web | |
| 6563590 Add Field Import to the Web | |
| 6566070-Order-Has-Comments-Trigger |
xavierzwirtz
/ gist:7b1753d9ee24c9085099
Created
July 13, 2015 18:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{ | |
| "Item_No": "SG800-4030", | |
| "ShortDescription": "This is a Bottom Bracket Kit W/ Bolts", | |
| "LongDescription": "Here are excruciating details about the Bottom Bracket Kit W/ Bolts and \n newlines", | |
| "Price": "43.29", | |
| "UOM": "EA", | |
| "OriginalPicture": "www.example.com/diagram_SG800-7080.png", | |
| "Fields": { | |
| "bubble_number": "13", |
xavierzwirtz
/ gist:fbd9239dc5d10306b6fa
Created
July 29, 2015 21:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{ | |
| "Description": "E-TC9124, 220V 10A, UNIV BASE", | |
| "SiteItem_No": "9-9124-MUNBP0", | |
| "Vendor_Item_No": "9-9124-MUNBP0", | |
| "Vendor_Url": "https://support.startrac.com/Products/Diagram.aspx?sku=9-9132-MOCEP0", | |
| "Vendor_No": 149, | |
| "Competitor_ID": 149, | |
| "Fields": { | |
| "bubble_number": "2", | |
| "diagram": "/documents/relpdf/9-9124-MUNBP0A.pdf#pagemode=none&toolbar=0&statusbar=0&messages=0&navpanes=0", |
xavierzwirtz
/ gist:b80b74122b15f86eb809
Created
August 7, 2015 19:06
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| POS Sales 2013-2015 | |
| 11/15/2013 to | |
| 8/6/2015 | |
| Friday, November 15, 2013 | |
| Quantity Value | |
| -------------------------------------------------- | |
| .................................................. | |
| CABLE 70 | |
| Monday, January 6, 2014 |
xavierzwirtz
/ gist:209148936a7f0b62b2b0
Last active
August 29, 2015 14:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| POS Sales 11/15/2013 to 8/6/2015 | |
| Friday, November 15, 2013 | |
| Quantity Value | |
| -------------------------------------------------- | |
| Location: AK | |
| Seller #400 | |
| Jessica Darling | |
| .................................................. |
xavierzwirtz
/ gist:ebe53093b41a14717293
Created
August 12, 2015 18:57
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{ | |
| "Description": "E-TC9124, 220V 10A, UNIV BASE", | |
| "SiteItem_No": "9-9124-MUNBP0", | |
| "Vendor_Item_No": "9-9124-MUNBP0", | |
| "Vendor_Url": "https://support.startrac.com/Products/Diagram.aspx?sku=9-9132-MOCEP0", | |
| "Vendor_No": 149, | |
| "Competitor_ID": 149, | |
| "ItemToNodeFields": { | |
| "exploded_diagram_reference_numbers": "56" | |
| }, |