I'm attaching my qvw file please go through it. In this file i've a qvd file with two where conditions the first condtion is working well but y the second condition is not working i don't know.
It is hard to tell what is going on since we can't run the script, but maybe you should check the first wildmatch.
Since it is a string comparison, the format of you string may be important. I noticed that vFailHydStatusCodeA looks like numerical, but is formatted with a thousand separator.
Maybe I am looking into the wrong direction though. Could you tell us a bit more precisely what you mean with "not working"?
I've a lot of where condition for the qvd file all are working good except this condition. All the other conditions are in same format only i.e with numeric values.
Ok,
- Let you assume that there is one field with numeric values and you can catch this values in one variable through the listbox(i.e. GetFieldSelections(FieldName,',',50). Now you can pass the variable to another qvw file.
- In another qvw file you need to load qvd file based on this filter.
- While loading qvd file we should make sure that..
could you be a bit more precise what do you mean with not working?
If I look at your data (given that the 2. where clause is commented) of field HydStatusCodeA, I see numericals, formated with 10 decimal places.
If you include the where clause, I assume you want to filter that field with vFailHydStatusCodeA.
In your example, this variable is 1,454 and this number is not part of the values of field HydStatusCodeA.
So, if I read your script correctly, the else part is being executed and you get all values of the field returned.
So I don't see a problem with your example right now, in other / your words, why it is not working.
Maybe you could point me to your failed expectation.
My original thought was, that using string comparison, format might matter (decimal places, thousand separator).
And IMHO you compare the values of field HydStatusCodeA in the input format (because we are acting in the where clause, before QV will apply its formatting).
Nevertheless this could work if the format doesn't matter (like for numbers < 1000, thousand separator doesn't matter).
Maybe you could change your WildMatch / string comparision to a numerical comparison (using num(vFailHydStatusCodeA) )?
