SFMC related questions with answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla Meta

Q&A about the site for Joomla! administrators, users, developers and designers

SELECT P.ID as [Post Link],
       P.Title,
       P.Body,
       P.Tags,
       P.AnswerCount,
       P.AcceptedAnswerId as [Accepted Answer ID],
       P.CommentCount,
       C.Text,
       P.CreationDate,
       P.LastEditDate,      
       P.LastActivityDate 
       
FROM Posts as P
  INNER JOIN Comments as C
     ON P.Id = C.PostId 

WHERE P.PostTypeId = 1
  AND P.AnswerCount > 0
  AND (
        P.Tags LIKE '%##tag1##%'  /*salesforce-marketing-cloud*/
     OR P.Tags LIKE '%##tag2##%'  /*marketing-cloud*/   
     OR P.Tags LIKE '%##tag3##%'  /*ampscript*/
     OR P.Tags LIKE '%##tag4##%'  /*exacttarget*/
     OR P.Tags LIKE '%##tag5##%'  /*sfmc*/
     OR P.Tags LIKE '%##tag6##%'  /*data-extension*/
     OR P.Tags LIKE '##tag7##'    /*ssjs*/
     )   
   
ORDER BY P.ID DESC

/*
select * from posttypes
 returns:

1 Question
2 Answer
3 Wiki
4 TagWikiExcerpt
5 TagWiki
6 ModeratorNomination
7 WikiPlaceholder
8 PrivilegeWiki

*/

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results