getting data from DataSource

so nobody know ? because this is big bug when I have in database null and datasource return "" and not null ?!?

Hello,

null value is treated as empty string. If you want to ignore it you can do it by checking setting "Goto on Loop on Empty" in DataSource to skip null values.

Hope this helps,
robert
/SmartBear

no I dont wanna ignore null value I need null value. When I have in database null I wanna assert this for null and when I have empty string in database I wanna assert empty string.

Hi,

you are correct - this is a bug due to the nature of how soapUI handles properties - essentially there is no "null" possibility - please file a bug-report in the Bugs Forum and we will log and prioritize it accordingly.

regards!

/Ole
SmartBear Software

Was this issue resolved or is there a workaround? We have a get method where we need to assert that the data that is being fetched matches the data in our db but are running into the columns that are null.

Just figured out a way around this issue. In the assertion, use the xpath concatenation function which returns the concatenation of the strings.

for example:

declare namespace ns1='blah';
concat(//ns1:thelocation, "")