Database View for sc_req_item and sys_user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-05-2018 10:19 PM
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!
- Labels:
-
Service Catalog
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2018 01:48 AM
Hi,
use below screenshots.
create view tables for sc_req_item and sys_user.
see below screenshots.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2018 01:51 AM