×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SC 5 Inbox creation from Query (Expert Search)

SC 5 Inbox creation from Query (Expert Search)

SC 5 Inbox creation from Query (Expert Search)

(OP)
First, I want to thank those that helped me in the past.  This place is a great resource.  

I have a new issue.  I have created an expert query that is 800 characters.  This thing works perfect when I run an expert search.  It brings back all the correct data and everything.  Now, I want to be able to save it as an inbox for easier use.  But, there is an 80 character limit in the inbox query field.  I've checked all character limitations and they should accomodate this just fine.

Have any of you had similar issues and if so, what was the resolution?  Thanks for any advice.

Luap

RE: SC 5 Inbox creation from Query (Expert Search)

Could you please post the query? Then I will look whether I can help.

gr Willie

RE: SC 5 Inbox creation from Query (Expert Search)

(OP)
Sure, Here is the query:

flag=true and date(tod() - '7 00:00:00')<=open.time and ((severity.code="1" and (tod() - '00:30:00')>update.time) or (severity.code="2" and (tod() - '01:00:00')>update.time) or (severity.code="3" and (tod() - '01:00:00')>update.time) or (severity.code="4" and (tod() - '06:00:00')>update.time) or (severity.code="5" and (tod() - '12:00:00')>update.time)) and flag=true and date(tod() - '7 00:00:00')<=open.time and ((severity.code="1" and (tod() - '00:30:00')>open.time) or (severity.code="2" and (tod() - '01:00:00')>open.time) or (severity.code="3" and (tod() - '04:00:00')>open.time) or (severity.code="4" and (tod() - '08:00:00')>open.time) or (severity.code="5" and (tod() - '3 00:00:00')>open.time)) and problem.status<>"Work around"

RE: SC 5 Inbox creation from Query (Expert Search)

Please think with me:

Your query was:

flag=true and
date(tod() - '7 00:00:00')<=open.time
and (        (severity.code="1" and (tod() - '00:30:00')>update.time)
or     (severity.code="2" and (tod() - '01:00:00')>update.time)
or     (severity.code="3" and (tod() - '01:00:00')>update.time)
or     (severity.code="4" and (tod() - '06:00:00')>update.time)
or     (severity.code="5" and (tod() - '12:00:00')>update.time)    )
and flag=true and
date(tod() - '7 00:00:00')<=open.time
and (        (severity.code="1" and (tod() - '00:30:00')>open.time)
or     (severity.code="2" and (tod() - '01:00:00')>open.time)
or     (severity.code="3" and (tod() - '04:00:00')>open.time)
or     (severity.code="4" and (tod() - '08:00:00')>open.time)
or     (severity.code="5" and (tod() - '3 00:00:00')>open.time)    )

and problem.status<>"Work around"

First you see that the flag =true and date(tod() - '7 00:00:00')<=open.time is twice there. I removed this one time.
Second: If you check on prio 1 for beeing opened longer then 30 minutes ago and on updated longer then 30 min ago you can see that the first is the stronger. To have been updated longer then 30 min ago it has to be open longer then 30 minutes. so you can skip this part in the second part. The same for prio2. This will also reduce the length.

Further on you have two things about prio 3-5. You can combine these in the query thus skipping the double use of severity.code=..

My doubt is in the meaning of the first <date(tod() - '7 00:00:00')<=open.time> Why do you not want to see the things that are older after all these statements?

The query that is over is state under: (I think SC can handle query longer then 80 char. If ound one out of the box of 319)


flag=true
and date(tod() - '7 00:00:00')<=open.time
and problem.status<>"Work around"
and(
    (severity.code="1" and (tod()-'00:30:00')>open.time)
or  (severity.code="2" and (tod()-'01:00:00')>open.time)
or  (severity.code="3" and ((tod()-'01:00:00')>update.time)
                        or( tod()-'04:00:00')>open.time))
or  (severity.code="4" and ((tod()-'06:00:00')>update.time)
                        or( tod()-'08:00:00')>open.time))
or  (severity.code="5" and ((tod()-'12:00:00')>update.time)
                        or( tod()-'3 00:00:00')>open.time))
   )

You can remove the tabs and spaces, but I putted it this way for your convenience.

Gr Willie

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close