SPServices GetListItems not retrieving MOSS LookUp Field

Mar 19, 2013 at 4:47 PM
With a MOSS 2007 Custom List
having a field that is a lookup type into another Custom List at the same site,
using the following fails to bring in the lookup field,
though the other (non-lookup) fields are present in the results
$().SPServices({
    operation: "GetListItems",
    async: false,
CAMLViewFields: "<ViewFields>" 
              + " <FieldRef Name='Title' />  " 
              + " <FieldRef Name='Dt_x0020_Sec_x0020_Lev' />" 
              + "</ViewFields> ",
      listName: "Media Inventory",
      completefunc: Get_MI_Completed
    });
The Single Line of Text fields, Date/Time fields, etc. are present in the response,
but not the Lookup field which is a single line of text.

The list referenced in GetListItems has 285 entries,
the looked-up value comes from a list with 126 entries.
Coordinator
Mar 19, 2013 at 5:08 PM
Is the lookup field you want in the ViewFields? What you're doing is pretty generic, so I'm not sure what the issue is.

M.