Query List Action assigns zero the variable or resets the variable.

Follwoing is the query action.

outside this action numSequence variable gets 0 value but when i run this query using Run Now button, it gives the correct result .

any help will be highly appreciated.

make sure the variable you filter by is populated with a value that you expect.

what are datatypes of numSequebce wf varible and list field that you query into the variable?

as you can see Sequence Number (In Sort Order) is SharePoint field and it's of type Number. I'm expecting only one INT value as result and I want to assign it to Nintex variable numSequence (data type Number)

as you can see below, the query is giving me correct answer. but it never gets assigned to numSequence variable which always returns zero.

any Help Please...

as you can see Sequence Number (In Sort Order) is SharePoint field and it's of type Number

I couldn't guess from sort by field that you return the same field and what it's datatype...

as you can see below, the query is giving me correct answer

in Run now you typed in the value to filter by on your own.

in runtime you (I guess) use a variable. therefore I suggested to make sure the variable really contains a value you want to filter by. write the variable to history log and check its content.

make as well sure it doesn't contain leading or trailing spaces.

Thanks Marian, you are the start and Nintex is crap. I had to clean the string variable in Filter field. removed 123;# and it worked as it should have.

great!

please mark the question answered.