ASA run same code with different result?

jane 60

The following 2 codes get different result:

FROM IotBaseInput as event
CROSS APPLY GetArrayElements(event.monoEvent) AS arrayElement
CROSS APPLY GetRecordProperties(arrayElement.arrayvalue) AS recordProperty
Where recordProperty.PropertyName != 'bmsNum'

The result didn't filter 'bmsNum'


FROM IotHubInput AS event
CROSS APPLY GetArrayElements(event.event) AS arrayElement
CROSS APPLY GetRecordProperties(arrayElement.arrayvalue) AS recordProperty
Where recordProperty.PropertyName != 'recordTime' AND recordProperty.PropertyName != 'type'

The result without 'recordTime' and 'type'

Sander van de Velde 29,281 Reputation points MVP

2023-12-20T07:38:59.9633333+00:00

Hello Jane

welcome to this moderated Azure community forum.

Better questions with more information lead to better answers from our community members.

Please provide information about the steps you have taken, the guide you follow, and the errors you receive.

Can you provide sample messages and the output you see for both queries?

What do you expect?
jane 60 Reputation points

2023-12-20T07:54:55.1333333+00:00

Hello,@Sander van de Velde

As you can see,I have described the result in my question.

And I want my filter condition works,but it did not work normal.

The message for code 1:

{"monoEvent":[{"bmsNum":1,"message1":1234,"message2":3456,"message3":6666}]}

The message for code 2:

{"event":[{"recordTime":"2023-12-20T12:08:09Z","type":1,"message1":1234,"message2":3456,"message3":6666}]}
Sander van de Velde 29,281 Reputation points MVP

2023-12-24T17:28:50.19+00:00

Hello Jane,

I try to understand what you are experiencing.

The fact you submit two different queries will most likely result in two different outputs.

Can you supply the full query you use?

Are the messages you give as an example, coming from an IoT hub? Is there no deviceId? Is there no timestamp?

What do you mean with 'The result didn't filter 'bmsNum'"?

What is the result you see, what is the result you expect? Can you explain this in a full description?

Thanks. Happy Christmas.
BhargavaGunnam-MSFT 26,496 Reputation points Microsoft Employee

2023-12-27T18:11:58.2733333+00:00

Thank you, Sander van de Velde

Hello Jane,

I am checking to see if you had a chance to look into the above response from Sander.