6 Replies Latest reply: Mar 27, 2018 6:06 AM by Chanty 4u RSS

    On Demand App Navigation Link Help

    bhavani b

      Hi Experts,

       

      Can any one please help me on below issue.

      I am trying to work with on demand app generation in November 2017 version.

      I am trying to work with only one QVD based on Application field.

       

      Till now I have followed the below steps.

      Step 1:

      In the QMC > on demand apps panel > Enable the on demand app service

      Step 2:

      Created one Template app named ODAG Template app with script like below. I have attached the complete script I have used. Please let me know if i did any thing Wrong.

       

      selected_Application_tab: 

      LOAD * INLINE [ 

      SELECTED_APPLICATION

      $(odso_APPLICATION){"quote": "", "delimiter": ""}  

      ]; 


      let vTableName='A'&Date(Today(),'YYMMDD')&'JOB';

      LIB Connect TO 'SOURCE(A45863)';

      $(vTableName):

      Load Order_ID,

      APPLICATION,

      GROUPNAME,

      DATE,

      STATUS

      FROM ...qvd(qvd) where Exists(SELECTED_APPLICATION,odso_APPLICATION);


      Issue: after loading the above Template app script getting 0 lines fetched event the data is present


      Step 3:

      created one Selection app named ODAG Selection App.I have used original QVD Load only with only one additional line i.e., FLAG_COUNT. Its my original app.

      let vTableName='A'&Date(Today(),'YYMMDD')&'JOB';

      LIB Connect TO 'SOURCE(A45863)';

      $(vTableName):

      Load Order_ID,

      APPLICATION,

      GROUPNAME,

      DATE,

      STATUS,

      1 as FLAG_COUNT

      FROM ...qvd(qvd);

       

      Step 4:

      In the selection App I have created App Navigation link > by clicking on create new under App navigation links


      Selected ODAG Template App from drop down

      Expression : Sum(Flight Count)

      Maximum Row count: 10000

      Generated apps

      Maximum number : 6

      Retention time

      -    Never Expires

      Default view when opened : App Overview

      Publish to: Not Published(Saved to workspace)


      Than I have click on Create > but the App Navigation link was not created its loading more than 15 mins and did not get anything.

       

      Please help me on this. Please let me know what are these selection and Template app. Am i did any thing wrong in the script.


      Thanks in advance.

       


      Could you please help me.