Database View for sc_req_item and sys_user

Bel Ngiam
Kilo Contributor

I need to generate a report on Service Request which includes the requested_for user's profile information.

The requested_for is a variable and I'm not able to expand further on that to retrieve details from the user's profile, such as user ID. I checked that I can create a database view to be able to include fields from both tables in my report.

Can anyone pls share how do I create this database view? I'm unsure what I should enter in the variable prefix and the where clause after I selected both the tables. Thanks!

2 REPLIES 2

manjusha
Kilo Guru

Hi,

use below screenshots.

find_real_file.png

 

create view tables for sc_req_item and sys_user.

see below screenshots.

find_real_file.png

 

find_real_file.png

above are for incident and problem  relationship.

i have used inc prefix for incident and prob prefix for problem.

for sc_request use prefix as :cat

User: user.

you can define where cluse in any one table.

where clause:cat_requested_for =user_sys_id.

just check by clicking try it to check is it working or not.

Mark this answer Correct if helps.

Regards,

Manjusha Bangale

 

Hi, 

see the attachments.

Regards,

Manjusha Bangale