Parameterised EDX

[#1]

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,

[StefanBackstrand]

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]

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.

[#4]

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.

[#5]

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

[#6]

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]

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]

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]

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.