Hi All,
Kindly help with the below request.
In an already working search form, i have to include wild card search. block in loaded by execute query before which we are SET_BLOCK_PROPERTY(l_ew_block_id,DEFAULT_WHERE,l_where_clause1);
example
:operating_district.operating_district_code = '11p11' - working fine (working code is used)
:operating_district.operating_district_code = '11p%' - not working (not working code is used)
I am unable to query block using et_block_property default_where if I use special character "%"
working code:
l_where_clause1 := 'operating_district_code = :operating_district.operating_district_code' ||
' AND EXISTS' ||
'(SELECT 1 FROM engineer_skill_equip es' ||
' WHERE es.person_no = engskill_timetable.person_no' ||
' AND es.code = :operating_district.spl_skill' ||
' AND es.category = ''SPECIALIST'')';
not working code: (replaced = with % in the fist line)
l_where_clause1 := 'operating_district_code like :operating_district.operating_district_code' ||
' AND EXISTS' ||
'(SELECT 1 FROM engineer_skill_equip es' ||
' WHERE es.person_no = engskill_timetable.person_no' ||
' AND es.code = :operating_district.spl_skill' ||
' AND es.category = ''SPECIALIST'')';
pls let me know what is the issue is
Regards,
Balaji