Xcelsius QAAWS blank output not clearing destination cells

[banums]

I have a qaaws data connection in Xcelsius 2008, which is not clearing / overwriting the destination cells when the web service result set is blank

I have a menu list component tied to these cells and it is showing the previous results when the result set is blank


Can anyone please suggest a solution.


Thanks

banums

[delphine35]

You can test "Fetchedrows" in the output value of your QAAWS connexion.

[banums]

I see "nbLines" & "nbColumns" in output values but not "Fetchedrows"
The "nbLines" is retrurning 1 even when the result set is empty

[yourajai]

As you know, QaaWS data is dynamic, It is hard to see, while designing.

I had same kind of issue with QaaWS result set, and then i realized the spreadsheet for the QaaWS was corrupted.

How to identify this peculiar issue:

1.Use the Spreadsheet table component and see the values dynamically.

2.If your spreadsheet corrupted, then values won’t change for the subsequent query.

Delete the spreadsheet cell and recreate the part alone. It will work.
If you need any more clarifications, post it here. I may help you.

[banums]

Hi,

I checked with the spreadsheet component, the values are changing when the Qaaws retrurns data, but the values are not changing when the Qaaws returns empty result set, the cells are still displaying the previous non-empty results

Thanks for you help

[xguru]

Hi,
This was a bug in the old version and it's fixed. Which version of BOBJ and Xcelsius are your using. If you are BOXI 3.x platform, I would recommend to use atleast SP3 versions.

[bergkemp]

When ur not able to pass empty values. just try to use an additional component to overwrite the destinations.
else, you can create a query which has all rows as "#" or something. overwrite this on the location and handle these values using excel logic.

AND Remember.....For a Developer there is no such thing as NOT Supported, in case the Requirement is frozen.You have to do it! So try above methods and check.


Bergemp.

"I can show the way, but you have to tread the path"