Re: Qualification EXTERNAL() Issue - Returns Nothing
- Issue solved by moving form to a different server. On Sep 7, 1:36 pm, koray ko...@alkankoray.net wrote: I just came across a FAIL statement in log file when I enter a qualification in char field : API TID: ** 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: ** 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 ko...@alkankoray.net 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' = TSK011 - 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 frederick.w.gro...@xo.com 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' = TSK01 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' = TSK01 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:arsl...@arslist.org] On Behalf Of koray Sent: Saturday, September 05, 2009 11:49 AM To: arsl...@arslist.org 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 shafq...@yahoo.com wrote: Koray if you are entering the qualification as 'Task ID' = TSK01 in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK01' needs to be something like TSK01 . 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 ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arsl...@arslist.org Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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
Re: Qualification EXTERNAL() Issue - Returns Nothing
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' = TSK011 - 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 frederick.w.gro...@xo.com 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' = TSK01 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' = TSK01 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:arsl...@arslist.org] On Behalf Of koray Sent: Saturday, September 05, 2009 11:49 AM To: arsl...@arslist.org 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 shafq...@yahoo.com wrote: Koray if you are entering the qualification as 'Task ID' = TSK01 in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK01' needs to be something like TSK01 . 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 ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arsl...@arslist.org Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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
Re: Qualification EXTERNAL() Issue - Returns Nothing
I just came across a FAIL statement in log file when I enter a qualification in char field : API TID: ** 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: ** 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 ko...@alkankoray.net 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' = TSK011 - 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 frederick.w.gro...@xo.com 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' = TSK01 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' = TSK01 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:arsl...@arslist.org] On Behalf Of koray Sent: Saturday, September 05, 2009 11:49 AM To: arsl...@arslist.org 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 shafq...@yahoo.com wrote: Koray if you are entering the qualification as 'Task ID' = TSK01 in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK01' needs to be something like TSK01 . 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 ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arsl...@arslist.org Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday
Re: Qualification EXTERNAL() Issue - Returns Nothing
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' = TSK01 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' = TSK01 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:arsl...@arslist.org] On Behalf Of koray Sent: Saturday, September 05, 2009 11:49 AM To: arslist@ARSLIST.ORG 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 shafq...@yahoo.com wrote: Koray if you are entering the qualification as 'Task ID' = TSK01 in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK01' needs to be something like TSK01 . 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 ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arsl...@arslist.org Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are
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 shafq...@yahoo.com wrote: Koray if you are entering the qualification as 'Task ID' = TSK01 in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK01' needs to be something like TSK01 . 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 ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arsl...@arslist.org Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
I have found that you get 1=0 when Remedy does not like the qualification string. This could be because of incorrect syntax or bad column names. On Fri, Sep 4, 2009 at 3:31 PM, korayko...@alkankoray.net wrote: 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arslist@ARSLIST.ORG 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
You need to build the string literally. String = 'Task ID' = + + TSK1 + I may be slightly off on syntax of embedding a double quote, that may take a little tweaking. What I do is make the char string visible and editable, so I can see what is being populated, and can manually tweak it to figure out what is right. If you're embedding a variable, i.e. $USER$, you may need to put a \ in front of the var name $\USER$ so it isn't interpreted when compiled. Again, you will need to tweak to get it exactly right. Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:51 AM To: arslist@ARSLIST.ORG Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
Situation Update 2: EXTERNAL() works on SOME other forms correctly with form 'Task ID' = TSK1. I have double-checked every field's database name and there should be no error. Could there be any other, what i am going to call, weird reason? Regards, Koray. On Sep 4, 4:36 pm, Mark Lev mark@rightstarsystems.com wrote: You need to build the string literally. String = 'Task ID' = + + TSK1 + I may be slightly off on syntax of embedding a double quote, that may take a little tweaking. What I do is make the char string visible and editable, so I can see what is being populated, and can manually tweak it to figure out what is right. If you're embedding a variable, i.e. $USER$, you may need to put a \ in front of the var name $\USER$ so it isn't interpreted when compiled. Again, you will need to tweak to get it exactly right. Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:51 AM To: arsl...@arslist.org Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
Seems like certain forms do not accept ANY External Qualifications. Even setting 1=1 in Character Field for External Qualification gives SELECT (..) FROM (...) WHERE (1 = 0) ORDER BY 6 ASC in log file and returns nothing. On Sep 4, 5:26 pm, koray ko...@alkankoray.net wrote: Situation Update 2: EXTERNAL() works on SOME other forms correctly with form 'Task ID' = TSK1. I have double-checked every field's database name and there should be no error. Could there be any other, what i am going to call, weird reason? Regards, Koray. On Sep 4, 4:36 pm, Mark Lev mark@rightstarsystems.com wrote: You need to build the string literally. String = 'Task ID' = + + TSK1 + I may be slightly off on syntax of embedding a double quote, that may take a little tweaking. What I do is make the char string visible and editable, so I can see what is being populated, and can manually tweak it to figure out what is right. If you're embedding a variable, i.e. $USER$, you may need to put a \ in front of the var name $\USER$ so it isn't interpreted when compiled. Again, you will need to tweak to get it exactly right. Thanks, Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:51 AM To: arsl...@arslist.org Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
Koray --- On Fri, 9/4/09, koray ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arslist@ARSLIST.ORG Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Qualification EXTERNAL() Issue - Returns Nothing
Koray if you are entering the qualification as 'Task ID' = TSK01 in an external qual it will not work, you need to put the double quotes within two double quotes so the 'TSK01' needs to be something like TSK01 . 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 ko...@alkankoray.net wrote: From: koray ko...@alkankoray.net Subject: Re: Qualification EXTERNAL() Issue - Returns Nothing To: arslist@ARSLIST.ORG Date: Friday, September 4, 2009, 1:50 PM Qualification I am using is something basic like 'Task ID' = TSK01 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 mark@rightstarsystems.com 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:arsl...@arslist.org] On Behalf Of koray Sent: Friday, September 04, 2009 8:31 AM To: arsl...@arslist.org 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 ko...@alkankoray.net 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:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
