SQS on Relate and edit/display field other than name

Here you go

var filedName="assigned_user_name";

  delete(sqs_objects[filedName]);

  sqs_objects[filedName] = {

  "form": "EditView",

  "method": "query",

  "modules": ["Users"],

  "group": "AND",

  "field_list": ["username","id"], // fields to get

  "populate_list": ["assigned_user_name","id"], //fields to populate in form

  "conditions": [{

  "name": "username", // filed to search

  "op": "like_custom",

  "end": "%",

  "value": ""

  }

  ],

  "required_list": [""],

  "order": "name",

  "limit": "30",

  "no_match_text": "No Match"

  };

Sorry, I never closed this one.

I eventually found that you can just add an rname in you vardef extensions to change what field to display in the SQS

For example:

$dictionary['Cases']['fields']['parent_case_c']['rname']='case_number';

N.B. rname metadata not respected in search? 

HTH

FrancescaS