AnsweredAssumed Answered

Creating list variable (array) and using them?

Question asked by Stigge on Apr 20, 2016
Latest reply on Apr 21, 2016 by erolst

Hi.. its me again =)

 

Now i got another issue i seem not to be able to solve.

 

Tables:

- Software

- Logs

 

Software Fields:

ID, HostName, Software, Installed ver, License, Record ID

 

Log Fields:

ID, HostName, Status, Field info, Start text, New Text, Date, Account

 

My task in a script is to get the following matcher per record i have in to Logs:

 

Logs --> Record 1

ID = Software::ID

HostName = Software::HostName

Status = "Logged"

Field info = Software::Record ID & " - " & Software::Software

Start Text = Software::ID    <--- Record 1 collects the first field from record 1 in Software

New Text = Software::ID    <--- Record 1 collects the first field from record 1 in Software

 

Logs ---> Record 2

ID = Software::ID

HostName = Software::HostName

Status = "Logged"

Field info = Software::Record ID & " - " & Software::Software

Start Text = Software::Software    <--- Record 2 collects the second field from record 1 in Software

New Text = Software::Software    <--- Record 2 collects the second field from record 1 in Software

 

etc ....

 

Am stuck at trying to create the script for this.. :/

I would like to use List($MyList) but i dont know how to set the values in the list and then get them out to the fields.. :/

Anyone who can teach and old dog this ? =D been googling now for like hours :/

Outcomes