Hi, I know I can run this sql command,

select unique(Company) from Customers where Area = 'STOCKHOLM'

Will give a selectionlist with unique companies located in STOCKHOLM for entries in the Customerform

maybe 1 user or 100/company, doesn't matter, both will be be presented in the list.

But the output from this sql is not userfriendly, is there a better way to show the result, something like a table field with the unique companies?
Of course no drill down or so, just a presentaion of the data instead of a selectionlist.

Thanks,

L ars Pettersson
Vattenfall Business Services Nordic AB
ARS Systems Engineer
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com
www.vattenfall.se


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Create a db view with the results and any columns you want to use as the
search criteria:

Create view usercompanies as (
Select distinct company, area
>From customers)

Then create a view form that points to the db view.

Then point your table field to the view form.

Again, I wish Remedy had the ability to do grouping, aggregate functions,
etc within table fields.

Axton

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.pettersson@VATTENFALL.COM
Sent: Saturday, February 19, 2005 11:45 AM
To: arslist@ARSLIST.ORG
Subject: "Table Field" showing Unique requests

Hi, I know I can run this sql command,

select unique(Company) from Customers where Area = 'STOCKHOLM'

Will give a selectionlist with unique companies located in STOCKHOLM for
entries in the Customerform

maybe 1 user or 100/company, doesn't matter, both will be be presented in
the list.

But the output from this sql is not userfriendly, is there a better way to
show the result, something like a table field with the unique companies?
Of course no drill down or so, just a presentaion of the data instead of a
selectionlist.

Thanks,

L ars Pettersson
Vattenfall Business Services Nordic AB
ARS Systems Engineer
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com
www.vattenfall.se



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)

Thanks! Yes, would have been great to be able to use sql on the qualification row for tablefield, now it will be more work to perform this, but surely, your suggested method will work. /L ars

-----Ursprungligt meddelande-----
Från: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]För Axton Grams
Skickat: den 19 februari 2005 22:15
Till: arslist@ARSLIST.ORG
Ämne: Re: "Table Field" showing Unique requests


Create a db view with the results and any columns you want to use as the
search criteria:

Create view usercompanies as (
Select distinct company, area
>From customers)

Then create a view form that points to the db view.

Then point your table field to the view form.

Again, I wish Remedy had the ability to do grouping, aggregate functions,
etc within table fields.

Axton

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of lars.j.pettersson@VATTENFALL.COM
Sent: Saturday, February 19, 2005 11:45 AM
To: arslist@ARSLIST.ORG
Subject: "Table Field" showing Unique requests

Hi, I know I can run this sql command,

select unique(Company) from Customers where Area = 'STOCKHOLM'

Will give a selectionlist with unique companies located in STOCKHOLM for
entries in the Customerform

maybe 1 user or 100/company, doesn't matter, both will be be presented in
the list.

But the output from this sql is not userfriendly, is there a better way to
show the result, something like a table field with the unique companies?
Of course no drill down or so, just a presentaion of the data instead of a
selectionlist.

Thanks,

L ars Pettersson
Vattenfall Business Services Nordic AB
ARS Systems Engineer
S-461 88 Trollhättan
Sweden

Phone +46 520 888 35 Mobil +46 70 608 99 95
e-mail: lars.j.pettersson@vattenfall.com
www.vattenfall.se



UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)


UNSUBSCRIBE or access ARSlist Archives at http://www.ARSLIST.org
(Support: mailto:support@arslist.org)