Database view
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-28-2024 10:38 AM
Hi Team,
I want to show the RITMs which are in open, pending and work-in-progress state but their related SC Tasks and Change Tasks both are closed using database view.
Please help me with this requirement.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 12:28 AM
What have you tried so far? How are RITMs being related to these other tasks? Is it via a many-to-many table or via a reference field?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 03:32 AM - edited 04-29-2024 03:33 AM
I have created database view and added ritm,sc task and change table, But now I have a records where RITM is in like open,work in progress and pending state but related task like change and sc tasks all are closed.
I just want to know how can we add filter conditions.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 03:41 AM
You'd specify your filter condition on the where clause for the table.
So if you had a table of 'sc_req_item' and a prefix of 'screq' then in the where clause you'd add 'screq_active = 1'
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 03:44 AM
How can I add multiple conditions?
