Hi,

I have an issue with filtering using the Filter tool in the sense that the first line is considered invalid and I think it has to do with the automatic guessing of column types.

The condition is like: c4 !='XXX'

The value of c4 for the first line is ‘NA’

When the paster.log is checked one can see that the last argument for filtering.py are the column types:

"str,str,int,int,int ". As you can see for whatever reason, the system thinks c4 is an int, it should be ‘str’. Indeed, most values for that field look like numbers but they should be treated as string types.

 

In an attempt to override the guessing, a custom tabular type was defined in lib/galaxy/datatypes/tabular.py as such:

class CloneAdminTable( Tabular ):

    """

    Tabular format Clone Administration

    """

    column_names = ['Name', 'SeqInAlignment', 'Family', 'Animal/library', 'NR Cluster']

    column_types = ['str','str','int','str','int']

    def display_peek( self, dataset ):

        """Returns formated html of peek"""

        return Tabular.make_html_table( self, dataset, column_names=self.column_names )

 

 

But that seems not to help very much; the system still guesses the column types.

 

Any idea how to solve this ?

Thanks and regards,

Marc