LJ, Wouldn't that be something like: SELECT description FROM left MINUS SELECT description FROM right
That should give you unique values on left that are not in unique values from right Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ Longwing Sent: Monday, June 08, 2009 3:33 PM To: [email protected] Subject: Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect I would do it slightly different. Left would be a join of Left and Right...the join would be something like SELECT left.description FROM left, right Where left.description not in ( select right.description from right ) And the table on the right would be just a regular display of what's on the right The SQL above isn't tested...and more sudo code than actual...but should work depending on your db and version. Then when you add from left to right, refresh both tables...the item you just added to the right should be removed from the left, and vis versa if removing from the right. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad K Esser Sent: Monday, June 08, 2009 2:22 PM To: [email protected] Subject: Re: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect Curt, You have two tables: Table A is on the left, with "A.Value" referring to what's showing in the list. Table B is on the right, with "B.Value" as the values. Create an unlimited length, temporary character field (zTmpChar). Any time Table B gets changed (don't forget window open if appropriate), call a guide that walks the B table (make sure the table is refreshed first), and sets the zTmpChar field to a list of the B.Values. Use whatever you want as separators, I'll use semi-colons here (if you make sure the list starts and ends with semi-colons, things are easier). In your screenshot, after the table walk, the zTmpChar field would look like: ;eBiz Catalog;eBiz eCommerce;Engineering Tools; Set the table qualification on Table A to be: NOT($zTmpChar$ like "%;" + 'A.Value' + ";%") Refresh Table A. The "tricky part", if you will, is to put the zTmpChar field to the left in the LIKE clause, and have the Table A value on the right. Its been a while since I did this and I don't have access to that code anymore, so hopefully I remembered enough to be helpful. Thad Esser Remedy Developer "Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky?" - Pink Floyd -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Schryver, Curt Sent: Monday, June 08, 2009 2:28 PM To: [email protected] Subject: Creating the "two tables with the add/remove buttons in between to swap data between tables" effect Has anyone come up with a means to replicate this functionality in AR? The list on the left needs to be dynamic. Once an item has been selected and "moved" to the right, it should no longer appear in the left side. See image for a better example of what I mean. http://arsystem.comxa.com/2tables.jpg ARSystem 7.0.01 patch 3 Windows 2003 Server Oracle 10i Thanks, Curt Curt A. Schryver Action Request System Administrator Tyco Electronics 100 AMP Drive MS 161-043 Harrisburg, PA 17105 717-810-2109 tel 717-810-2124 fax [email protected] _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
