I am not able to export Request details ?

[B Ashok]

Hi Team, 

I am not able to export request details from RITM record page. 

Request details which are filled by end user and the form is created by us. When I export RITM as pdf I can see Notes, Additional comments, Main details but Request details are not exporting. 

Is that limited in ServiceNow ? and one more can we export user input details into excel sheet, will that possible ? 

[Jaspal Singh · Accepted solution]

Unfortunately this is an expected behavior. You can follow workaround as proposed by ServiceNow by following link.

[Jaspal Singh · Accepted solution]

Unfortunately this is an expected behavior. You can follow workaround as proposed by ServiceNow by following link.

[Jaspal Singh · Accepted solution]

@Ashok B I guess your question was about the issue & limitation & that is documented in link shared above. Not sure, if you had other concerns of FTP that made you mark other answer correct.

[Community Alums]

HI @Ashok B ,

The export set only supports the export of whole tables and not its relationships to others. Variables are not included in this export method either unlike a standard report.

So, would it make sense to export the contents of a request item into a separate table and then export that via export set? If it is, would the action of copying the data to the new table require scripting or is there something simpler that could accomplish this?

The goal here is to export the variables selected by a user and have that data sent to an external FTP site to be processed. Ultimately updated data would be fed back into SN via scheduled import to process a service catalog item's workflow automatically.

(Update: The approach taken is to create another table when you can dump all the results out of what you're trying to capture and have that exported out using export sets.) referred this answer from servicenow.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep

[suvro]

You may have to create a database view by merging

sc_item_option_mtom table and sc_item_option

mtom table gives relation between RITM and Variable (stores sys_id of record in sc_item_option table) and sc_item_option has the variables names and value entered by the user