Hi, I think on last update the belongs stoped working. I've a table that is defined like this: db.define_table("regra_entrada", Field("descricao", notnull=True, represent=nome, requires=[ IS_NOT_EMPTY(), IS_UPPER()]), Field("data_inicial", "date", widget=SQLFORM.widgets.string. widget, represent=campo_date_dia_semana, default=request.now.date() + datetime.timedelta(days=1 ), notnull=True), Field("data_final", "date", notnull=True, widget=SQLFORM. widgets.string.widget, represent=campo_date_dia_semana), # Definido as delimitações abaixo Field("modo", "integer", widget=SQLFORM.widgets.radio.widget , notnull=True, represent=lambda v, l: _dic_modo[v] if v is not None else None, requires=IS_IN_SET(_dic_modo)), Field("notificacao_sms", "boolean", notnull=True, default= True), Field("notificacao_email", "boolean", notnull=True, default= True), Field("turnos", "list:integer", represent=lambda l, v: ", ". join([db.turno(i).sigla for i in l]), requires=IS_IN_DB(db, db.turno, multiple=True, label= db.turno._format)))
Then, it's populated like this: >>> print db(db.regra_entrada.id > 0).select() regra_entrada.id,regra_entrada.descricao,regra_entrada.data_inicial, regra_entrada.data_final,regra_entrada.modo,regra_entrada.notificacao_sms, regra_entrada.notificacao_email,regra_entrada.turnos 19,OUTRO TESTE,2015-03-25,2015-05-01,0,True,True,|2|3|1| The problem is, i'm pretty sure that belongs should be working on this case, as i have already tested it on early versions. But now belongs not work, this is the outpout for belongs of field "turnos" with "3"(that is on the table, on the previous output): >>> print db(db.regra_entrada.turnos.belongs([3])).select() regra_entrada.id,regra_entrada.descricao,regra_entrada.data_inicial, regra_entrada.data_final,regra_entrada.modo,regra_entrada.notificacao_sms, regra_entrada.notificacao_email,regra_entrada.turnos Maybe something was changed on the version i'm using? Or some specific change to the postgres DAL? Web2py version: 2.9.12-stable+timestamp.2015.01.17.06.11.03 Rocket 1.2.6, Python 2.7.9 OS: Debian 8(wheezy) Postgres: "PostgreSQL 9.4.1 on x86_64-unknown-linux-gnu, compiled by gcc-4.9.real (Debian 4.9.2-10) 4.9.2, 64-bit" -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.