Use variable in Query

Forums vLooup for SharePoint Use variable in Query

This topic contains 4 replies, has 2 voices, and was last updated by  Michael 1 month, 2 weeks ago.

  • 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

You must be logged in to reply to this topic.