In VA(virtual agent) If i will provide Solution ID then it will show all the Active cases

[kranthi2]

Hi,

In VA(virtual agent) If i will provide Solution ID then it will show all the Active cases.

in VA topics if i will click below:

If i enter correct solution ID it has to show list of active cases associated with that Solution ID

If i enter wrong Solution ID it has to show please enter correct solution ID

Please help me out how can we achieve this.

Thanks,

[Ct111]

In below link user has implemented something similar for incident or request number search,

you can take it as reference and build the solution on your table.

LINK

[sanjay02]

Hi @kranthi2 ,

Step 1:
Retrieve the Solution ID from the user input.
✅ This step is already implemented.

Step 2:
Add a Script node that performs the following:

Query the Solution table using the provided Solution ID.

• If a matching record is found:

                    Display a list of active cases associated with that Solution ID.

• If no matching record is found:
           Display the message: "Invalid Solution ID. Please enter a correct Solution ID."