Lithosphere The Lithium Community

%3CLINGO-SUB%20id%3D%22lingo-sub-480964%22%20slang%3D%22en-US%22%3EIdea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-480964%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20component%20that%20could%20essentially%20display%20all%20of%20a%20user's%20ideas%20submitted%20to%20the%20Idea%20exchange%3F%20I%20imagine%20this%20being%20either%20in%20their%20profile%20'Ideas%20I%20have%20submitted'%20or%20a%20filter%20option%20on%20the%20Idea%20Exchange%20page%20itself%20%22Sort%20by%20My%20Ideas'.%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20info%20is%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490917%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490917%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20works%2C%20Thanks%26nbsp%3B%3Ca%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28708%22%3E%40SuzieH%3C%2Fa%3E%26nbsp%3Band%26nbsp%3B%3Ca%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34821%22%3E%40Parshant%3C%2Fa%3E%26nbsp%3B%3CIMG%20class%3D%22emoticon%20emoticon-smileyhappy%22%20id%3D%22smileyhappy%22%20src%3D%22https%3A%2F%2Flithosphere.i.lithium.com%2Fi%2Fsmilies%2F16x16_smiley-happy.png%22%20alt%3D%22Smiley%20Happy%22%20title%3D%22Smiley%20Happy%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490916%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490916%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3Ca%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73539%22%3E%40karthikeyan%3C%2Fa%3E%2C%3C%2FP%3E%3CP%3EAs%20mentioned%20by%20%3Ca%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28708%22%3E%40SuzieH%3C%2Fa%3E%2C%20you%20can%20use%20the%20depth%3D0.%3C%2FP%3E%3CP%3EThis%20will%20give%20you%20the%20main%20topics%20of%20messages.%3C%2FP%3E%3CPRE%3ESELECT%20id%2C%20href%2C%20view_href%2C%20author.view_href%2C%20author.id%2C%20author.login%2C%20subject%2C%20body%2C%20status.key%2C%20status.name%2C%20kudos%2C%20tags%2C%20post_time_friendly%2C%20post_time%2C%20parent%2C%20conversation.messages_count%20FROM%20messages%20WHERE%20conversation.style%3D'idea'%20AND%20board.id%20%3D%20'AnaplanIdeas'%20AND%20author.id%3D'74'%20AND%20depth%3D0%20ORDER%20BY%20post_time%20DESC%20LIMIT%204%20OFFSET%204%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490906%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490906%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490904%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490904%22%20slang%3D%22en-US%22%3E%3CP%3EAdding%20%22depth%3D0%22%20to%20the%20WHERE%20clause%20will%20filter%20the%20results%20to%20topic%20messages%20only.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490671%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490671%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3Ca%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34821%22%3E%40Parshant%3C%2Fa%3E%2C%3C%2FP%3E%3CP%3EThanks%20for%20sharing%20the%20API%20code%2C%20it%20works%20but%20it%20shows%20all%20the%20ideas%20along%20with%20their%20comments%2C%20I%20want%20to%20display%20only%20the%20ideas%20not%20the%20comments%20in%20the%20ideas.%3C%2FP%3E%3CP%3ECode%26nbsp%3B%3C%2FP%3E%3CPRE%3ESELECT%20id%2C%20href%2C%20view_href%2C%20author.view_href%2C%20author.id%2C%20author.login%2C%20subject%2C%20body%2C%20status.key%2C%20status.name%2C%20kudos%2C%20tags%2C%20post_time_friendly%2C%20post_time%2C%20parent%2C%20conversation.messages_count%20FROM%20messages%20WHERE%20conversation.style%3D'idea'%20AND%20board.id%20%3D%20'AnaplanIdeas'%20AND%20author.id%3D'74'%20ORDER%20BY%20post_time%20DESC%20LIMIT%204%20OFFSET%204%3C%2FPRE%3E%3CP%3EPlease%20help%2C%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490648%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490648%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F73539%22%20target%3D%22_blank%22%3E%40karthikeyan%3C%2FA%3E%3C%2FP%3E%3CP%3ECheck%20out%20these%20below%20link%20of%20related%20discussion%20on%20custom%20pagination.%3C%2FP%3E%3CP%3E1.%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Discussion%2FImplement-custom-pagination%2Fm-p%2F106695%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Discussion%2FImplement-custom-pagination%2Fm-p%2F106695%3C%2FA%3E%3C%2FP%3E%3CP%3E2.%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Discussion%2FCustom-pagination-refuses-to-cooperate%2Fm-p%2F205139%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Discussion%2FCustom-pagination-refuses-to-cooperate%2Fm-p%2F2...%3C%2FA%3E%3C%2FP%3E%3CP%3E3.%20%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Discussion%2FFreemarker-Pagination%2Ftd-p%2F57090%2Fpage%2F2%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Flithosphere.lithium.com%2Ft5%2FDeveloper-Discussion%2FFreemarker-Pagination%2Ftd-p%2F57090%2Fpage%2F2%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-490647%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-490647%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Parshant%2C%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20we%20want%20to%20include%20pagination%20in%20the%20my%20ideas%20section%20as%20you%20mentioned%20in%20the%20previous%20comment%2C%20what%20is%20the%20code(API)%20for%20the%20pagination%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-484518%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-484518%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Flithosphere.lithium.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F69752%22%20target%3D%22_blank%22%3E%40mvanpelt%3C%2FA%3E%3C%2FP%3E%3CP%3EYou%20can%20get%20all%20ideas%20post%20by%20users%20in%20community%20using%20below%20API.%3C%2FP%3E%3CP%3ESELECT%20*%20FROM%20messages%20WHERE%20conversation.style%3D'idea'%20AND%20author.id%3D'2'%3C%2FP%3E%3CP%3EThis%20API%20will%20return%20all%20the%20ideas%20posted%20by%20the%20user.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-484383%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-484383%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20need%20this%20too.%20Our%20customers%20are%20finding%20it%20hard%20to%20find%20the%20status%20of%20all%20their%20ideas%20in%20one%20place.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-482047%22%20slang%3D%22en-US%22%3ERe%3A%20Idea%20Exchange%20Dashbaord%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-482047%22%20slang%3D%22en-US%22%3E%3CP%3EUnfortunately%20there%20is%20not%20-%20We%20are%20actually%20planning%20on%20developing%20this%20ourselves%20in%20the%20near%20future%20as%20we%20prepare%20to%20launch%20our%20own%20IE%20-%20Once%20we%20get%20further%20along%20will%20see%20what%20we%20can%20share%20to%20maybe%20help%20you%2Fothers%20along%20with%20it%20(Lithium%20wanted%20over%20%2415k%20to%20develop%20it!!).%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EFYI%20if%20you%20didn't%20know%20-%20You%20can%20use%20the%20search%20csv%20export%20function%20(Has%20to%20be%20enabled%20by%20Lithium)%20to%20report%20on%20all%20of%20your%20ideas%20which%20you%20won't%20find%20in%20reporting%20either.%26nbsp%3B%20See%20this%20thread%20for%20how%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcommunity.lithium.com%2Ft5%2FSearch-tools%2FExport-community-search-results-to-a-CSV-file%2Fta-p%2F37608%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcommunity.lithium.com%2Ft5%2FSearch-tools%2FExport-community-search-results-to-a-CSV-file%2Fta-p%2F37608%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Advisor
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
Valued Contributor
Valued Contributor

Re: Idea Exchange Dashbaord

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

 

 

Reply
Loading...
Occasional Contributor KiranChadha
Occasional Contributor

Re: Idea Exchange Dashbaord

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

0 Kudos
Reply
Loading...
Honored Contributor
Honored Contributor

Re: Idea Exchange Dashbaord

@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.
Reply
Loading...
Occasional Advisor
Occasional Advisor

Re: Idea Exchange Dashbaord

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!

0 Kudos
Reply
Loading...
Honored Contributor
Honored Contributor

Re: Idea Exchange Dashbaord

Reply
Loading...
Occasional Advisor
Occasional Advisor

Re: Idea Exchange Dashbaord

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!

Tags (1)
0 Kudos
Reply
Loading...
Lithium Technologies SuzieH
Lithium Technologies

Re: Idea Exchange Dashbaord

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

Reply
Loading...
Occasional Advisor
Occasional Advisor

Re: Idea Exchange Dashbaord

Thank you!

0 Kudos
Reply
Loading...
Honored Contributor
Honored Contributor

Re: Idea Exchange Dashbaord

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