Hi, While fetching records from postgres database using DAL API we need to decrypt some specific fields. These field names start with some specific prefix (e.g. *kny_*). Is there any way that we could override DAL functions to achieve this requirement?
Suppose we've following table: *db.define_table('taxpayer',* *Field('name'),* *Field('tax', 'boolean'),* *Field('designation'),* *Field('kny_address'), * *Field('kny_phone'))* So my this code: *queryset = db(db.taxpayer) * *myorder = db.taxpayer.id * *record_list = queryset.select(db.taxpayer.ALL, orderby = myorder) * executes this query, select * from taxpayer order by id and I want to change it to: *select id, name, tax, designation, decrypt(kny_address), decrypt(kny_phone).* * * * * Thanks in advance. --