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
|------------>
| From: |
|------------>
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|"Schryver, Curt" <[email protected]>
|
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|------------>
| To: |
|------------>
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|[email protected]
|
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|06/08/2009 12:28 PM
|
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|Creating the "two tables with the add/remove buttons in between to swap
data between tables" effect |
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|------------>
| Sent by: |
|------------>
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
|"Action Request System discussion list(ARSList)" <[email protected]>
|
>---------------------------------------------------------------------------
-----------------------------------------------------------------------|
**
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]
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers
Are"_
*IMPORTANT NOTICE: This communication, including any attachment, contains
information that may be confidential or privileged, and is intended solely
for the entity or individual to whom it is addressed. If you are not the
intended recipient, you should delete this message and are hereby notified
that any disclosure, copying, or distribution of this message is strictly
prohibited. Nothing in this email, including any attachment, is intended to
be a legally binding signature.
*
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor:[email protected] ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
