equal Varchar

[go eCommerce]

Hello,

im new here. Over 30 Time i test my callflow and try to fix.

I want to create a database Query -> Works fine
Then I want to create a condition what happen on the Database Result -> I'm getting a bit desperate, the solution must be simple

EQUAL(TO_STRING(validateincommingnumber.QueryResult),"Bronze")

There are four possible results. Bronze, Silver, Gold and nothing

Here are the CFD Log Result

2024/01/22 07:52:34.007|31750|0023|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.SqlServerDatabaseAccessComponent 'validateincommingnumber' - Start executing component with server='xxx' - port='xxx' - database='xxx' - statementType='Query'
2024/01/22 07:52:34.007|31750|0023|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.SqlServerDatabaseAccessComponent 'validateincommingnumber' - Command to execute: EXEC [3cx_income] @income = 0178810xxxx
2024/01/22 07:52:34.168|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.SqlServerDatabaseAccessComponent 'validateincommingnumber' - End executing component with QueryResult: [Bronze]

2024/01/22 07:52:34.170|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - Callflow - Start executing component 'PromptPlayback2'
2024/01/22 07:52:34.170|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - Callflow - Start executing component 'conditionalComponent1'
2024/01/22 07:52:34.170|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Evaluating condition for branch 'ValidateBronze'
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Condition evaluated to false for branch 'ValidateBronze', skipping branch
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Evaluating condition for branch 'ValidateSilber'
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Condition evaluated to false for branch 'ValidateSilber', skipping branch
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Evaluating condition for branch 'ValidateGold'
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Condition evaluated to false for branch 'ValidateGold', skipping branch
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Evaluating condition for branch 'ValidateNobody'
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - Condition evaluated to false for branch 'ValidateNobody', skipping branch
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - CallFlow.CFD.ConditionalComponent 'conditionalComponent1' - No branch met the condition, moving to the next component
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - Callflow - Start executing component 'promptPlaybackComponent4'
2024/01/22 07:52:34.171|31750|0150|Trc|CallPair._expertenhotline.Main_37.Main.7579.[C:2574.2]-From script: Expertenhotline - CallID 0000018D2FF1361D_2574 - Callflow - Start executing component 'mainAutoAddedFinalDisconnectCall'

Please help me

 

[go eCommerce]

I have the solution, I have to treat the DB result as an object. EQUAL(GET_TABLE_CELL_VALUE(validateincommingnumber.QueryResult,0,0), "Bronze")

 

[Evolute IT]

I have the solution, I have to treat the DB result as an object. EQUAL(GET_TABLE_CELL_VALUE(validateincommingnumber.QueryResult,0,0), "Bronze")

You can also change the query type to Scalar and use the .ScalarResult instead.