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.

Reply via email to