Catalog Script/ Background query

[Wade Clairmont]

Trying to build a query to return some Owner values from a custom table populated with text value network folders in catalog script.

When I try the query in the background query builder:

var test = "J:\IT Management\Ar" ;

var gr = new GlideRecord('u_network_folders');

gr.addQuery('u_ntwk_folder', 'STARTSWITH', test);

gr.query();

while (gr.next()) {

    gs.print(gr.u_primary_onwer);

}

it finds nothing and I know the records are there in the table. This used to work, as I would have built the query in there during dev back in 2020.

Did something change in Vancouver?  any thoughts?

[Brad Bowman · Accepted solution]

You are probably encountering the slash as an escape character - not sure if this is true within a string.  Try

var test = "J:\\IT Management\\Ar" ;