Search builder... Broken?


#1

Hi,

Just reviewing 3.8, very nice (love the new theme). One thing that
stuck me though, is that the search builder still seems to be very
difficult to use, and almost impossible (it seems) to do what should
be a simple thing without going into the advanced window.

The Primary difficulty is constructing queries with variations of AND
and OR, and nesting,

For example… Constructing a fairly standard query like

Subject LIKE ‘abc123’ AND Queue = ‘General’ AND ( Status = ‘new’ OR
Status = ‘open’ )

using the point/click search builder seems impossible, or at least,
not intuitive, I can’t workout how to do it.

This is the same as with the version of RT that I use (3.2.2, yes,
old)… I was hoping this would have been been fixed by now.

Is this is a bug in the new version, or just the way query builder
works… or am I just doing it wrong?

Regards,
Matthew Watson.

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Please notify the sender immediately by email if you have received this
email by mistake and delete this email from your system. Please note that
any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for
the presence of viruses. The organisation accepts no liability for any
damage caused by any virus transmitted by this email.


#2

Matthew Watson writes:

Hi,

Just reviewing 3.8, very nice (love the new theme). One thing that
stuck me though, is that the search builder still seems to be very
difficult to use, and almost impossible (it seems) to do what should
be a simple thing without going into the advanced window.

The Primary difficulty is constructing queries with variations of AND
and OR, and nesting,

For example… Constructing a fairly standard query like

Subject LIKE ‘abc123’ AND Queue = ‘General’ AND ( Status = ‘new’ OR
Status = ‘open’ )

using the point/click search builder seems impossible, or at least,
not intuitive, I can’t workout how to do it.

I wouldn’t say it is intuitive unless you’ve been doing it a few
years, but you can get your query above by:

Select 'Subject matches “abc123”, Queue is general, and Status is new’
Hit add
Click to select “Status = ‘new’” in the Current Search box
Click on the right arrow button to make it a subquery
Change the Aggregator to ‘OR’ and add the “Status = ‘open’” clause
Hit add.

Is this is a bug in the new version, or just the way query builder
works… or am I just doing it wrong?

In truth, I usually add about half of that then go to the advanced
box. My theory is that the interface is intuitive to the authors of
DBIx::SearchBuilder but presents challenges to the rest of us :wink:

Cheers,
Michael

Michael Brader michael.brader@youramigo.com

IMPORTANT - This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information in
which case neither is intended to be waived. YourAmigo retains ownership of
all copyright, trade secrets and other intellectual property rights in the
email and attachments. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
notify us and remove it from your system. It is your responsibility to check
any attachments for viruses and defects before opening or sending them on.
YourAmigo collects personal information to provide and market our services.
For more information about use, disclosure and access, see our privacy
policy at http://www.youramigo.com


#3

Thanks michael, that worked great. I guess it does just come down to
it not being intuitive, and the order of you doing things being very
important.

My general way of doing things is just to add all the fields I need to
restrict on, and then just go advanced.

Regards,
Matthew Watson.On 17/07/2008, at 10:56 AM, Michael Brader wrote:

Matthew Watson writes:

Hi,

Just reviewing 3.8, very nice (love the new theme). One thing that
stuck me though, is that the search builder still seems to be very
difficult to use, and almost impossible (it seems) to do what should
be a simple thing without going into the advanced window.

The Primary difficulty is constructing queries with variations of AND
and OR, and nesting,

For example… Constructing a fairly standard query like

Subject LIKE ‘abc123’ AND Queue = ‘General’ AND ( Status = ‘new’ OR
Status = ‘open’ )

using the point/click search builder seems impossible, or at least,
not intuitive, I can’t workout how to do it.

I wouldn’t say it is intuitive unless you’ve been doing it a few
years, but you can get your query above by:

Select 'Subject matches “abc123”, Queue is general, and Status is new’
Hit add
Click to select “Status = ‘new’” in the Current Search box
Click on the right arrow button to make it a subquery
Change the Aggregator to ‘OR’ and add the “Status = ‘open’” clause
Hit add.

Is this is a bug in the new version, or just the way query builder
works… or am I just doing it wrong?

In truth, I usually add about half of that then go to the advanced
box. My theory is that the interface is intuitive to the authors of
DBIx::SearchBuilder but presents challenges to the rest of us :wink:

Cheers,
Michael


Michael Brader michael.brader@youramigo.com

IMPORTANT - This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information
in
which case neither is intended to be waived. YourAmigo retains
ownership of
all copyright, trade secrets and other intellectual property rights
in the
email and attachments. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient,
please
notify us and remove it from your system. It is your responsibility
to check
any attachments for viruses and defects before opening or sending
them on.
YourAmigo collects personal information to provide and market our
services.
For more information about use, disclosure and access, see our privacy
policy at http://www.youramigo.com


This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email


This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Please notify the sender immediately by email if you have received this
email by mistake and delete this email from your system. Please note that
any views or opinions presented in this email are solely those of the
author and do not necessarily represent those of the organisation.
Finally, the recipient should check this email and any attachments for
the presence of viruses. The organisation accepts no liability for any
damage caused by any virus transmitted by this email.


#4

In truth, I usually add about half of that then go to the advanced
box. My theory is that the interface is intuitive to the authors of
DBIx::SearchBuilder but presents challenges to the rest of us :wink:

Agreed. It probably makes sense to whoever built it, but the query
builder is one of the very few things where RT is not quite usable.

Usually, I use the advanced builder. This is a lot less complex
and frustrating than the query builder.

On the other hand, this is a complex concept and I am not
sure how to improve RT in this regard.
Other than making the ‘load saved query’ part stand out so you
don’t accidentially click load all the time, that is. This seems to
happen quite often to my co-workers.

Richard


#5

Matthew Watson writes:

Hi,

Just reviewing 3.8, very nice (love the new theme). One thing that
stuck me though, is that the search builder still seems to be very
difficult to use, and almost impossible (it seems) to do what should
be a simple thing without going into the advanced window.

The Primary difficulty is constructing queries with variations of AND
and OR, and nesting,

For example… Constructing a fairly standard query like

Subject LIKE ‘abc123’ AND Queue = ‘General’ AND ( Status = ‘new’ OR
Status = ‘open’ )

using the point/click search builder seems impossible, or at least,
not intuitive, I can’t workout how to do it.

[snip]

Is this is a bug in the new version, or just the way query builder
works… or am I just doing it wrong?

In truth, I usually add about half of that then go to the advanced
box. My theory is that the interface is intuitive to the authors of
DBIx::SearchBuilder but presents challenges to the rest of us :wink:

it’s challenging for everybody.

Cheers,
Michael

Best regards, Ruslan.