07-01-2016 09:35 AM - edited 03-14-2019 04:18 PM
I have an existing script which Im trying to understand
Ive attached some files
Db Lookup - What does this do - Lookup value 1- Does this tell ICM to use column 1 as the primary key going forward
Set Properties- If the Primary key in table ServicePromptEnabled is blank then put the text "NULL"in call variable1 - is this correct?
If it is false what is put in Call variable1 - ? is it what ever the contents of primary key in table ServicePromptEnabled
So it set the primary key to be column 1
Then is set properties based upon the contentsof column one - if blank put the word " NULL" in call variable 1 , if not blank put the contents of column one in variable 1- is this correct?
07-01-2016 03:28 PM
No, this tells it to look for a 1 in the DB like (select * from DB where column = 1).
Can't answer any of your other questions as you've provided no details around your DB or scripts.
david
07-04-2016 01:11 PM
David
Thanks for your reply. I go further
Database table
Column 1, column 2, column 3
1 , wr,
Node, step 1
Dblookup tblxyz
Value 1
Node, step 2 sets a variable to be put in call variable1
Value
Dblookup:tblxuz==wr
To me the script seems to say check the contents of row 1 - done by the step dbtbkexyz value 1 and look for text wr in any column and put that in call variable 1
Is that correct?
Going further
If I need for the script to look for a certain 'text' in the database in a certain column called something, The text may be in column 2 or 3 as example
Column 1, column 2,column 3
1 , tr, hg
Then do I configure a node such set variable
Value
dbybkexyz column 2==tr
So check dB xyz and look in column called 2 and if matches tr place it in a call variable
If I wanted to look for hg in column , then it would be
value
dbtbkexyz, column 3==hg?
How would I look for contents in a table which has multiple rows?
Thanks, just learning scripting
07-05-2016 10:51 PM
Can anyone advise, comment
Thanks
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide