This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



May 1, 2013, 10:53 PM
453 Posts

Re: Search In view Results

  • Category: Server Side JavaScript
  • Platform: Windows
  • Release: 8.5.3
  • Role: Developer
  • Tags: search in view results
  • Replies: 11
After posting my original query I realized that I really did not want to reset the Selection formula but do a full text search. I have created the following code in the search for the the dataView in question


var user = context.getUser().getFullName();
var qString  = "(FIELD ACCurrentApprovers CONTAINS \"" + @UserName() + "\")"
return qString

I have used both the var user and the @UserName() but with either case I geta 500 Internal Server Error.

From what I have read and looked  seen this should work. It compiles without error.

I'm at a bit of a loss on this.  
May 2, 2013, 12:13 PM
4 Posts
Debugging approach
Baxter's latest makes sense. Failing that, I would probably try debugging like: Make sure the db is full-text indexed. (I know, duh, right? But I've overlooked that before more than once.) I'd also make sure the query works in Notes, with the specified view. First I would probably do a print statement to check in the server console the name values you're trying, so I could use them in the query in Notes.

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal