641618_en-US

liliconcom

How do I use user defined variables to define a database query?

Hello, I am using JMP16. I have a pop up box to ask for user input to define two variables ("Entity", and "Last_X_Days") that I would like to use to query a database. I have no problem getting these variables defined, but the data pull query is in quotations and wont take inputs as variables. It just takes them literally. 

 

If "Last_X_Days" and "Entity" are previously defined as variables (based of the user input), how do I get the query to pull the variables and not just write literally the names of the variables? 

 

Note: I changed some of the irrelevant code to more generic terms in CAPS. 

 

Thank you!!!

 

 

script = PROGRAM:openDATABASEscript("\[

<PROGRAMINPUT>
  <TASK>
    <TASKNAME>PROGRAM</TASKNAME>
    <ADDITIONALQUERIES>
      <QUERY>
        <TASKNAME>PARAMETER</TASKNAME>
        <AUTOJOIN>1</AUTOJOIN>
        <PARAMETERS>TOOL</PARAMETERS>
        <PRIMARYENTITY>1</PRIMARYENTITY>
      </QUERY>
    </ADDITIONALQUERIES>
    <AUTORUN>1</AUTORUN>
    <EXTRACTXML>1</EXTRACTXML>
    <SITE>LOCATION</SITE>
    <DATABASEQUERY>
      <QUERY>
        <TASKNAME>DATABASEByDateRange</TASKNAME>
        <PARAMETERS>PARAMETER NAME</PARAMETERS>
        <DATERANGE><FONT color="#FF6600"><U><STRONG>Last_X_Days</STRONG></U></FONT></DATERANGE>
        <ENTITY><STRONG>><FONT color="#FF6600">Entity</FONT></STRONG></ENTITY>
        <EXCLUDEINVALID>0</EXCLUDEINVALID>
        <EXCLUDENONSTANDARD>0</EXCLUDENONSTANDARD>
        <EXCLUDEPRE>1</EXCLUDEPRE>
        <INCLUDESUBS>1</INCLUDESUBS>
        <MONITORTYPE>ALL</MONITORTYPE>
      </QUERY>
    </DATABASEQUERY>
    <TECHNOLOGY>TECHNOLOGY</TECHNOLOGY>
    <TOOLSTYLE>DATABASE</TOOLSTYLE>
    <WRITEJSL>FILE</WRITEJSL>
  </TASK>
</PROGRAMINPUT>
]\"

);

 

 

Automation and Scripting