Incorrect search results using additional search arguments.
search cancel

Incorrect search results using additional search arguments.

book

Article ID: 385811

calendar_today

Updated On:

Products

CA Service Management - Service Desk Manager

Issue/Introduction

When we add a filter to list_in page with "IN" like this "alg.analyst IN ( U'The UUID of the Analyst' )" the number of records returned is wrong

when adding with equal sign like this "alg.analyst = U'The UUID of the Analyst' " the number of returned records is correct.

Environment

Service Management

Service Desk Manager

Resolution

In order for you to fix this in your environment you can use customizations by creating a new cma.maj file under:

NX_ROOT/site/mods/majic with the following content, this will replace the OTB domset with the one that is identical but with the DISTINCT requirement, you can follow the same process for other domsets if needed:

MODIFY FACTORY in DOMSET in_list_web "open_date DESC, id DESC, mintime=min(attached_slas.time_to_violation), mintgt=min(target_times.target_time), status=status.sym, priority=priority.sym DESC, ref_num" "" STATIC { DISTINCT; } ;

Restart Service Desk once you have made the change.