Outage approval

[manumanoj]

Hi All,

In sysapproval_approvar were source table is cmdb_ci_outage here i need to display type is outage which are available in cmdb_ci_outage
 

[Dr Atul G- LNG]

HI @manumanoj 

May i know how you build the relation of approval and Cmdb_ci_outage table.

[AmeliaDean]

To display the type of outages available in the cmdb_ci_outage table within the sysapproval_approvar source table, you can implement a query or script that filters and retrieves the desired information. Here's a potential approach:

SELECT type
FROM sysapproval_approvar
WHERE source_table = 'cmdb_ci_outage'
AND type = 'outage';

Ensure that you adjust the query according to your database schema and naming conventions if necessary.

As someone venturing into game development, I'm eager to explore both the player's perspective and the coding side. I've been diving into online gaming and now I'm curious about front-end development. Recently, I've been browsing through reviews on https://notgamstop.com/ to learn more about casinos not on Gamstop, especially since they offer a broader range of games and betting options, along with simpler verification processes. It's crucial to note that these sites aren't under the same regulatory scrutiny as UK casinos, so I'm being careful in my selections.

[manumanoj]

Hi 

In the now mobile application need to configure it announcements approval in the sysapproval_approver we can't specify type were source table is cmdb_ci_outage 

[Dr Atul G- LNG]

Hi @manumanoj 

Is this working in native view?