How to use variable of SQL query in IRD

NICE CXone API & Integrations
1

Hi… :slight_smile:
Can you help me ?
I Want to insert to ANI in the database.

Select * from dbo.aniTB Where Ani = ani<<<-----(variable of ani in IRD)

it is woking. i did get the name of the corresponding ani.
but, i can’t Insert Statement…

Insert into dbo.aniTB Values(“ani”)

that’s okay … as String “ani”
but i want to use ani as variable(variable of ani in IRD)

it could be used in Select query , but not working in Insert query

Do you know how to use variable?? :-[

Thank you.. :-*

2

Need to use a stored procedure and pass the variables to that.

Sent from my Redmi Note 3 using Tapatalk

3

Thank you..!!

I done that!! i share my query :stuck_out_tongue:

CREATE PROCEDURE InsertTB @a varchar(50), @b varchar(50) AS
INSERT INTO dbo.aniTB(test1, test2) VALUES (@a, @b)

EXEC InsertTB @a = ani , @b = ConID <<----------(variables in IRD)

4

IRD automatically turns variables into values only if they follow some comparing/assigning sign like =, >, <, <=, etc.