Error accessing 1 row table with getValueAt function

[francoisbnc]

Hello,

I experience the following error when I try to access an one row table with getValueAt function.

Failed to resolve expression ' getValueAt($newlunssizetable,IndexLunSource)

$newlunssizetable is a input parameter as table.

IndexLunSource is the index in a loop represented by getSize($luns)

$lun is a imput parameter multiselect SQL query 

SELECT
  lun.full_path,
  ROUND(lun.size_mb / 1024,  
  0) AS Size
FROM
  cm_storage.lun AS lun,
  cm_storage.vserver AS vserver,
  cm_storage.volume AS volume
WHERE
  lun.vserver_id = vserver.id
  AND lun.volume_id = volume.id
  AND volume.name = '${myVol}'
  AND vserver.name = '${Mysvm}'

If the the table is more that one row, it works fine.

The certified command works with 1 dim 1 row array

 def getValueAt(arrayVar, index)

{
  return arrayVar.split(",")[index-1];
}

Any ideas welcome.

François

[francoisbnc]

Seems that is a complicated example, to simplify:

I just create wokflow (in attachment ) with no-ops command and I added an input parameter $inputparameter as table.

This is the content of no-op

getValueAt($inputtable,1)

The problem occurs with numeric entry and when table have only one row.

multiple rows  or alphanumeric entry: OK

[sinhaa]

Hi Francois,

This behviour of failure when using 1 numeric entry is strange, I'm looking to see why this happens. If you want to be able to proceed, you can put the numberic is single quotes like '11' and it will work fine.