HashTag search
By Prakash Reddy on Sunday, 04 January 2015
Posted in Tips & Tricks (Not Supported)
Replies 4
Likes 0
Views 1.1K
Votes 0
I want to write an application for searching using hashtags (join operation) and obtain the results in some format to create say a report on what kind of posts are used with combination of tags.

please show me a way to kickstart it. also tell me if this is possible.

Thanks,
Satish
Hello Satish,

I am sorry but there's actually no examples for this but you should take a look at the #__social_stream_tags table where it contains a list of hashtags being used in the post and you probably need to join it back with the stream table to get the stream.
Mark
·
Monday, 05 January 2015 12:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I'm not sure why you don't have the #_social_photo_tag because in my local the table is there: http://screen.stackideas.com/2015-01-06_1136.png Can you provide us your phpmyadmin access? and also your backend and FTP.
Nik Faris
·
Tuesday, 06 January 2015 11:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Sorry, its my fault.. i checked different phpmyadmin. I could find the tag table, also the stream table.
how is there any other table where the tags and stream are correlated?
purpose is to find all related posts using the given hashtag.
thanks
Prakash Reddy
·
Tuesday, 06 January 2015 11:45
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

If you tag using the stream post, the tag will be stored in #_social_stream_tags and if you tag on the photo, it will be stored in #_social_photo_tag .
Nik Faris
·
Tuesday, 06 January 2015 12:23
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post