QV to QS conversion question

[satishkurra]

Hi Team

I'm trying to migrate a QV app to QS app. In the process, in QV, there is an action defined for the text object as below.

Action: Select in Field

Field: [Transaction ID]

Search String : "=$(cmOver%)"

"=$(cmOver%)" is defined in the Variables as 

[Insurance Type Desc]='Direct' AND $(cm_mPolicyCom%)>$(cm_iRate) AND fabs($(mmSumDirPrem)) > $(cm_iPremium)

In QV, if I click on the text object, it is selecting .

If I perform the same in QS with a button and an action as Select Values in Field, Select match values criteria, or toggle selection, the same is not applying.

Also the expression is saying Garbage after expression. Attached is the screenshot for your reference.

Not sure where I'm doing wrong.

Request to please help me on this.

Thanks

Satish

[Anil_Babu_Samineni]

I noticed with expression you have =' (Please remove ' quote after equal sign, can be same for end too). 

[satishkurra]

Hi Anil

Tried with above suggestion. Still no luck.

[Anil_Babu_Samineni]

It's good If you drill step or each condition to check. That will help. otherwise please send us sample dataset or QVF.

[satishkurra · Accepted solution]

Hi Anil

I do not why, but below workaround worked for me perfectly

1. Set Select Values in Field with no field selected. 

2. Set Select matching values criteria and value as "=$(cmOver%)"

Above workaround worked for me.