Select Data from Work Log

[Butlertl]

I have a work log/memo field that begins with

4/9/2009 3:46:26 PM terry.butler
Reportable changed to: No

I need to select all records that include the name xxxxxx.xxxxxx in the work log. I would provide about 30 names that should match for record selection......

What is the best way to accomplish this? Thank you for all suggestions

 

[Butlertl]

No records were selected........

This is the first four lines of the work log

2/4/2009 3:12:14 PM terry.butler
Reportable changed to: No

Impact changed to: One Client

 

[lbass]

Do you have any other fields in the detail section? Does the record count say 0? Because I don't think you should get that error unless there are records without spaces. Could there be any individual records that have more than 1000 spaces?

-LB

 

[Butlertl]

I have three fields in the detail section: Support ID, Status, Worklog.

I reun the report with this select statement {OAO_HDSP_Support.Create Date} in {?Date Range} and
not ({OAO_HDSP_Support.Status} in ["Cancelled"])

and I get 288 reocrds.....

With this select statement
{OAO_HDSP_Support.Create Date} in {?Date Range} and
not isnull({OAO_HDSP_Support.Work Log}) and
instr({OAO_HDSP_Support.Work Log}," ") = 0 and
not ({OAO_HDSP_Support.Status} in ["Cancelled"])

I get 0 reocrds.

 

[Butlertl]

If we are restricted to an array of 1000 charectors....could we take the first 100 charactors, place them in a variable and then do the select?

 

[Butlertl]

I created a formula MEMOTEST:

left ({OAO_HDSP_Support.Work Log}, 100)

MEMONAME is now:
stringvar array x;
stringvar array y;
if instr({@memotest}, chr(13)) <> 0 then (
x := split({@memotest},chr(13));
y := split(x[1]," ");
) else
y := split({@memotest}," ");
y[ubound];


With this select statement:

{OAO_HDSP_Support.Create Date} in {?Date Range} and
not ({OAO_HDSP_Support.Status} in ["Cancelled"])

"This is the field MEMOTEST:
4/9/2009 12:07:41 AM sharrie.scott
Reportable changed to: No

Impact"

MEMONAME = No

 

[lbass]

Then it looks like you don't have a chr(13) (return). Try replacing it with chr(10) (line feed).

-LB

 

[Butlertl]

IT WORKS.....I will continue testing though.

Thank you so much for taking your time to provide advice and support.....

T Butler