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
Comment #1
MustangGB CreditAttribution: MustangGB commentedClosing this as outdated, feel free to re-open with updated details if it's still a problem in the latest release.