GlideMultipleUpdate with addQuery

[Chris P_]

I'm trying to use GlideMultipleUpdate, but it behaves kinda weird...

Here's my code:

var grt = new GlideMultipleUpdate("u_grit_path_import");

grt.addQuery('u_groupname', 'BUILTIN\\Administrators');

//grt.addQuery('u_groupname', 'CONTAINS', 'BUILTIN');

//grt.addQuery('u_groupname', 'IN', 'BUILTIN\\Administrators');

//grt.addQuery('BUILTIN', 'IN', 'u_groupname');

grt.setValue("sys_import_state", 'ignore');

grt.execute();

I've tried with different options which are commented out in the above example, but I keep getting the error message:

*** ERROR *** com.glide.db.GlideSQLException:

See glide log for error details

With the following message in the log:

*** ERROR *** com.glide.db.GlideSQLException:

And when I don't get an error message, he just skips the where-clause and updates all records.

I'm at a loss, any ideas anyone?

[Chris P_]

Yes indeed, that's why I added the screenshot of the dictionary, which clearly shows the name of the table and column to be correct

[Kalaiarasan Pus]

Not really sure. Maybe it's not created at DB level. Hi-ticket might help

[Kalaiarasan Pus]

Before I give up, execute this in background script

gs.print(gs.sql('DESCRIBE u_grit_path_import'));

[Chris P_]

Field,   Type,   Null,   Key,   Default,   Extra

u_servername,   varchar(40),   YES,   ,   null,  

u_owner,   varchar(40),   YES,   ,   null,  

u_filepath,   varchar(40),   YES,   ,   null,  

u_allowed,   varchar(40),   YES,   ,   null,  

u_groupname,   varchar(40),   YES,   ,   null,  

u_folderright,   varchar(40),   YES,   ,   null,  

sys_id,   char(32),   NO,   PRI,   ,  

*** Script: undefined

[0:00:00.004] Total Time

[Kalaiarasan Pus]

You have tried this version right?

var grt = new GlideMultipleUpdate('u_grit_path_import');

grt.addQuery('u_groupname','CONTAINS','BUILTIN');

grt.setValue('field','value');

grt.execute();

Is the table a import set table?