GlideRecord on sys_email ??

[hpesata]

Hi!

I am trying to query all rows from the "sys_email" table from within a script include which is called by a scripted webservice (Calgary).

Interestingly I didnt get an rows, this is my code:

. . .

var gr = new GlideRecord('sys_email');

gr.orderBy('sys_id');

gr.chooseWindow(begin, end);

gr.query();

while(gr.next()) {

. . .

}

when I tried it again after a while, it worked. can this be related to the fact, that "sys_email" is a rotated table ?

if yes, what is the correct procedure to query a rotated table from within a script ?

Thanx in advance for any suggestions!

regards,

Hans

[kyleb13281]

Navigate to the "Table Rotations" Module. Hit sys_email. On that record you will find the table rotation schedule. Each table rotation has it's own table name. in this case it is 'sys_emailxxxx', where xxxx = the table rotation number.

[hpesata · Accepted solution]

Hi!

I found out, that this was a bug in my client application.

regards,

Hans