Listers,

I'm trying to create an active link that opens a form displaying all the
records that the Assigned To or Assigned Group match the user.

'Assigned To' = $USER$ works fine, but
('Assigned To' = $USER$) OR ('Assigned Group' LIKE "%" + $GROUPS$ + "%")
returns no records. In fact, any qualification using Assigned Group fails,
even 'Assigned Group' = "GroupName".

Any help would be appreciated.

-Howard

Hi Howard,

Shouldn't it be:

($USER$ = 'Assigned To') OR ( $GROUPS$ LIKE "%"+ 'Assigned Group' + "%" )

Jeff


-----Original Message-----
From: Baker Howard J TSgt AFTAC/LSCW [mailto:Howard.Baker@PATRICK.AF.MIL]
Sent: Fri 10/15/04 12:52 PM
To: ARSLIST@ARSLIST.ORG
Cc:
Subject: Search by Assignee Group?


**
Listers,

I'm trying to create an active link that opens a form displaying all the records that the Assigned To or Assigned Group match the user.

'Assigned To' = $USER$ works fine, but
('Assigned To' = $USER$) OR ('Assigned Group' LIKE "%" + $GROUPS$ + "%") returns no records. In fact, any qualification using Assigned Group fails, even 'Assigned Group' = "GroupName".

Any help would be appreciated.

-Howard

This posting was submitted via the Web interface