Hello,
What is the maximum lenght of string in search criteria on search template?
In search criteria we have metadata string lenght more than 32 character and we made a query to search on that string. The query doesn't return anything.
How to avoid this long string in query?
By cutting string on 32 characters?
Even, in search result it doesn't show the documents with object_name longer then 50 characters.
Like this:
select distinct x.r_object_id, a.r_object_id as workflow_id, x.object_name, a.object_name as workflow_name, a.r_start_date as workflow_start_date, b.r_creation_date as activity_start_date, c.object_name as activity_name, b.r_performer_name as performer, t.r_component_name as pkg_name from dm_workflow a, dmi_workitem b, dm_activity c, dmi_package t, custom_object_type x where a.r_object_id = b.r_workflow_id and a.process_id='4b0000048005c682' and b.r_act_def_id = c.r_object_id and t.r_workflow_id=a.r_object_id and b.r_runtime_state in (0,1) and x.object_name=t.r_component_name and (x.object_name =t.r_component_name or substring(x.object_name,0,32)=substring(t.r_component_name,0,32)) order by a.r_start_date enable (row_based,FETCH_ALL_RESULTS 501, RETURN_TOP 500)
