cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Advisor

Idea Exchange Dashbaord

Is there a component that could essentially display all of a user's ideas submitted to the Idea exchange? I imagine this being either in their profile 'Ideas I have submitted' or a filter option on the Idea Exchange page itself "Sort by My Ideas'. 

Any info is appreciated!

10 Replies 10
Highlighted
Honored Contributor

Unfortunately there is not - We are actually planning on developing this ourselves in the near future as we prepare to launch our own IE - Once we get further along will see what we can share to maybe help you/others along with it (Lithium wanted over $15k to develop it!!).  

FYI if you didn't know - You can use the search csv export function (Has to be enabled by Lithium) to report on all of your ideas which you won't find in reporting either.  See this thread for how: https://community.lithium.com/t5/Search-tools/Export-community-search-results-to-a-CSV-file/ta-p/376...

 

 

Highlighted
Occasional Contributor

We need this too. Our customers are finding it hard to find the status of all their ideas in one place. 

@mvanpelt

You can get all ideas post by users in community using below API.

SELECT * FROM messages WHERE conversation.style='idea' AND author.id='2'

This API will return all the ideas posted by the user.

.......
Do you know we work with Kudos and Accepted Solution.
Highlighted

Hey Parshant, 

If we want to include pagination in the my ideas section as you mentioned in the previous comment, what is the code(API) for the pagination? Thanks!

Highlighted
Highlighted

Hey @Parshant,

Thanks for sharing the API code, it works but it shows all the ideas along with their comments, I want to display only the ideas not the comments in the ideas.

Code 

SELECT id, href, view_href, author.view_href, author.id, author.login, subject, body, status.key, status.name, kudos, tags, post_time_friendly, post_time, parent, conversation.messages_count FROM messages WHERE conversation.style='idea' AND board.id = 'AnaplanIdeas' AND author.id='74' ORDER BY post_time DESC LIMIT 4 OFFSET 4

Please help, Thanks!

Highlighted

Adding "depth=0" to the WHERE clause will filter the results to topic messages only.

Highlighted

Thank you!

Highlighted

Hi @karthikeyan,

As mentioned by @SuzieH, you can use the depth=0.

This will give you the main topics of messages.

SELECT id, href, view_href, author.view_href, author.id, author.login, subject, body, status.key, status.name, kudos, tags, post_time_friendly, post_time, parent, conversation.messages_count FROM messages WHERE conversation.style='idea' AND board.id = 'AnaplanIdeas' AND author.id='74' AND depth=0 ORDER BY post_time DESC LIMIT 4 OFFSET 4
.......
Do you know we work with Kudos and Accepted Solution.