How to add a Category to an existing Idea?

[Akif Shah]

We just upgraded to Orlando and i wanted to see how to add a category to an existing Idea?

I already created a new Category in the [im_category] table called "Test Category" and i wanted to assign an existing Idea [IDEA000001] to this category. How can we achieve this?

[Miguel Donayre]

That is the issue. There was a major upgrade to the Idea module from previous versions. It is now called Innovation Management 

https://docs.servicenow.com/bundle/orlando-it-business-management/page/product/innovation-management...

Here is the documentation to adjust old records to the new set up in Orlando 

[Akif Shah]

Thanks for looking up the document for me. This was the document i was looking at earlier and it says to map existing ideas to new categories and my question precisely is how do we map the idea to a newly created category?

[Miguel Donayre · Accepted solution]

Make sure that every idea should have its m2m record in im_m2m_idea_category table. (create m2m mapping in the im_m2m_idea_category table between existing ideas and categories.)

[Miguel Donayre]

also, I would check the new Idea core table - (im_idea_core) and make sure the old idea has the Module set to "Internal"

you can also look at this post to see how others solved other issues that have come up 

https://community.servicenow.com/community?id=community_question&sys_id=4bee1c5adb38045013b5fb243996...

[kjain]

@Miguel Donayre is it possible to do bring all the ideas at one go in this table without doing it manually.

Thanks!