- Issue solved by moving form to a different server. On Sep 7, 1:36 pm, koray <[email protected]> wrote: > I just came across a FAIL statement in log file when I enter a > qualification in char field : > > <API > <TID: 00000000**> <RPC ID: 00********> <Queue: List > > <Client-RPC: ****** > <USER: ****** > /* Mon > Sep 07 2009 12:31:24.0244 */+EXECAL ARExecuteProcessForActiveLink from > Remedy User (protocol 11) at IP address ***.**.**.*** > > <API > <TID: 00000000**> <RPC ID: 00*********> <Queue: List > > <Client-RPC: ****** > <USER: ****** > /* Mon > Sep 07 2009 12:31:24.0247 */-EXECAL FAIL > > While the char field is empty and the table is updated these 2 lines > does not occur. > > Koray. > > On Sep 7, 10:26 am, koray <[email protected]> wrote: > > > > > > > I tried both manually typing the qualification in the character field > > and putting it into a workflow, with correct syntax of double quotes. > > > Neither using the Field ID or the database name of the Task ID field > > works correct. > > > To sum up what exactly the problem is; > > > - For a number of forms, EXTERNAL() function does work perfect where > > for FormX entering the qualification string with EXTERNAL() gives an > > output of SELECT ... FROM ... WHERE (1 = 0) even if I enter the > > qualification as 1=1. > > - Entering qualification string(s) manually into Table Properties > > window returns valid results, including 'Task ID' = "TSK0000011" > > - For workflow, results are the same. > > > So, > > - Qualification strings I am using must be valid, both on EXTERNAL() > > and Table Properties. > > - I have also tried using Task ID field's Field ID, but no luck. > > > Koray. > > > On Sep 7, 4:51 am, "Grooms, Frederick W" <[email protected]> > > wrote: > > > > 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 atwww.arslist.org > > > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > > ___________________________________________________________________________ > > ____ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > ___________________________________________________________________________ > ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
