Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Parameterised EDX

Does anyone know if its possible to pass a parameter in the URL to an event driven exectution? I'm looking to generate some price files as of a given point in time and need the user to be able to pass a date to server to include in the refresh. Any ideas?

Thanks,

8 Replies
StefanBackstrand
Partner - Specialist
Partner - Specialist

I'm going to assume you're running v9.

In the EDX call XML, you can specify a variable and it's value, that will be inserted in the document.

<Global method="RequestEDX" key="YOUR_EDX_KEY">
<i_TaskIDOrTaskName>MyTask</i_TaskIDOrTaskName>
<i_Password>EDX_PWD</i_Password>
<i_VariableName>testvar</i_VariableName>
<i_VariableValueList>
<string>Value1</string>
</i_VariableValueList>
</Global>

Currently, it seems to be limited to one variable, and one value.



StefanBackstrand
Partner - Specialist
Partner - Specialist

Also, if you are just in need of the date/time in the reload, you can of course get that from a macro in the script exectution of the document (or the QV script function ReloadTime()), but I suppose it's not that easy.

Not applicable
Author

Is the EDX trigger still limited to only one variable or has that been changed? I'd like to be able to pass two variables with an EDX trigger, is this possible? If so, what would the structure look like? I've tried the following with no luck:

Example: I want to pass VarModelID = 2000 and VarCompanyID = 100

[..]
<i_VariableName>VarModelID</i_VariableName>
<i_VariableValueList>
<string>2000</string>
</i_VariableValueList>

<i_VariableName>VarCompanyID</i_VariableName>
<i_VariableValueList>
<string>100</string>
</i_VariableValueList>

[..]

AND

[..]
<i_VariableName>VarModelID</i_VariableName>
<i_VariableName>VarCompanyID</i_VariableName>
<i_VariableValueList>
<string>2000</string>
<string>100</string>
</i_VariableValueList>
[..]

Any other suggestions? Is this not supported? Using version 9 SR6 with publisher/server licenses.

Not applicable
Author

Hi,

You pass one value, a concatenation of 3 values, ex text "1000+2000+3000" . Just use a separator that does not interfere with the data.

When receiving, you can split the variable with function subfield, namely subfield(Var, '+' ,1) ; subfield(Var, '+' ,2) ; subfield(Var, '+' ,3)

-Alex

Not applicable
Author

Alexandru,

That is the temp solution that I had come up with as well. Works like a charm, but I was wondering if I could truly pass values to more than one variable. Support told me that only one variable is allowed, so this work around is what I will be using.

Thanks!

brindlogcool
Creator III
Creator III

In the variablevaluelist is it possible to pass the characters in to it  like databasename since i am facing the issue like i am able to pass only one value if i send 1234 it is passing only 1. Any idea or suggestion on this

StefanBackstrand
Partner - Specialist
Partner - Specialist

brindlogcool, So, any value you pass will only be the first character? Even text strings anc such? If so, I would report that as a bug. Is this still in version 9 or later?

brindlogcool
Creator III
Creator III

Thanks Stefan,

We were using QlikView 10 SR4, i am not able to find a way out so we have reinstalled the server and it is working fine.