[SOLVED] Searching specific properties on config items CMDB

[bengoa]

Hi folks,

We are migrating from RT to OTRS. Trying and testing our OTRS
installation, I think that I found a bug on the ITSM's CMDB module.

I've changed the Config Item Class Computer, to provide some custom
fields. Even setting Searchable => 1 on the class definition, when I try
to search on my custom attributes, I always got "No data found".

I've tried making a new installation, with brand new OTRS (3.0.11) and
ITSM (3.0.5). In this new installation no alterations on Class
Definition was made. Unfortunately, searching on CMDB at Class Computer
for items where Vendor = IBM returns "No data found".

Looking at OTRS log I found this SQL error:

Code: Select all

[Fri Dec 30 16:01:45 2011][Error][Kernel::System::ITSMConfigItem::Version::VersionSearch][966] ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...d IN (32) AND ci.last_version_id = vr.id ORDER BY ci.configi...
                                                             ^, SQL: 'SELECT DISTINCT(vr.configitem_id) FROM configitem ci, configitem_version vr  WHERE ci.id = vr.configitem_id AND ci.class_id IN (32) AND ci.last_version_id = vr.id ORDER BY ci.configitem_number DESC '

Should I open a bug report? Anybody could try this searches to confirm
this bug?

Tks in adv.

Alberto

[jojo]

for me it is working. Whats your Database system?

[bengoa]

Hello Jojo,

Tks for your reply.

for me it is working. Whats your Database system?

I'm using postgres, version 8.4.9.

When I was loading the schema and inserting initial data I received some
warnings at the psql output concerning about the use of the single
quote/double quote. Searching about this messages I found that it
is probably related with encoding. I dunno if this could be the source
of the problem.

Alberto

[jojo]

please have a look in the bug database (bugs.otrs.org)

[bengoa]

Hello Jojo,

please have a look in the bug database (bugs.otrs.org)

Ok, it's done. Looking for ITSM bugs I found this issue [1]. It was
closed but still was not deployed. It will be released with ITSM 3.0.6. I
applied the patch on my testing and production environments and it's fine.

Thanks for your help.

Any chance to set case insensitive searches? For example, an asset with
vendor = Dell is different (and brings different results) from vendor =
DELL.

[1] - http://bugs.otrs.org/show_bug.cgi?id=7855

Alberto