By using import set number Can i Get what data is imported in staging table? is there any way?

[manibabu]

Hi All

          I need to query data from import set table by using imporset number and data is imported in importset row? is it possiable? i write query like this iam unable to get data 

 var import_set_gr = new GlideRecord ('sys_import_set');
 import_set_gr.addQuery('table_name','u_eitms_esp_integration');
 import_set_gr.orderByDesc('sys_created_on');
 import_set_gr.setLimit(1);
 import_set_gr.query();
 if(import_set_gr.next())
 {
 if (source.sys_import_state == 'ignored' && source.sys_import_state_comment != 'No field values changed' )
 {
// gs.log ('insert this These Records in Transform Map for processing'+import_set_gr.u_model);
//var import_set_gr = new GlideRecord ('sys_import_set');
 var exeception_set_gr = new GlideRecord ('u_eitms_exception_list');
 exeception_set_gr.initialize();
 exeception_set_gr.u_serial_number = import_set_gr.u_serial_number;
 exeception_set_gr.u_model = import_set_gr.u_model;
 exeception_set_gr.u_model_category = import_set_gr.u_serial_number
 exeception_set_gr.u_code = import_set_gr.u_code;
 exeception_set_gr.u_asset_create_date = import_set_gr.u_asset_create_date;
 exeception_set_gr.u_building_id = import_set_gr.u_building_id;
 exeception_set_gr.u_dept_no = import_set_gr.u_dept_no;
 exeception_set_gr.insert();
 }
}

[Prateek Gupta3]

Hi

 if (source.sys_import_state == 'ignored' && source.sys_import_state_comment != 'No field values changed' )

In the above line, instead of using "source.sys_impprt_state", please try : "import_set_gr.sys_import_state"

Because here source object will not work.

Thanks,

Prateek Gupta

[manibabu]

Hi thanks for your response but i am using this code in onbefore transform script

[Ashutosh Munot1]

HI,

Use below code:

var import_set_gr = new GlideRecord ('sys_import_set');
 import_set_gr.addQuery('table_name','u_eitms_esp_integration');

import_set_gr.addQuery('sys_import_set',import_set.number);//Remember import_set will always Contain GlideRecord for current import set map.
 import_set_gr.orderByDesc('sys_created_on');
 import_set_gr.setLimit(1);
 import_set_gr.query();
 if(import_set_gr.next())
 {
 if (import_set.sys_import_state == 'ignored' && import_set.sys_import_state_comment != 'No field values changed' )
 {
// gs.log ('insert this These Records in Transform Map for processing'+import_set_gr.u_model);
//var import_set_gr = new GlideRecord ('sys_import_set');
 var exeception_set_gr = new GlideRecord ('u_eitms_exception_list');
 exeception_set_gr.initialize();
 exeception_set_gr.u_serial_number = import_set_gr.u_serial_number;
 exeception_set_gr.u_model = import_set_gr.u_model;
 exeception_set_gr.u_model_category = import_set_gr.u_serial_number
 exeception_set_gr.u_code = import_set_gr.u_code;
 exeception_set_gr.u_asset_create_date = import_set_gr.u_asset_create_date;
 exeception_set_gr.u_building_id = import_set_gr.u_building_id;
 exeception_set_gr.u_dept_no = import_set_gr.u_dept_no;
 exeception_set_gr.insert();
 }
}

Thanks,
Ashutosh munot

[manibabu]

Hi thanks for response actually i try find count of no of records are inserted and no of records are updated

i written like this

var query='table_nameLIKEeitms^sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()^state=processed'
var import_set_gr = new GlideRecord ('sys_import_set');
import_set_gr.addEncodedQuery(query);
import_set_gr.orderByDesc('sys_created_on');
import_set_gr.setLimit(1);
import_set_gr.query();

while(import_set_gr.next())
{
var import_set_gr1 = new GlideRecord ('sys_import_set_row');
import_set_gr1.addQuery('sys_import_set.number',import_set_gr.number);sys_import_set.numberSTARTSWITHISET0106604
import_set_gr1.query();
var count=import_set_gr.number;
gs.print(count);
while(import_set_gr1.next())
{
if (import_set_gr.sys_import_state == 'ignored' && import_set_gr.sys_import_state_comment != 'No field values changed' )
{
gs.print('In condition');
}
}
}

Thanks & Regards

N.manikanta