acces to array items like with Where fonction

Alain Fontaine Yes, it's right

var myTable := ["Jacques", "Marie", "Leon", "Nadine", "Marie-Claire", "Sylvain"];
var s := this.Name;
myTable[this like s]

In the code above, the "this" on line 2 represents the current record (where Name is a text field). The one on line 3, between the square brackets, represents the current element of myArray

Fred 

I think there is a better way to get this result by using the select function, but to stay in the theme of this thread, I suggest you try this 

let curRec := this;
let xRes := unique(select Results[RiderID = curRec.RiderID].Year)
let xSeason := select Seasons;
xSeason[(var y = this.Year;
         count(xRes[ = y])>0)]

Fred 

Another solution is to use JSON arrays. They have the advantage of being used by Ninox as a table. You can use the square brackets to make a filter where and add a dot at the end to iterate through all the elements in the table.

let curRec := this;
// creation of a JSON array
let xRes := (select Results[RiderID = curRec.RiderID]).{y:Year}
// removal of duplicates
let uniqueRes := unique(xRes.y)
//Each year's course and returns the corresponding seasons.
uniqueRes.(var y := this;
                first(select Seasons where year = y))
//results can be used as a data source in views or dynamic simpe/multi choice fields

more condensed

let curRec := this;
unique( ((select Results[RiderID = curRec.RiderID]).{y:Year}).y ).(var y := this;
                first(select Seasons where year = y))

Fred something like this probably

let curRec := this;
select Seasons where ( var y := this.Year;
        count(select Results where RiderID = curRec.RiderID and Year = y) >0 ) order by Year;

Fred 

In Ninox Script, you can use JSON variable (JSON by Mozzila)

var config := {lastName : "tur", firsName : "jacques"}
var myName := config.firstName + " " + config.lastName;
//myName = jacques tur

if you use this formation as in a table iteration...

var myArray := (select Customer where 'First Name' like "s").{
    firstName: 'First Name',
    lastName: 'Last Name'
}
myArray;

you will obtain an array of JSON :

[
    {
        "firstName": "Sofia",
        "lastName": "Young"
    },
    {
        "firstName": "Lisa",
        "lastName": "Wilson"
    },
    {
        "firstName": "Sebastian",
        "lastName": "Wood"
    },
    {
        "firstName": "Samantha",
        "lastName": "Grey"
    }
]

Now you can filter the array by using a JSON key

myArray[this.lastname like "y"];

result :

[
    {
        "firstName": "Sofia",
        "lastName": "Young"
    },
    {
        "firstName": "Samantha",
        "lastName": "Grey"
    }
]

Sea also :

formatJSON

parseJSON

UKenGB it's just when I post on the forum. Unfortunately, Ninox doesn't allow comments yet.

Matthias S. Could you send me one exemple or tell me more ?

Matthias S. Something like that ?

I was inspired by the code published by John Halls below. The idea is to do a boolean AND operation between the DMC of the filter (named Select characteristics) and the DMC of each record (named caracteristics), then to check that the result contains the same number of elements. In other words, we check, for each record, that it contains at least the same characteristics as the one of Select charateristics. 

var a := numbers('Select characteristics');
select Contact
    where (var b := numbers('list of characteristics');
    var c := a[var v := this;
            count(b[= v]) > 0];
    count(c) = count(a))

Matthias S. Simply replace the code with this one:

var a := numbers('Select characteristics');
select Contact
    where (var b := numbers('list of characteristics');
    count(a[var v := this;
                count(b[= v]) > 0]) > 0)

In this case, we test if A and B have at least one element in common. To do this, in line 5 and 4 we filter the array A by searching for each element if it also exists in B.

The same result could be obtained by using For loops :

var a := numbers('Select characteristics');
select Contact
    where (var b := numbers('list of characteristics');
    var nbCommun := 0;
    for i in a do
        for j in b do
            if i = j then
                nbCommun := nbCommun + 1
            end
        end
    end;
    nbCommun > 0)