Hi Linda,

According documentation the function TCA.vtsSearchRow does not return a Promise, but a value. This might be a documentation error, but other functions explicitly talk about returning a Promise.

the is the way I understand the documentation.   it says Returns the whole row values if the value of columns exist. For example: {col1:"a", col2:"b",col3:"c"}. Otherwise, it returns an empty value.

then it goes further and says

When using asynchronous APIs in places where a return value from evaluating JavaScript is needed, for example, in step argument fields, the return value must be returned by calling TCA.done(result) with the return value as the result argument.

My assumption is the returned value would be the variable that is used in the TCA.done() statement which goes with the function() statement.  I am not seeing any value being passed in that variable.   Which is why I am asking for help.

You are right about the general statement in respect to the TCA functions, but the function documentation for the the function in question is different so it might be an exception...

I did put a vtscolumns= in front of the statement and I am getting an object returned to this variable.   The problem is it appears to be empty as the json.stringify returns {}

According documentation you should use:

vtscolumns=TCA.vtcSearchRow("p_UserNum","152666",",","068_VTS");

because TCA.vtcSearchRow does not return a Promise....

interesting.   so you only use the function part if you want a promise returned.

I am 99% sure using the statement you recommended will work.   My VTS has been destroyed for the night, so I will test it again tomorrow and let you know the result.

Thanks for all your help.

the vtscolumns=TCA.vtcSearchRow("p_UserNum","152666",",","068_VTS");  doesn't work

Error:  Evaluate the JavaScript code timeout.  A timeout can occur if the TCA.done/TCA.doneWithError function is not called, an exception is thrown, or if code evaluation does not finish in time.  You can modify the timeout value using the EvalJavaScriptTimeout option in the default.cfg file.

so it appears we do have to use the TCA.done statement

Hi Linda Marzik , That is a valid conclusion. I would raise an incident at LRP support and give also feed back on the documentation web site about the not correct description of the return value of the function.

At which version of TC are you? I had once an issue with VTS and DevWeb and because the API was programmed in JS, I could solve it myself for the time being. You might have a look and identify the JS that is used with TC and have a closer look yourself.