Re: Help with table field qualification!!!!!!!

[Frank Caruso]

** You could try creating a VIEW form of the table. Something like "select DISTINCT user_name from table". Then use that VIEW in your table field and add a qualification to filter your results.

I don't believe there is any built in way of getting distinct values from a table in Remedy, unless you use a menu.

On 7/17/06, Nisha RAMTRI <[EMAIL PROTECTED]> wrote:

**

Hello All,

I have a display only form which has a table field which gets data populated from some backend table. Now this backend table has multiple entries of a particular user/region and I want that only distinct values should be populated in the display-only table. How can this be achieved?

How should the table qualification be built in this case? I tried using External  with set fields in some char field as qualification but this did not get processed. Any ideas how it can be done?? 

Thanks.

Warm Regards,

Nisha Ramtri

Remedy Development, ITAC,

ST Microelectronics Ltd.

Plot#1, Knowledge Park-III,

Greater Noida.

Ph# (0120)3916000 Extn:6247

PSTN# (0120)4006247

 

 

__20060125_______________________This posting was submitted with HTML in it___

--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___