ContributionsMost RecentMost LikesSolutionsRe: message id question thanksAbhishekIlindra no, it is a different set of number. I tried to query 832222 from the messages table and it is a completely different messgaes I am very certain they are different sets, just cannot find which table keep that second set of number Re: message id question HIVikasB no, from what I see, the messages table has only one of the 2 numbers, just the1204122 in my example above the other number832222 is a different sequence, it is not in the messages table, not sure where it stored message id question I have a question about message id I always 2 integer ids in my URL, eg: https://baord.com/t5/boardname/ThreadsSubject/m-p/1204122#M832222 the 2 numbers i have question is the 1204122 and 832222 I know on messages table, the ide is 1204122, so I can use select * from messages where id is 12041122 I know sometimes I see that number being call Thread id as well but how about the 832222 ? I see it referred as "message-id" in some url, too. For example: https://baord.com/t5/forums/replypage/board-id/boardname/message-id/832222/load-autosave/true so, where this 832222 id actually stored? which table? thanks any easy way to find post for today and yesterday... Hi, i am tyring ton find out total new thread for today or yesterday using https://mycommunity/api/2.0/search?q=SELECT count(*) FROM%20messages%20where post_time>=2024-05-01T00:00:00.000-00:00 and post_time <= 2024-05-01T23:59:59.999-00:00 and depth = 0 is there any way to filter out post_time using by calling something like getdate() or for yesterday like getdate()-1? thanks Re: Count unique users in a thread this is a good one and this is what I want. thanks Re: How do I get the total amount of post in the Community? thanksluk for me, onlyvisibility_scope = 'public' works I got this error for all other scopes. But that is not an access issue, right? {"status":"error","message":"An unexpected error occurred.","data":{"type":"error_data","code":301,"developer_message":"","more_info":""},"metadata":{}} Re: Count unique users in a thread thankskkritika again and that helps!! Re: Count unique users in a thread thankskkritika and that help but another question. Look like 1000 is the max (I tried 2000 and it said max is a 1000) is there any way to see 1001 to 2000 , something like Offset in a query? thanks Re: How do I get the total amount of post in the Community? VikasBwrote: AmarDoekhie Try these two API. You should get the approx. similar count. https://community.lithium.com/api/2.0/search?q=select%20count(*)%20from%20messages https://community.lithium.com/restapi/vc/posts/count Also, I would suggest you contact with lithium support to know it in detail. Find the helpful link here https://community.lithium.com/t5/Developer-Discussion/Support-for-Elastic-Search/m-p/436976#U436976 hi this is an old one.. but why the 2 ways give a different number.. the difference is quite significant 929438 posts vs 964034 posts Re: Count unique users in a thread HI this is an old thread and I would like a bit more information communityURL/restapi/vc/threads/id/<threadID>/participants/recent works, but it only returns 40 entries, not all my thread has way more than that, closer to a 1000. How can I make it shows all?