NodeJS Array Showing Extra Records

Hi All,

I’ve got an unusual one here that is a head banger (for me anyway). I have an array stored in a VARCHAR field (UsersCats) in a users table. The array contains Primary Key IDs for another DB table - WorkCats.

I have a repeat that uses Server Connect to list the WorkCats table as the Expression, then a show/hide to only show the rows that match the Primary Key in the users UserCats field.

It seems to display correctly, however, giving it a closer look its adding another 2 rows to the query.

Heres a view of what Im seeing:

Screenshot 2023-02-16 102302

You can see from the blue bits that the following have been added, yet they don’t exist in the UsersCats array. Its added a ‘2’ and a ‘4’.

Ive tried a lot of stuff, including converting UserCats to a string, a number etc but it all shows the same result.


Screenshot 2023-02-16 102524

Screenshot 2023-02-16 102449

I’m now stumped.!

Anyone have any ideas…?

Community Page
Last updated: