Project

General

Profile

Actions
Copy link

Defect #1701

closed

Entity Event: add localization for bad uuid value used in filter.

Added by Radek Tomiška almost 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Low
Assignee:
Radek Tomiška
Category:
Event
Target version:
Quartz (9.6.3)
Start date:
05/29/2019
Due date:
% Done:

100%

Estimated time:
2.00 h
Affected versions:
Owner:

Description

Add localization for bad uuid value used in filter on entity id, root and parent event id.
Add search by event id int simple "fulltext" search.

Actions
Copy link
 #1

Updated by Radek Tomiška almost 5 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #2

Updated by Radek Tomiška almost 5 years ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Radek Tomiška to Ondřej Kopr
  • % Done changed from 0 to 90

I've added filter by event identifier and fixed message, when bad uuid value is used in filter.

Commit:
https://github.com/bcvsolutions/CzechIdMng/commit/697b9d3f09c0e00304f67addaa00701b1796e291

Could you do a feedback, please?

Actions
Copy link
 #4

Updated by Ondřej Kopr almost 5 years ago

  • Status changed from Needs feedback to Resolved
  • Assignee changed from Ondřej Kopr to Radek Tomiška
  • % Done changed from 90 to 100

MSSQL queries

With id:

select
    count(idmentitye0_.id) as col_0_0_
from
    idm_entity_event idmentitye0_
where
    lower(idmentitye0_.owner_type) like '%579427fe-e537-4578-a54c-040d4c0056e3%'
    or lower(cast(idmentitye0_.owner_id as varchar(255))) like '%579427fe-e537-4578-a54c-040d4c0056e3%'
    or lower(cast(idmentitye0_.id as varchar(255))) like '%579427fe-e537-4578-a54c-040d4c0056e3%';

With owner type:

select
    count(idmentitye0_.id) as col_0_0_
from
    idm_entity_event idmentitye0_
where
    lower(idmentitye0_.owner_type) like '%idm.core.model.entity%'
    or lower(cast(idmentitye0_.owner_id as varchar(255))) like '%idm.core.model.entity%'
    or lower(cast(idmentitye0_.id as varchar(255))) like '%idm.core.model.entity%';

For owner type works query well, but for id doesn't. MSSQL database transform ID's into some strange strings. For now is know issues for this database: https://wiki.czechidm.com/devel/documentation/compatibility#microsoft_sql_server

Actions
Copy link
 #5

Updated by Radek Tomiška almost 5 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF