I believe Shafqat is talking about when you build a set fields action to populate your qualification field through workflow. If you are manually entering into that field you will not double up the double quotes.
Just to make sure things are clear... You have a form (FormA) that has a table field on it. That table field is displaying data from FormX. You have a display only character field (zTempQualX) on FormA to hold the external qualification for the table. If you just type into zTempQualX you can type 'Task ID' = "TSK000001" To build that string in workflow you would use "'Task ID' = """ + $SomeFieldOnFormA$ + """" For your problem... Are you sure that the field on FormX is 'Task ID' ? Try using the Field ID of the field on FormX '1' = "TSK000001" I have seen problems where the field name does not always work, but using the ID should. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of koray Sent: Saturday, September 05, 2009 11:49 AM To: [email protected] Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing Dear Shafqat, That issue does not seem to be because of a syntax error since I have indicated previously for some other forms EXTERNAL() command works perfect. It feels like it should have something to do with the properties of the form or the fields that I am trying to qualify from. Regards, Koray. On Sep 5, 4:09 am, Shafqat Ayaz <[email protected]> wrote: > Koray > if you are entering the qualification as 'Task ID' = "TSK000001" in an > external qual it will not work, you need to put the double quotes within two > double quotes so the 'TSK000001' needs to be something like " " "TSK000001" " > " . > I have put spaces to show you the double quotes, you need to remove the > spaces. > make your char field visible and then have a look at what the qualification > looks like and you will what is wrong. you can enter the qual as you have > shown in the EXTERNAL qualification field and just right click on the table > and refresh it, it will show the correct data, but if you do a Set Fields > then you have to triple the double quotes. > Let me know if this fixes your problem or you need further help. > > thanks > > shafqat ayaz > > --- On Fri, 9/4/09, koray <[email protected]> wrote: > > From: koray <[email protected]> > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > To: [email protected] > Date: Friday, September 4, 2009, 1:50 PM > > Qualification I am using is something basic like 'Task ID' = > "TSK000001" just to test it. > > Weird thing is that when I enter the qualification string manually on > Table Properties it works perfect, but not via the character field. > > On Sep 4, 3:37 pm, Mark Lev <[email protected]> wrote: > > > > Can you post what the char string is that you're using when it doesn't > > work? You have to build it out to include formatting. > > > As for the 1=1 when you're leaving blank, it is probably building that to > > show all, as it likely needs to put in something. I don't see that as > > anything to worry about. > > > Thanks, > > Mark > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of koray > > Sent: Friday, September 04, 2009 8:31 AM > > To: [email protected] > > Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing > > > Update on situation: > > > When the qualification string is empty log files reads > > > SELECT (......) FROM (...) WHERE (1 = 1) ORDER BY 6 ASC > > > and lists all the data, as i had mentioned previously. > > > On Sep 4, 3:13 pm, koray <[email protected]> wrote: > > > Dear List, > > > > I again have an issue but this seems a bit meaningless to me. > > > > I have a table on my form retrieving data from X form with every > > > fields of it added as columns. > > > > I also created a Character Field and set the table's Qualification to > > > that char field as External(). > > > When I refresh the table without any qualification - in other words > > > when the char field is empty - table lists all the data. > > > > But, when I enter a valid qualification string in the char field, I > > > get nothing. Log file shows like > > > > SELECT (......) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC > > > > 1) where does 1=0 come from? Isn't it meaningless? > > > 2) Although I have not set any Order option from Table Properties > > > ORDER BY 6 ASC occurs. > > > > Any ideas? > > > > Regards, > > > > Koray. > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
