- user_query = Query().get('user').select('user_hrn','parent_authority').filter_by('user_hrn','==','$user_hrn')
- user_details = execute_query(self.request, user_query)
-
+ # user_query = Query().get('user').select('user_hrn','parent_authority').filter_by('user_hrn','==','$user_hrn')
+ #user_details = execute_query(self.request, user_query)
+ # if sfa returns None
+ #if user_details[0]['parent_authority'] is None:
+ # find in local DB
+ user_query = Query().get('local:user').select('config')
+ user_details = execute_query(request, user_query)
+ for user_config in user_details:
+ config = json.loads(user_config['config'])
+ config['authority'] = config.get('authority')
+ user_details[0]['parent_authority'] = config['authority']
+