ox-it / ords

Automatically exported from code.google.com/p/ords
0 stars 0 forks source link

Filter interface not working on tables with relationships #650

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Go to the editing interface for a table with links to others
2. Observe that although the header for 'Filter Results' is displayed on 
screen, there are no filter boxes beneath it [see screenshot]
3.

What is the expected output? What do you see instead?
At present, people can only filter tables with no relationships to others.

Please use labels and text to provide additional information.

THis is using Chrome, Dev 1.0.12.

Original issue reported on code.google.com by jajwil...@gmail.com on 22 Apr 2015 at 2:49

Attachments:

GoogleCodeExporter commented 9 years ago
This seems to be a problem in RQB - I've filed a bug report.

If you look in the console you'll see something like:

"Uncaught com.google.gwt.event.shared.UmbrellaException: Exception caught: 
Exception caught: Duplicate value: 
com.redspr.redquerybuilder.core.client.expression.ExpressionColumn$ColumnCommand
@39175796"

It only occurs with Mondial - I haven't seen it elsewhere. I suspect its to do 
with reused identifiers within the schema, but I'll see what RQB suggest.

Original comment by scott.br...@gmail.com on 22 Apr 2015 at 4:38

GoogleCodeExporter commented 9 years ago
Yep - I see:

"RedQueryBuilder-0.js:1053 Uncaught java.lang.IllegalArgumentException: 
Duplicate value: 
com.redspr.redquerybuilder.core.client.expression.ExpressionColumn$ColumnCommand
@39175796"

Glad it shouldn't affect too many other databases, but still keeping at 
Critical for now given that we can't be too sure how many exactly.

I've added you as an admin to my 'Standard Test' Project on Dev.

Original comment by jajwil...@gmail.com on 24 Apr 2015 at 5:23

GoogleCodeExporter commented 9 years ago
I've added a workaround for now - we use an ellipsis to indicate that a filter 
column is actually a foreign table and not a column. 

This means that in Mondial, you can filter on "COUNTRY" (the fk column itself) 
or "COUNTRY... "(then select a column in the foreign table). 

This needs documenting for users, but does get around this problem

Original comment by scott.br...@gmail.com on 27 Apr 2015 at 7:36

GoogleCodeExporter commented 9 years ago
Workaround seems to work, I've put some tests into Selenium for it.

Original comment by scott.br...@gmail.com on 28 Apr 2015 at 1:35