Column with "value"

[michele-pauluzzi]

If you have a query where a column contains "value", there are problems with the lov and the popup.

popup

a search dont find the record

a search with %

The solution for now is to replace the column value with "

replace(column_value,'"','"')

I dont know if a similar html character may cause problem, such < or >.

[michele-pauluzzi]

Found another character, ' If you have a column with a 'in the value and you apply a filter for it in the pop-up, it won't find it.

same for lov

i suppose a fix will be to replace ' with '

[zhudock]

I ran into a similar issue today, with a field that contained /

It looks like a simple update to the supporting package body will resolve both your issue and mine.

Wrapping the value parameter of each dbms_sql.bind_variable( ... ) with utl_i18n.unescape_reference() appears to resolve it.

dbms_sql.bind_variable (
  v_cursor, 
  v_apex_items_names(i), 
  utl_i18n.unescape_reference(g_ajax_search_string)
);

[bostrowski]

@zhudock, @michele-pauluzzi let me check it and I will get back to you with the fixed version ;-)