def get_location_details(complete_id):
 db = current.db
 s3db = current.s3db
 locations = {}
 ctable = s3db.survey_complete
 qtable = s3db.survey_question
 atable = s3db.survey_answer
 query = ((atable.question_id == qtable.id) & (atable.complete_id == ctable.id))
 code_list = ['STD-P-Code', 'STD-L0', 'STD-L1', 'STD-L2', 'STD-L3', 'STD-L4', 'STD-Lat', 'STD-Lon']
 for location_code in code_list:
  record = db((query & (qtable.code == location_code))).select(qtable.id, limitby=(0, 1)).first()
  if record:
   widget_obj = survey_getWidgetFromQuestion(record.id)
   widget_obj.loadAnswer(complete_id, record.id)
   locations[location_code] = widget_obj
 return locations

def get_location_details ( complete_id ) : db = current . db s3db = current . s3db locations = { } ctable = s3db . survey_complete qtable = s3db . survey_question atable = s3db . survey_answer query = ( ( atable . question_id == qtable . id ) & ( atable . complete_id == ctable . id ) ) code_list = [ 'STD-P-Code' , 'STD-L0' , 'STD-L1' , 'STD-L2' , 'STD-L3' , 'STD-L4' , 'STD-Lat' , 'STD-Lon' ] for location_code in code_list : record = db ( ( query & ( qtable . code == location_code ) ) ) . select ( qtable . id , limitby = ( 0 , 1 ) ) . first ( ) if record : widget_obj = survey_getWidgetFromQuestion ( record . id ) widget_obj . loadAnswer ( complete_id , record . id ) locations [ location_code ] = widget_obj return locations
it will return a dict of values for all of the standard location questions that have been answered .