I have a remote connection to a database and it tests successfully. The database user has read only permissions to a few selected tables.
I created a list based on one of these remote table, and then went into phpMyAdmin and set it to "isview":"1" because it was throwing errors when saving. Everything appears fine when I view the list without a 'Group By' set. When I set a 'Group By' on the list, then view the list, I get an error that basically says 'local_db.table' doesn't exist, when really it should be looking at 'remote_db.table'.
Is this a know issue or something specific to my configuration?
I created a list based on one of these remote table, and then went into phpMyAdmin and set it to "isview":"1" because it was throwing errors when saving. Everything appears fine when I view the list without a 'Group By' set. When I set a 'Group By' on the list, then view the list, I get an error that basically says 'local_db.table' doesn't exist, when really it should be looking at 'remote_db.table'.
Is this a know issue or something specific to my configuration?