I am setting a viewScope variable for a full-text query against a view in a beforeRenderResponse. The query isn't yielding any results even though the same query in a Notes client view produce results. I have done this before and it works fine so I can't figure out the issues here.

 

The query looks right in my print statement and I have also ensured that I am yielding numbers for the viewScope.det since 'details' will be a number field in the document.

 

viewScope.put('viewName', '(xpPartDetailView)');
viewScope.put('user', session.getEffectiveUserName());
var AE = @Name('[CN]', viewScope.user);
if (viewScope.det == null){viewScope.det = @Integer("2013");};
var details = viewScope.det;
var query = 'FIELD AccountExec contains ' + AE + ' AND FiscalYear is equal to ' + details;
print (query);
viewScope.put('query', query);

 

Thanks in advance,

Kendra