contentSelect with cms_value_param not working?

Zendesk API User

• June 14, 2018 06:33

Author: jan_bogutzki
Publication Date: 6/14/2018 6:33

Hi Community,

i try to consolidate some contentSelect-Functions into one. Therefore i define a Variable with the required value:

<CMS_FUNCTION name="define" resultname="qf_brand">
  <CMS_CDATA_PARAM name="source">
    <![CDATA[$CMS_TRIM(level:3,char:"")$
      $CMS_IF(ss_brand.equals("streetone"))$
        1
      $CMS_ELSE$
        0
      $CMS_END_IF$
    $CMS_END_TRIM$]]>
  </CMS_CDATA_PARAM>
</CMS_FUNCTION>

This part seems to work. The result is as expected after the header section. When i try to use this value in my contentSelect i get no results:

<CMS_FUNCTION name="contentSelect" resultname="cs_blogs_so">
  <CMS_VALUE_PARAM name="qf_brand" value="qf_brand" />
  <CMS_PARAM name="schema" value="Blogs" />
   <QUERY entityType="blog" limit="50">
    <FILTERPARAM parameter="qf_brand" datatype="java.lang.Boolean" value="1" />
    <EQ attribute="brand" parameter="qf_brand" />
    <ORDERCRITERIA attribute="date" descending="1"/>
  </QUERY>
</CMS_FUNCTION>

I already tried with java.lang.Integer as well as different variable names. The default value of FILTERPARAM makes no difference.

The datatype of attribute="brand" is xs:boolean.

Did i understand something wrong from the docs?

best regards

Jan

Tags: cms_value_param, contentselect, query

Related to

• Q and A

0

• 

  Zendesk API User

  • June 25, 2018 13:36

  Author: marro - 6/25/2018 13:36
  

  Hi Jan,

  you functions do look good at first view. But I think you can't convert the value of the CMS_CDATA_PARAM to a Boolean. So I replaced (and simplified ;-) ) your first function by

  <CMS_FUNCTION name="define" resultname="qf_brand">  
    <CMS_VALUE_PARAM name="source" value='ss_brand.equals("streetone")'/>  
  </CMS_FUNCTION>

  This still hasn't worked, but by changing the datatype of the FILTERPARAM from Boolean to String finally got it working.

  Best regards

  Donato

  0
• 

  Zendesk API User

  • June 25, 2018 14:42

  Author: jan_bogutzki - 6/25/2018 14:42
  

  Hi Donato,

  thanks for your reply. This works, but additionally we have a problem with the value null. The solution is not extendable to use null as value for this boolean comparsion.

  Would be great to use conditions in the query, just to replace such hack with define-Variables.

  best regards

  Jan

  0
• 

  Zendesk API User

  • June 25, 2018 15:40

  Author: marro - 6/25/2018 15:40
  

  Well, here is a solution without define and also working with null values ;-)

  <CMS_FUNCTION name="contentSelect" resultname="cs_blogs_so">  
    <CMS_PARAM name="schema" value="Blogs" />  
    <CMS_VALUE_PARAM name="qf_brand" value='ss_brand.equals("streetone")' />  
     <QUERY entityType="blog" limit="50">
       <FILTERPARAM parameter="qf_brand" datatype="java.lang.String" value="1"/>
       <OR>
         <EQ attribute="brand" parameter="qf_brand" />  
         <IS_NULL attribute="brand" />
       </OR>
       <ORDERCRITERIA attribute="date" descending="1"/> 
    </QUERY>  
  </CMS_FUNCTION>

  Best regards

  Donato

  0
• 

  Zendesk API User

  • June 25, 2018 15:43

  Author: marro - 6/25/2018 15:43
  

  You can of course combine EQ also with NOTNULL and using AND and/or OR in combination to get the result that you want.

  0
• 

  Zendesk API User

  • June 26, 2018 05:34

  Author: jan_bogutzki - 6/26/2018 5:34
  

  Hi Donato,

  Thanks for your reply. The check if there is a null value only is required when testing for a false-Value. Thats the case i need a condition, because when true is tested, there must not be a null value result.

  best regards

  Jan

  0

Please sign in to leave a comment.