Issue with "inArray"

Wappler General Need Help
1

I am assuming i have missed something here but this is the issue.

I have a server action which returns data multiple records in the format

        {
            "UniversityName": "City College Plymouth",
            "Street": "Kings Road Centre, Devonport, Plymouth, PL1 5QG",
            "City": "Plymouth",
            "PostCode": "PL1 5QG",
            "UniversityID": 266
        },

I make this the basis of a repeat

<tbody is="dmx-repeat" dmx-generator="bs5table" id="tableRepeat1" dmx-bind:repeat="serverconnect1.data.query">

and all records show as expected.

i then add a where clause, in this simple example i want records 144 and 145

If i hard code this as follows:

<tbody is="dmx-repeat" dmx-generator="bs5table" id="tableRepeat1" dmx-bind:repeat="serverconnect1.data.query.where(`UniversityID`,[144,145],'inArray')">

it works

image
image1344Ɨ160 5.36 KB

however if i define an array via the app connect array component.

<dmx-array id="array1" dmx-bind:items="'144,145'"></dmx-array>

and use this as a reference in the .where clause like this:

 <tbody is="dmx-repeat" dmx-generator="bs5table" id="tableRepeat1" dmx-bind:repeat="serverconnect1.data.query.where(`UniversityID`,array1.items,'inArray')">

No recorsds show

Any ideas
(no console errors)

2

just looked at the data via dmx.app.data and see this which confuses me

image

3

This is just not an array.
It should be

dmx-bind:items="[144,145]"

or

dmx-bind:items="['a','b']"
4

Fixed, didn't realise i have to add the brackets manually, i assumed the array component would deal with that. adding brackets like [144,145] resolved it

5

Thanks Teodor, i did spot that, i had assumed the brackets would be implied as it is an array component, my bad