[PyMongo] Value from nested JSON object in column_list

[nstanke]

Hello,

I'm not sure if the following is a bug/not implemented, so please excuse if this doesn't belong here.

Following situation:

I have the following json snippet in my MongoDB:

[{
	"firstname": "Test",
	"surname": "Test",
	"email_address": "example@example.com",
	"country": "Austria",
	"holiday_home": {
		"address": "",
		"address_2": "",
		"city": "",
		"country": "Germany",
		"postal_code": "",
		"state_province": ""
	}
}]

I managed to display the "first level values" (firstname, surname, email, country) in a "standard view" like this without any issues:

class RegistrantView(ModelView):
    column_list = ('firstname', 'surname', 'email_address', 'country')
    form = RegistrantForm

Unfortunately I do not manage to access the key/values stored nested in "holiday_home".

I've tried numerous ways, like column_list = ([holiday_home]['country']) but unfortunately didn't succeed.

Hence I'd like to ask if this is even possible using flask-admin with pymongo.

[julien66]

Hi,

Stumbling across the exact same issue today.
I'm not knowing either the proper way to achieve that.
I suppose it may be way simpler that what I did (no Flask-Admin expert here) but I decided to post here as it might save time to others...

I just overrided my flask_admin_custom.contrib.pymongo.views
so that :

def _get_field_value(self, model, name): 
  try:
     keys = name.split('.')
     return reduce(dict.get, keys, model)
  except AttributeError:
    return model.get(name) 

instead of just

def _get_field_value(self, model, name):
   return model.get(name) 

It does allow me to add my nested fields columns_list just "naturally-mongo-alike" : "product.client.name"

[julien66]

Self responding here but since I use Flask Admin more I realised that this need is probably just usually covered by the use of a custom column formatter.

def _client_code_formatter(view, context, model, name):
    mk = "%s (%s)" % (model['product']['client']['name'], model['product']['client']['code'])
    return Markup(mk)

The whole model is accessible from formatters and it's easy to get what you need.