What does your model look like? -Jim
On Thursday, December 20, 2012 2:15:20 PM UTC-6, Christian Espinoza wrote: > > 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. > > --
