if filter in self.filters:
or_list = []
for v in self.filters[filter]:
- or_list.append("%s like '%s'" % (filter,v))
+ or_list.append("%s like '%s'" % (filter,v.replace('*','%')))
sqlwhere.append('(' + ' or '.join(or_list) + ')')
# TODO : ajouter filtres min_*/max_*, avant/apres dans ce sqlwhere
self.sqlwhere = ''
for f in sqlwhere:
self.sqlwhere += ' and ' + f
- # filtrage : valeur en cas de limite ("top n" en ODBC), 50 maxi
+ # filtrage : valeur en cas de limite ("top n" en ODBC), 100 maxi
if 'limite' in self.filters:
- self.sqllimit = min( int(self.filters['limite'][0]), 50 )
+ self.sqllimit = min( int(self.filters['limite'][0]), 100 )
else:
- self.sqllimit = 15
+ self.sqllimit = 30
# filtrage : si aucun statut n'est spécifié, on prend "statut like non%"
if not 'statut' in self.filters:
self.sqlwhere += " and (statut like 'non%') "
if 'limite' in self.filters:
self.sqllimit = min( int(self.filters['limite'][0]), 200 )
else:
- self.sqllimit = 15
+ self.sqllimit = 50
# TODO : ajouter filtres tri_asc/tri_desc
self.sqlorder = ''