Thanks for the information. I am currently federating using database connections only (PostgreSQL). The table in question is not empty and I double-checked the password. The filter is of type "singleselect". So conditions seem OK, but after nearly 1 hour, nothing happened and the table is reasonably small.
When I checked the log, I found this error in particular: org.postgresql.util.PSQLException: ERROR: relation "*genemodelfeature*" does not exist [...] The table in question should be *G*ene*M*odel*F*eature. So I believe the table/schema names in the underlying SQL query are not properly quoted, which causes the function to break when case-sensitive table names are imported from PostgreSQL. I remember I had similar problems when I tried to create data sources bases on tables in a case-sensitive psql schema. Best, Thomas Thomas Triplet, Ph.D. http://www.thomastriplet.net Centre for Structural and Functional Genomics Concordia University 7141 West Sherbrooke St Montreal QC H4B 1R6 On Tue, Jan 10, 2012 at 9:37 AM, Marie Wong-Erasmus < [email protected]> wrote: > Hi thomas, > > if you are federating using URL, update will not work..update only works > for database connections. > if nothing happens even though you're using a db connection, then either > that column in your table is empty or there is a problem with the > connection (maybe a password or something) > update also only works on singleselect & multiselect filters > > cheers, > marie > > From: Thomas TRIPLET <[email protected]> > Date: Mon, 9 Jan 2012 12:30:09 -0500 > To: Syed Haider <[email protected]> > Cc: BioMart Users <[email protected]> > Subject: Re: [BioMart Users] Single Select filter configuration > > Hi Syed, > Thanks for the information. It did the trick. However, the "update" button > doesn't work for me, nothing happen when I click on it. I was also > wondering whether it was possible to affect a value different from the > label of an item from the dropdown list. It actually relates to the custom > labels for boolean filters, but somewhat generalized. This would allow for > example, to display a nice user-friendly list of items to the user, but > send to the server a more computer-friendly value when an item is picked-up > (e.g. a numerical ID). > Thanks > Thomas > > > Thomas Triplet, Ph.D. > http://www.thomastriplet.net > > Centre for Structural and Functional Genomics > Concordia University > 7141 West Sherbrooke St > Montreal QC H4B 1R6 > > > > > > On Fri, Jan 6, 2012 at 7:20 PM, Syed Haider <[email protected]> wrote: > >> Hi Thomas, >> >> on the filter, right click and see the option 'Drop down list' for the >> list of options. UPDATE button would fetch in the SELECT DISTINCT from the >> database for this column. >> >> the customised title for boolean filters (only, excluded) is amongst the >> TODO part of design, hence not available yet as far as i can tell - you can >> see these properties disabled in the property/value panel but these are >> locked unfortunately. >> >> HTH, >> Syed >> >> >> On 06/01/2012 15:52, Thomas TRIPLET wrote: >> >>> Hello, >>> How can I define the possible values of a filter of type "singleselect" >>> in a regular access point? The webpage is currently displaying a combobox >>> for this filter, with only one value: "no data". And the tooltip indicates >>> t hat the filter is not available. I couldn't find where the potential >>> values should be specified in the documentation. Could you please let me >>> know how to do it? >>> On a similar note, is it possible to customize the labels of a boolean >>> filter (those displayed on the webpage)? >>> Thanks >>> Thomas >>> >>> >>> Thomas Triplet, Ph.D. >>> http://www.thomastriplet.net >>> >>> Centre for Structural and Functional Genomics >>> Concordia University >>> 7141 West Sherbrooke St >>> Montreal QC H4B 1R6 >>> >>> >>> >>> >>> >
_______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
