Hi,
What you can do is to create a display-only-integer-field called
'NotesLength'.
Then you create a filter that runs on GetEntry that assigns a value to
this field. The value should be LENGTHC($Notes$) or some such thing.
After this you create a basic AR System report that counts this field. The
basic report capability in the AR System will use the API-call
ARGetMultipleEntries() which makes sure that the filter is run.
On the other hand, you may want to calculate this value on Submit/Modify
instead, and store it in a Optional field. This will make sure that the
calculation is not done when it is not needed. It is a very simple thing,
so the time-difference will probably not be noticeable.
Another way would be to create a View-form against your Regular form, and
do the Get-entry-calculation there. This will make sure that it is not
done when it is not needed.
Note that in Crystal Reports you can not count on the Get Entry filter to
run. The call used varies depending on the fields in the CR-report.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hi List
>
> Is there any way to find out what the Average character count of the notes
> field in Incident Management tickets which have been submitted?
>
>
> What and can that be run in an Advanced search statement?
> Thanks
>
>
>
> ARS 7.1 patch 6
> Oracle 10g
>
> JK
>
> *************************************************************
> This e-mail message, including any attachments, is for the sole use of the
> addressee(s) to whom it has been sent, and may contain information that is
> confidential or legally protected. If you are not the intended recipient
> or have received this message in error, you are not authorized to copy,
> distribute, or otherwise use this message or its attachments. Please
> notify the sender immediately by return e-mail and permanently delete this
> message and any attachments. Dunkin' Brands Inc. makes no warranty that
> this e-mail is error or virus free.
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
