Variables Datum in ContentSelect

Zendesk API User

• April 13, 2011 14:33

Author: C_Klingbeil
Publication Date: 4/13/2011 14:33

Hallo Community,

ich versuche bei einem ContentSelect mit einem variabel gesetzten Datum zu vergleichen. Leider funktioniert das nur, wenn ich #global.now oder #startdate benutze. Folgendes rot markierte geht nicht, das grüne funktioniert:

    <CMS_FUNCTION name="define" resultname="fr_st_date">

        <CMS_CDATA_PARAM name="source">   

            <![CDATA[$CMS_TRIM(level:4)$ 

                $CMS_IF(!st_dateFrom.isEmpty && !st_dateFrom.equals(""))$

                    $CMS_SET(set_dateFrom,st_dateFrom)$

                $CMS_ELSE$

                    $CMS_SET(set_dateFrom,#startdate.getInstance())$

                    $CMS_VALUE(set_dateFrom.set(1,0,1))$

                $CMS_END_IF$ 

                $CMS_IF(!st_dateTo.isEmpty && !st_dateTo.equals(""))$

                    $CMS_SET(set_dateTo,st_dateTo)$

                $CMS_ELSE$

                   $CMS_SET(set_dateTo,#global.now)$

                $CMS_END_IF$ 

            $CMS_END_TRIM$]]> 

        </CMS_CDATA_PARAM>

    </CMS_FUNCTION>

    <CMS_FUNCTION name="contentSelect" resultname="fr_st_newsDate">

        <CMS_PARAM name="schema" value="news"/>

        <CMS_VALUE_PARAM name="from" value="set_dateFrom"/>

        <CMS_VALUE_PARAM name="to" value="set_dateTo"/>

        <QUERY entityType="news">

            <FILTERPARAM datatype="java.util.Date" parameter="from" value="-9999999990000" />

            <FILTERPARAM datatype="java.util.Date" parameter="to" value="9999999990000" />

            <AND>

                <GTE attribute="date" parameter="from"/>

                <LT attribute="date" parameter="to"/>

            </AND>

            <ORDERCRITERIA attribute="date" descending="1"/>

        </QUERY>

    </CMS_FUNCTION>   

Ich bekomme zwar für set_dateFrom wie bei #global.now einen GregorianCalendar, aber die Funktion liefert kein Ergebnis.Auch #global.now.getInstance() alleine funktioniert nicht. Hat jmd. eine Idee, warum das so ist?

Viele Grüße,

C.Klingbeil

FS4.2R4(432)

Tags: calendar, contentselect, date, fs4.2r4

Related to

• Developers

0

• 

  Zendesk API User

  • April 14, 2011 13:50

  Author: MarcusDau - 4/14/2011 13:50
  

  Ich mache in einem ContentSelect folgendes:

  <CMS_FUNCTION name="contentSelect" resultname="fr_win_jahr">                                                                                                           
          <CMS_PARAM name="schema" value="wasistneu"/>                                                                                                               
          <CMS_VALUE_PARAM name='von' value='#startdate.set("day_of_month",1).set("month",0).set("year",st_jahr).set("hour",0).set("minute",0).set("second",0).getTime()' />  
          <CMS_VALUE_PARAM name='bis' value='#startdate.set("day_of_month",1).set("month",0).set("year",st_jahr+1).set("hour",0).set("minute",0).set("second",0).getTime()' />
          <QUERY entityType="eintrag">
              <ORDERCRITERIA attribute="datum" descending="1" />                                                                                                                            
              <FILTERPARAM parameter="bis" datatype="java.util.Date" value="0"/>
              <FILTERPARAM parameter="von" datatype="java.util.Date" value="0"/>                                                                                       
              <AND>                                                                                                                                              
                  <GTE attribute="Datum" parameter="von" />                                                                                                        
                  <LT attribute="Datum" parameter="bis" />                                                                                                        
              </AND>                                                                                                                                             
          </QUERY>                                                                                                                                                   
      </CMS_FUNCTION>
   
       

  Hilft dir das Setzen meines bis-Datum-Parameters weiter?

  Grüße

  Marcus

  0

Please sign in to leave a comment.