Idea Portal Config

[Cirrus]

Morning,

Can anyone advise if its possible to show ideas created directly in the idea table via the portal list (see attached screenshot), and if so how would we go about it? At present only ideas created in the portal via the 'Create an Idea' widget show in the list.

The reason for not using the widget is that we have a number of idea streams with complex and lengthy questioning which makes customizing the widgets unmanagable, so we are investigating the possibility of using catalog items.

Many thanks 

[Anil Lande]

Hi Cirrus,

The idea portal is part of Innovation Management application. It has some framework and all the ideas submitted are associated with the Idea category. The Widget is using M2M table to show ideas on Idea portal.

If you are using any other way to create ideas then make sure to map that idea with related idea category by creating one record in table 'im_m2m_idea_category'.

'Idea Categories <im_m2m_idea_category>' is a M2M table which store the Idea and Category relationships. 

Also there is reference field on Idea table 'Module' its hold be having value <sys_id> of 'Internal' Module from tables Idea Module <im_module>.

[Amit Gujarathi]

HI @Cirrus ,
I trust you are doing great.

1. Customize the portal: Access the ServiceNow portal and navigate to the relevant page where the idea list is displayed.

2. Modify the list view: Locate the list view code and add a new query or filter condition to fetch ideas from the idea table. You can use GlideRecord queries to retrieve the necessary data. Here's an example code snippet:

// Create a new GlideRecord instance for the idea table
var ideaGR = new GlideRecord('idea');

// Add any specific conditions or filters as per your requirements
ideaGR.addQuery('source', '!=', 'portal'); // Exclude ideas created via the widget

// Execute the query to fetch the matching ideas
ideaGR.query();

// Iterate through the result set and display the ideas
while (ideaGR.next()) {
  // Display the idea details in the desired format on the portal list
  gs.print('Idea: ' + ideaGR.getValue('short_description'));
}

1. Customize the presentation: Based on your requirements, you can format and present the retrieved ideas in the desired manner on the portal list. This can include displaying relevant information such as the idea description, author, creation date, etc.

2. Test and validate: Save the changes and test the portal page to ensure that the ideas created directly in the idea table are now being displayed in the list.