Idea Exchange Dashbaord

[mvanpelt]

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!

[StanGromer]

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...

[KiranChadha]

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

[Parshant]

@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.

[karthikeyan]

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!

[Parshant]

@karthikeyan

Check out these below link of related discussion on custom pagination.

1. https://lithosphere.lithium.com/t5/Developer-Discussion/Implement-custom-pagination/m-p/106695

2. https://lithosphere.lithium.com/t5/Developer-Discussion/Custom-pagination-refuses-to-cooperate/m-p/2...

3. https://lithosphere.lithium.com/t5/Developer-Discussion/Freemarker-Pagination/td-p/57090/page/2

[karthikeyan]

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!

[SuzieH]

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

[karthikeyan]

Thank you!

[Parshant]

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

[karthikeyan]

It works, Thanks @SuzieH and @Parshant 🙂