Hi,

I'm trying to integrate Oracle database / tables in Views.
Some tables are quite special since names are composed with a dot like

ta.ble

.

So, when you compose it with a field name, it looks like

ta.ble.field

with 2 dots in the string.

This expression is confusing Views when I want to add a field since Views can't retrieve the defined handler due to the 2 dots in the expression which is parsed like this :

  • table = ta
  • field = ble.field

instead of

  • table = ta.ble
  • field = field

To correctly parse the expression, in includes/admin.inc file, views_ui_add_item_form_submit function needs to be updated.
Line 4092 :

list($table, $field) = explode('.', $field, 2);

has to be replaced by :

$last_dot = strrpos($field,'.');
$table = substr($field,0,$last_dot);
$field = substr($field,$last_dot+1);

I hope this can help someone & I hope this can be patched in Views

Comments

MustangGB’s picture

Issue summary: View changes
Status: Active » Closed (outdated)

Closing this as outdated, feel free to re-open with updated details if it's still a problem in the latest release.