Display Datatable Columns

Anvil Q&A
1

I’m trying to display two columns (Horas,Nomes) associated with a third one (Data) wich is a date() type in a Repeatingpanel, so the idea is that when I click on a label with a date day it gives me all the names and hours associated with that day.

I’ve got this search funtion in the server

@anvil.server.callable
def search_hora( dia, mes , ano):
  data=datetime(day=dia, month=mes, year=ano).date()
  return app_tables.agendamento.search(Data = q.all_of(data))

and in the form calling it,

def label_day_number_click(self, **event_args):
    mes =int(datetime.now().strftime("%m"))
    ano =int(datetime.now().strftime("%Y"))
    self.agendamento.items = anvil.server.call('search_hora', self.label_day_number.text , mes , ano)
#     self.agendamento.visible=True
    pass

I think I have bound everything correctly in the Repeatingpanel.

Anyone can see the problem here? Thanks

https://anvil.works/build#clone:54QLDVJBXNQYE3TH=PKHR2WMDJ2WPO6NH25Z2ATVW

2

Hi @nea_domini
the problem is, in your data_grid_2 component, property visible is set to False

firefox_gh1rbcJgKu
firefox_PUC9snR9UJ

Set it to true.

BR