Use variable in Query

Forums vLooup for SharePoint Use variable in Query

This topic contains 2 replies, has 2 voices, and was last updated by  Alexander Bautz 2 days, 10 hours 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

You must be logged in to reply to this topic.