Hello.

I am trying to develop a search for my website which uses Facebook-Style Statuses and Facebook-Style MicroPublisher

I was able to expose Status-Text to allow users to search, but this only searches in the status text itself, not in the information in the attachment (A linked articles' title and summary for example)

Trying to expose Facebook-Style MicroPublisher: Themed attachment, and searching it results in an error (user warning: Unknown column 'fbsmp.attachment' in 'where clause' query:)

So either I am going about it the wrong way, or I need to first check if the status has an attachment before trying to search in it, but I don't know how to set Views up to search in attachment only when an attachment exists

Would appreciate any help

Thanks in advance.

Comments

publicmind’s picture

publicmind commented

It is not possible to search inside the attachment data as it isn't stored in the database as plain text but instead is in the form of serialized array which can only be deciphered by individual plugin as each of it stores the data differently. The field in the database is {fbsmp}.data which can be used in the 'where' clause.

Regards,

publicmind’s picture

publicmind commented

Will it work for you if I integrate the module with the global Drupal search?

roylazarovich’s picture

roylazarovich commented

Integrating the module with Drupal's search would be the best solution I think

Thanks