Andy, I have a form that has a table field that uses External for the query. The External uses one field that is set through an active link that references data in 3 other fields. Here is what the set field action looks like:
"'Status' <= ""RESPONDED"" AND 'Support-Region' = $Support-Region$ AND 'Support-Desk' = $Support-Desk$ AND 'Support-Group'=$Support-Group$" So when I compare what I use with yours and see what is in the field after the set fields, it looks like it should work. The other option then might be with the field label '*Assigned Group'. When you look at the field in the admin tool is *Assigned Group the database name? We have a field where the field label is 'Last Name*' but the name for the data field is 'Last Name'. We needed to do this because of an issue with the email engine because of the *. A search using the Advanced Search bar uses the label 'Last Name*' but External uses the database name 'Last Name'. Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Thursday, October 04, 2007 6:55 PM To: [email protected] Subject: Re: EXTERNAL command problems If I am reading it correctly, you are suppose to enclose the value portion in "". My set field is setting : "'*Assigned Group' = ""SIA_Config""" which sets the value of '*Assigned Group' = "SIA_Config" to my temp field. It will not allow me to enclose the entire statement in "". I get an error when trying it. Of course what I am doing is not working, so I am obviously doing something wrong. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Thursday, October 04, 2007 5:16 PM To: [email protected] Subject: Re: EXTERNAL command problems Andy, A qualification that works in the Advanced Search bar doesn't work with External. If I remember correctly the whole statement must be enclosed in double quotes. I don't have my laptop connected up at the moment so I can't give you an example. Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
