Hello, I'm using SQLFORM.grid to show a self-joined table for boss and employee. I want to show both employee's and boss's names, tittles & emails with different headers to distinguish bosses and employees. However, SQLFORM.grid doesn't replace original labels with headers on those duplicated columns, such as name, title and emails.
Here is my code, deptHead = mssql.EMP.with_alias('depthead') form = SQLFORM.grid(query..., fields=[...], headers = {'EMP.GIVENNAME' : 'Employee' , 'EMP.CN' : 'EMP_ID' , 'EMP.DEPTHEAD' : 'BOSS_ID' , 'deptHead.GIVENNAME' : 'BOSS' , 'deptHead.TITLE':'BOSS_TITLE', ...}, headers works only on EMP.CN and EMP.DEPTHEAD, but not for duplicated columns such as EMP.GIVENNAME & deptHead.GIVENNAME. How should I do to work around? -- 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.