Unexpected outcomes in linq.js

Question

Unexpected outcomes in linq.js

Hey there, I have a JSON object named "Faults" that looks like this:

"Faults":[{"RoomId":1,"ElementId":173,"FaultTypeId":1,"Count":1,"Remark":""},{"RoomId":3,"ElementId":211,"FaultTypeId":7,"Count":1,"Remark":""},{"RoomId":4,"ElementId":173,"FaultTypeId":1,"Count":1,"Remark":""}]

When I check the Faults object in the debugger, it shows up like this:

https://i.sstatic.net/30GJA.png

Now, my task is to determine if a room contains a Fault by using its RoomId. The code I'm currently using for this purpose is as follows:

    Enumerable.From(audit.Rooms).ForEach(function(room, index) {//&radic;
    var containsFaults = '';

    //room.Id always has a value and cannot be null
    var test1 = faults.Select("$.RoomId==" + room.Id).Count();
    var test2 = faults.Select("$.RoomId==" + room.Id);

    if (faults.Select("$.RoomId==" + room.Id).Count() > 0) {
        containsFaults = '√';
    }

However, when I run this code, the results are not as expected...

https://i.sstatic.net/91zFH.png

I'm puzzled why it's not returning the faults from my object with matching RoomId. The Id's definitely match. Can anyone point out what mistake I might be making here? I'm really stuck on this issue...

Appreciate any help you can provide!

javascript json linq.js

Answer 1

Answer №1

To respond to the inquiry

Why is it not displaying the faults from my object with the corresponding RoomId? I'm certain the Id's match. What am I missing here, I'm really struggling with this...

You must include .ToArray() to showcase the result.

var test2 = faults.Select("$.RoomId==" + room.Id).ToArray();
//                                               ^^^^^^^^^^

var audit = { Faults: [{ RoomId: 42, ElementId: 4711, FaultTypeId: 0, Count: 0, Remark: "no fault" }, { RoomId: 1, ElementId: 173, FaultTypeId: 1, Count: 1, Remark: "" }, { RoomId: 3, ElementId: 211, FaultTypeId: 7, Count: 1, Remark: "" }, { RoomId: 4, ElementId: 173, FaultTypeId: 1, Count: 1, Remark: "" }] },
    roomId = 4,
    dataset = Enumerable.From(audit.Faults),
    test1 = dataset.Where("$.Count > 0 && $.RoomId==" + roomId).Count();
    test2 = dataset.Where("$.Count > 0 && $.RoomId==" + roomId).ToArray();

console.log(test1);
console.log(test2);

<script src="https://cdnjs.cloudflare.com/ajax/libs/linq.js/2.2.0.2/linq.js"></script>

Answer 2

To respond to the inquiry

Why is it not displaying the faults from my object with the corresponding RoomId? I'm certain the Id's match. What am I missing here, I'm really struggling with this...

You must include .ToArray() to showcase the result.

var test2 = faults.Select("$.RoomId==" + room.Id).ToArray();
//                                               ^^^^^^^^^^

var audit = { Faults: [{ RoomId: 42, ElementId: 4711, FaultTypeId: 0, Count: 0, Remark: "no fault" }, { RoomId: 1, ElementId: 173, FaultTypeId: 1, Count: 1, Remark: "" }, { RoomId: 3, ElementId: 211, FaultTypeId: 7, Count: 1, Remark: "" }, { RoomId: 4, ElementId: 173, FaultTypeId: 1, Count: 1, Remark: "" }] },
    roomId = 4,
    dataset = Enumerable.From(audit.Faults),
    test1 = dataset.Where("$.Count > 0 && $.RoomId==" + roomId).Count();
    test2 = dataset.Where("$.Count > 0 && $.RoomId==" + roomId).ToArray();

console.log(test1);
console.log(test2);

<script src="https://cdnjs.cloudflare.com/ajax/libs/linq.js/2.2.0.2/linq.js"></script>

Unexpected outcomes in linq.js

Answer №1

Similar questions

Ways to retrieve an array field from a query result in MongoDB

What is the best way to organize an HTTP route using filters in a typical manner?

When my route in NextJS processes the request, it returns a ReadableStream from req

Utilize Javascript to establish a fresh attribute by analyzing other attributes contained in an array within the object

Converting time from 00:00:01 to a format of 8 minutes and 49 seconds in Angular

Looking for tips on how to achieve a sleek search bar expansion effect when focusing using w3.css?

How to extract data from URLs in Angular

How do RxJS collection keys compare?

Executing a Vue method from the main.js file within a Vue.js document

Ways to retrieve the neighboring element's value and modify it with the help of JavaScript or jQuery

`Count the number of rows needed to accommodate text line breaks within a div element`

Activate the mouseenter event as soon as an animated element makes contact with the cursor

Dealing with substantial ajax responses using JavaScript

Is there a different way to invoke PHP within JavaScript?

Accessing a JSONObject deep within two layers of JSONArrays

Transform your HTML audio player into a Vue component

Using npm properties reader to access a key with multiple suite values from a properties file in Protractor

Enhance functionality in JavaScript by accessing the return value from a function

Having trouble decoding XML files with missing content in Azure Logic Apps

Is OnPush Change Detection failing to detect state changes?