Re: Entries in Table Field on Open or Display?
Drew, While all these methods would work, use a little caution about refreshing the table field if not needed to be refreshed if the table against which that table field is built is a large table. You do not really want to get the results back if they are not needed.. In that case I would use a direct SQL with a select count(*) where whatever the criteria is on the table field qualification and set that to a field. The cost of this would be less than getting results back and then doing a count over the result set on the table field.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Lyle Taylor Sent: Thursday, February 04, 2010 5:36 PM To: arslist@ARSLIST.ORG Subject: Re: Entries in Table Field on Open or Display? ** Note that you may need to make sure the table field has been refreshed before checking how many rows are in it. Otherwise, it may come back as zero. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ray Palla Sent: Thursday, February 04, 2010 3:30 PM To: arslist@ARSLIST.ORG Subject: Re: Entries in Table Field on Open or Display? ** Drew; I think if your AL has a qualification of >0 on the table field ID itself, you will get a value if the table has an entry. R -- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, February 04, 2010 3:52 PM To: arslist@ARSLIST.ORG Subject: Entries in Table Field on Open or Display? ** Good afternoon listers. Is there a way to tell if a table field contains any entries when a record is Displayed or Opened, so that I can fire an AL? -- Drew Sent from Miami, FL, United States That's a laugh! I'm in Comayagua. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Entries in Table Field on Open or Display?
Note that you may need to make sure the table field has been refreshed before checking how many rows are in it. Otherwise, it may come back as zero. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ray Palla Sent: Thursday, February 04, 2010 3:30 PM To: arslist@ARSLIST.ORG Subject: Re: Entries in Table Field on Open or Display? ** Drew; I think if your AL has a qualification of >0 on the table field ID itself, you will get a value if the table has an entry. R From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, February 04, 2010 3:52 PM To: arslist@ARSLIST.ORG Subject: Entries in Table Field on Open or Display? ** Good afternoon listers. Is there a way to tell if a table field contains any entries when a record is Displayed or Opened, so that I can fire an AL? -- Drew Sent from Miami, FL, United States That's a laugh! I'm in Comayagua. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Entries in Table Field on Open or Display?
Drew; I think if your AL has a qualification of >0 on the table field ID itself, you will get a value if the table has an entry. R _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, February 04, 2010 3:52 PM To: arslist@ARSLIST.ORG Subject: Entries in Table Field on Open or Display? ** Good afternoon listers. Is there a way to tell if a table field contains any entries when a record is Displayed or Opened, so that I can fire an AL? -- Drew Sent from Miami, FL, United States That's a laugh! I'm in Comayagua. _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: Entries in Table Field on Open or Display?
You can do a colcount($columnname$) on a column you know won't be null (like hidden request id if you like), and if the count is > 0 you know there are entries in the table. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Thursday, February 04, 2010 2:52 PM To: arslist@ARSLIST.ORG Subject: Entries in Table Field on Open or Display? ** Good afternoon listers. Is there a way to tell if a table field contains any entries when a record is Displayed or Opened, so that I can fire an AL? -- Drew Sent from Miami, FL, United States That's a laugh! I'm in Comayagua. _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"