Variable Editor fields Query

[tejumes]

I have set Variable Editor into the sc_request table with the use of below Formatter

Now My request page looks like below.

Now for reporting purpose i want to see the all the fields from the variable editor as shown above in readonly.

I can bring all the values and questions into description field as said in SNGuru BUT i need each and every field separetly in any tables or views so that the user can access these fields to generate a report.

Any help on this?

I tried as said in this Reporting on Service Catalog Variables - ServiceNow Wiki   BUT I'm nt sure how to set up the where clause since we are using this variable editor in sc_request table.

I tried this

But couldn't get any record when i click on "try it" it shows blank

Please help!!

[zica]

Hi Teju S,

Here the way to tackle it : run a report on Variable ownership table [sc_item_option_mtom].

From this table, you could have all info from request, requested_item, sys_approval table. Which I think will help you to make your report.

Here a sample of screenshot :

Hope that will help you,

Kind regards,

ZA

Do not feel shy to mark correct or helpful answer if it helps or is correct

[tejumes]

Hi Zic,

Thanks for your reply, yes this table brings BUT we have Only Request configured we dont have have request item configured with the request.

I want the same list above instead of Request.Item and RITM number , I want to bring Question and Answer column. How can we related this with the request.

Say for eg: For password reset we have a RP contains some variables. (for eg below

Same variables will be reflected into the Request when we transfer into Request. as like below

We need to have the report which says like below

Request number               Request Variables Name                   Variables Questions                                                                     Value

REQ12345666                           Password Reset                                         Company                                                                                                   XXXXX

REQ12345666                             Password Reset                                     Whose password needs to be reset?                   XXXXX

like so on, it is fine to bring all question and answer for all the request

[karstenvan]

If you are processing the request in a workflow, you could just add a script task to copy these variable values into table fields (bit of a hack I guess)

current.newfieldforvariablea = current.variables.variablea;

etc...

This would require you to create a field for each variable in your request table (since you say you are doing this on requests on, not request items.   Not a good idea if this is a small specialized use case.   I would probably use this method to put the variable contents into fields, and whatever additional request info you want, into a custom reporting table and populate that with your workflow script.

[tejumes]

Hi Karsten,

I'm not used to these kind of task, its new for me . Can you please suggest me how can we approach it?

Variable editor fields is not on the workflow, Simply created Formatter for question_answer as said above in the intial question of mine.

and then in form layout of the request i pulled that name of the formatter this in turns brings all the fields in RP into the request. Now i cannot relate these into report(pulling each and every varibales for reporting purpose).

I tried to create Database view ( i think you are suggesting the same ?) as said above but i cannot relate the variables list for a request into the report.