Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Brite
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse
Brand Logo

NetXMS Forum

  1. Home
  2. Support
  3. Usage of New column configured and using it in transformation script

Usage of New column configured and using it in transformation script

Scheduled Pinned Locked Moved Support
4 Posts 2 Posters 24.2k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • N
    N
    Nagav
    wrote on last edited by
    #1

    Hi, I have one table type dci with 5 columns, which is already collecting data, now if I edit the DCI and add new 6th column Col6 ,  I could not call newly added column in transformation script like
    idxcol6 = $1->getColumnIndex("Col6");
    $1->set(i,idxcol6, 2);
    I get error as "Error 19 in line 2: Function or operation argument is not a whole number"
    I get this error even after I restart the server and agent
    But in column definition I could see new column being added
    Is it not possible to configure add new column to DCI and use it in transformation script?

    1 Reply Last reply
    0
    • V
      V
      Victor Kirhenshtein
      wrote on last edited by
      #2

      Hi,

      the problem is that in transformation script you got table as it received from agent. If you want to fill additional column in transformation script you should add it in script like this:

      $1->addColumn("Col6");

      Best regards,
      Victor

      1 Reply Last reply
      0
      • N
        N
        Nagav
        wrote on last edited by
        #3

        Hi
        Is it not possible to add more than 10 columns using $1->addColumn("Column Name"); ?
        If I try to add 11th column and set value to it using transfermation script,  it is not getting displayed in Table latest value
        How to add 11th column ?

        Thanks
        Naga

        1 Reply Last reply
        0
        • V
          V
          Victor Kirhenshtein
          wrote on last edited by
          #4

          Hi,

          there are no limit on number of table columns. Can you show full script, maybe problem is elsewhere?

          Best regards,
          Victor

          1 Reply Last reply
          0

          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

          With your input, this post could be even better 💗

          Register Login
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          Powered by NodeBB Contributors
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • Users
          • Groups