Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
Employee
Employee

Parameterised EDX

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.



Employee
Employee

Parameterised EDX

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

Parameterised EDX

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

Parameterised EDX

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

Parameterised EDX

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
Contributor III

Parameterised EDX

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

Employee
Employee

Parameterised EDX

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
Contributor III

Parameterised EDX

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.

Community Browser