Use variable in Query

Forums vLooup for SharePoint Use variable in Query

Viewing 4 reply threads
  • Author
    Posts
    • #18385
      Michael
      Participant

      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

    • #18429
      Michael
      Participant

      Do you Need any additional informations about this?

      Regards,
      Michael

    • #18475
      Alexander Bautz
      Keymaster

      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

    • #18509
      Alexander Bautz
      Keymaster

      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

    • #18557
      Michael
      Participant

      Hi Alexander,

      the variable now works!

      Thanks a lot for your help!!

      Regards,
      Michael

Viewing 4 reply threads
  • You must be logged in to reply to this topic.