performing a find using OR

[ITOjim]

All,

I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift.

I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call.

Any ideas?

Jim

[ITOjim]

All,

I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift.

I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call.

Any ideas?

Jim

[ITOjim]

All,

I need to generate a report for the Computer Operations Center and have gotten everything to work with the Start Date and End Dates, but now I need to have the Operators print a report with events that they either Opened or Closed during their shift.

I have gotten it to work when I enter their name in either the field "gt_op_on_duty" (the person who entered the call) or in field "gt_op_clos_call" (who closed the call) but what I need is an OR statement, matching any records that has them Entering the call or closing the call.

Any ideas?

Jim

[mr_vodka]

If you are doing in directly in find mode instead or running a script, you can just put John Doe in the "gt_op_on_duty" field, then create a new request (same Ctrl-N, as creating a new record ) then enter John Doe into the "gt_op_clos_call" field. This will allow you to find this data in both fields.

Another way you can accomplish is to create a global text field and then create a script to do the same thing of adding a new request.

[mr_vodka]

If you are doing in directly in find mode instead or running a script, you can just put John Doe in the "gt_op_on_duty" field, then create a new request (same Ctrl-N, as creating a new record ) then enter John Doe into the "gt_op_clos_call" field. This will allow you to find this data in both fields.

Another way you can accomplish is to create a global text field and then create a script to do the same thing of adding a new request.

[mr_vodka]

If you are doing in directly in find mode instead or running a script, you can just put John Doe in the "gt_op_on_duty" field, then create a new request (same Ctrl-N, as creating a new record ) then enter John Doe into the "gt_op_clos_call" field. This will allow you to find this data in both fields.

Another way you can accomplish is to create a global text field and then create a script to do the same thing of adding a new request.

[ITOjim]

I created a global as you indicated, what would that script look like?

[ITOjim]

I created a global as you indicated, what would that script look like?

[ITOjim]

I created a global as you indicated, what would that script look like?

[ITOjim]

got it!

one more thing off the list, sweet.

Thanks

Jim

[ITOjim]

got it!

one more thing off the list, sweet.

Thanks

Jim

[ITOjim]

got it!

one more thing off the list, sweet.

Thanks

Jim