Hi, I'm wondering about if is possible process the values of a column to show the result on the grid instead of original value... My Code: (db_events.events.device_id == request.vars.id) &\ (db_events.events.event_datetime >= from) &\ (db_events.events.event_datetime <= to)
grid = SQLFORM.grid(query, editable=False, searchable=False, deletable=False,create=False,details=False ) With this code I get : Id<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.id&_signature=acefaa93bdd83c149087600ecbf3e87539935034> C<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.device_id&_signature=acefaa93bdd83c149087600ecbf3e87539935034> odeT<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_type&_signature=acefaa93bdd83c149087600ecbf3e87539935034> ypeA<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_index&_signature=acefaa93bdd83c149087600ecbf3e87539935034> ctionD<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_datetime&_signature=acefaa93bdd83c149087600ecbf3e87539935034> ateLa<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_latitude&_signature=acefaa93bdd83c149087600ecbf3e87539935034> tLon<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_longitude&_signature=acefaa93bdd83c149087600ecbf3e87539935034> Vel<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_velocity&_signature=acefaa93bdd83c149087600ecbf3e87539935034> Dir<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_heading&_signature=acefaa93bdd83c149087600ecbf3e87539935034> PFM<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_pfm&_signature=acefaa93bdd83c149087600ecbf3e87539935034> Age<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.event_age&_signature=acefaa93bdd83c149087600ecbf3e87539935034> Od<http://127.0.0.1:8000/avl/reports/events?keywords=&order=events.vodometer&_signature=acefaa93bdd83c149087600ecbf3e87539935034> 5742356612022462768EVENT22012-12-20 15:24:52-20.23496-70.1384814.48371732 18460843.005743356612022462768EVENT12012-12-20 15:25:58-20.23064-70.13754 16.0933363218461344.005744356612022462768EVENT12012-12-20 15:26:26-20.23049 -70.138616.0933293218461461.005745356612022462768EVENT12012-12-20 15:28:49 -20.22115-70.137746.43723253218462508.005746356612022462768EVENT02012-12-20 15:29:11-20.22088-70.1394724.13953593218462702.005747356612022462768EVENT02012-12-20 15:31:17-20.21419-70.1389919.31163081218463458.005748356612022462768EVENT02012-12-20 15:34:16-20.21372-70.1469522.53022713218464303.005749356612022462768EVENT22012-12-20 15:36:17 I need change the Action column with the values of a Dic that I have: Actions = { 0:'Quiet',1:'Running',2:'Fail'} How can I show on SQLFORM.grid a 'Quiet' instead of a 0, a 'Running' instead a 1, an finally a 'Fail' instead a 2?? Greetings Christian. --
