Use variable in Query

[Michael]

Hi,

i try to use a var in a query without success…

I would like to doe the folowing:

I have a field in my current form with e.g. this string: “ABC123”
I would like to use a substring (only the letters!) as a query search value, so i added the following to the custom js:

var mCAML = getFieldValue("myfield").replace(/[0-9]/g, '');

in the vlookup config i used the following Syntax:

{var:mCAML}

But the query doesn’t work. I use the “Build Query” Option, not the “Write your own”..

Regards,
Michael

[Michael]

Do you Need any additional informations about this?

Regards,
Michael

[Alexander Bautz]

Hi,
I’m sorry for the late reply. It seems I might have broken the variable support in the query in one of the later versions.

I’ll get this fixed during the weekend.

Alexander

[Alexander Bautz]

Hi,
I have uploaded an incremental release of vLookup and DFFS files in the production release folder. Please test replacing these files in your current SPJS folder.

Let me know how this works out.

Alexander

[Michael]

Hi Alexander,

the variable now works!

Thanks a lot for your help!!

Regards,
Michael

[Author]

Posts