CUSTOM QUERY IN POPUPS

[inspectorflint]

Thanks, Joe, for your quick response!

I am trying to do it with the List Column popup filter. This is my business map:

<map>
<originmodule>
   <originname>SalesOrder</originname>
</originmodule>
<relatedlists>
<relatedlist>
<module>Products</module>
<linkfield>productname</linkfield>
<columns>
   <field>
<label>Part Number</label>
<name>productcode</name>
   </field>
<field>
<label>Product Name</label>
<name>productname</name>
</field>
<field>
<label>Vendor Name</label>
<name>vendor_id</name>
   </field>
<field>
<label>Unit Price</label>
<name>unit_price</name>
   </field>
          <field>
<label>brand</label>
                      <name>brand</name>
       </field>
</columns>
</relatedlist>
</relatedlists>
<popup>
   <linkfield>productcode</linkfield>
   <columns>
       <field>
           <label>Part Number</label>
           <name>productcode</name>
       </field>
       <field>
           <label>Product Name</label>
           <name>productname</name>
       </field>
       <field>
           <label>Unit Price</label>
           <name>unit_price</name>
       </field>
       <field>
   <label>Brand</label>
           <name>cf_1267</name>
       </field>
 <field>
   <label>Season</label>
           <name>cf_1268</name>
       </field>
   </columns>
   <conditions>
       <condition>
           <forfield>productid</forfield>
           <value>[{"fieldname":"cf_1262","operation":"equal","value":"cf_1267","valuetype":"rawtext","joincondition":"and","groupid":"0","groupjoin":""}]</value>
       </condition>
   </conditions>
</popup>
</map>

The problem appears with the condition: I need that the popup query only show the products assigned to one brand, that the user select in the sales order whith the field cf_1262. In the products module, this field is the cf_1267, but  it don´t works.

Also I try with the same condition value that appears in the Popup Query Conditions in the documentation:

<value>[{"fieldname":"unit_price","operation":"less than","value":"5","valuetype":"rawtext","joincondition":"and","groupid":"0","groupjoin":""}]</value>

and it dont work, too

Any idea? Thank you