Search Box - Adding a WHERE condition to the SOSL Query

  • 1
  • Question
  • Updated 4 years ago
Merged

This conversation has been merged. Please reference the main conversation: Search Component - Filter

It'd be helpful for me to specify a WHERE statement to the SOSL query in the search component. This seems fairly straight foward given SOSL syntax.

ExampleSOSL:
FIND {Joe Smith}
IN Name Fields
RETURNING lead (name, phone Where createddate = THIS_FISCAL_QUARTER)<br>
Here's my XML:
<search uniqueid="sk-1pOUMT-385" soslfields="Name Fields" limit="5">                                 
                                 <objects>
                                    <object id="Phrase_Template__c" displaytemplate="{{Text_English__c}} {{Phrase_Type__c}}">
                                       <fields>
                                          <field id="Phrase_Type__c"/>
                                       </fields>
                                    </object>
                                 </objects>
                              </search>


Is there a way to write in a WHERE statement in <field id="Phrase_Template__c"/>?
Photo of Griffin Brown

Griffin Brown

  • 2,818 Points 2k badge 2x thumb
  • close to an epic solution

Posted 4 years ago

  • 1

There are no replies.

This conversation is no longer open for comments or replies.