5 Replies Latest reply: Jan 2, 2017 4:00 AM by Matus Kelemen RSS

    Variable in the front end

    Aniruddhya Dutta

      Hi all,

       

      I am trying to provide a variable box in the front end where user can input date manually.

       

      Ist step:

      I drag a variable object in the front end

      variable.PNG

       

       

      2nd step:

      I tried to create a variable which I can bind with the variable to fetch the max date by default.

       

      LASTDT:

      LOAD max(DATETIME) as LASTDT

      RESIDENT INPROCESS_FINAL_TABLE;

       

       

      LET vDATE = LEFT(Peek('LASTDT',0,'LASTDT'),8);

       

       

      //LET vDATE =Date(Date#(Peek('LASTDT',0,'LASTDT'),'MMDDYYYYHHMMSS'),'YYYY-MM-DD');

       

      its working and I am getting my variable text box populated with the max date.

       

      variable.PNG

       

      but the issue is when I put some other date the set analysis expression is not working which is as below:

       

      Count({$<Dates_IP={'$(=(Date(Date#('$(vDATE)','YYYYMMDD'),'YYYY-MM-DD'))'},PROC_STATUS = {'success'},DIRECTION_IP={'I'},SERVER_NAME_IP={'SBI_Dev_All_Nodes'}>}CORE_ID_IP)

       

       

      can some plz help me!!

       

      Thanks in advacnce