databaseview help

[Gemma4]

Hi All,
I'm trying to create a database view to hold the request, request item information and display the variables and variable values. So far, I've been able to create the view successfully but several of my variable values are not displaying correctly. See attached. I created a database view using
sc_item_option with where clause mtom.sc_item_option=var.sys_id
sc_item_option_mtom- no where clause
sc_req_item with where clause req.sys_id=mtom.request.item

The purpose of this database view is to view all the historical requests, request items and variables and variable answers. If there is a better approach, I'm open to trying that.
Thanks for any feedback you can provide!
Gemma

[James Chun · Accepted solution]

Hi @Gemma4,

Have you considered creating a List type report on the [sc_req_item] table?

E.g.

You can add all the variables and details of the [request] as well by dot-walking.

Cheers

[Gemma4]

Thanks so much the report worked perfect