Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme 

Dispute Data Nested XML Query

Language: Editor: Layout:
View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 4, absolute service time: 0,17 sec 
edit mode |  history
   custno invno reason amount pnote owner
1 117455521-AD 28894882 405 972,04 Dispute Reason: Inbound email from John requesting that account be cancelled, providing letter of cancellation. Attachments: Yes LARRYGIST
2 128623268-AD 28887277 405 182,99 Dispute Reason: Inbound email from Catherine requesting cancelation of services. Attachments: Yes LARRYGIST
3 131537715-AD 28893848 405 185,17 Dispute Reason: Syed stated that he canceled his Tyco contract a long time ago. Syad stated that he doesn't have an email address and didn't want to send CR a cancellation notice. Attachments: No LARRYGIST
4 189063783-AD 28927273 405 777,49 Dispute Reason: Spoke to Grant stated moved out of building on 12 01 2017. Stated company that bought building decided not to go with Tyco and Tyco came and picked up the equipment. Attachments: No LARRYGIST
   XML_F52E2B61-18A1-11d1-B105-00805F49916B
1 <GPAutoActions><createDispute><transaction><defaultKey xmlns=""><custno>117455521-AD</custno><invno>28894882</invno></defaultKey></transaction><reason>405</reason><amount>972.04</amount><pnote>Dispute Reason: Inbound email from John requesting that account be cancelled, providing letter of cancellation. Attachments: Yes</pnote><owner>LARRYGIST</owner></createDispute><createDispute><transaction><defaultKey xmlns=""><custno>128623268-AD</custno><invno>28887277</invno></defaultKey></transaction><reason>405</reason><amount>182.99</amount><pnote>Dispute Reason: Inbound email from Catherine requesting cancelation of services. Attachments: Yes</pnote><owner>LARRYGIST</owner></createDispute><createDispute><transaction><defaultKey xmlns=""><custno>131537715-AD</custno><invno>28893848</invno></defaultKey></transaction><reason>405</reason><amount>185.17</amount><pnote>Dispute Reason: Syed stated that he canceled his Tyco contract a long time ago. Syad stated that he doesn't have an email address and didn't want to send CR a cancellation notice. Attachments: No</pnote><owner>LARRYGIST</owner></createDispute><createDispute><transaction><defaultKey xmlns=""><custno>189063783-AD</custno><invno>28927273</invno></defaultKey></transaction><reason>405</reason><amount>777.49</amount><pnote>Dispute Reason: Spoke to Grant stated moved out of building on 12 01 2017. Stated company that bought building decided not to go with Tyco and Tyco came and picked up the equipment. Attachments: No</pnote><owner>LARRYGIST</owner></createDispute></GPAutoActions>