SMI_SRCHQRY

Search Query Definition | #other | #language | Component: Social Media Intelligence Foundation
Column Name Description
CLIENT Client
SOCIALMEDIACHANNEL FK Social Media Channel Code
LANGUAGE FK Language Key
SOCIALPOSTSEARCHTERM FK Keyword IDs from Search Terms
Column Name Description
Column Name Description
Column Name Description
Column Name Description
ISSCHEDULINGQUERY Indicator of Scheduling or Streaming Show values
SOCIALMEDIAQUERYISACTIVE Checks if the Query is Active Show values
Column Name Description Domain name
NUMBEROFSOCIALPOSTPERPAGE Number of Social Post Requested per Page SMI_COUNT
NUMBEROFGETREQUESTSALLOWED Maximum Number of Queries on Social Media SMI_COUNT
LASTPROCESSEDSOCIALPOST Last Retrieved Social Post Details SMI_LASTPROCESSEDSOCIALPOST
SEARCHQUERYEXECUTIONINTERVAL Scheduling Frequency in Minutes SMI_COUNT
LASTCHANGEDDATETIME Search Query Last Changed Timestamp SMI_DATETIME
CREATIONDATETIME Post Creation Timestamp SMI_DATETIME
LASTACTIVATEDDATETIME Search Query Last Activated Timestamp (UTC) TZNTSTMPL
Master Data Relations | to Other Relations ↓ Join Conditions
Social Media Channel Code
Other Relations Join Conditions
Language Key
  • Language Key
  • Client
Keyword IDs from Search Terms
  • Keyword IDs from Search Terms
  • Client