Infotable columns quering

[KT_10107318]

Hi all in have a infotable in which a column(x) is a boolean. i want to write a service in which any of the row in infotable column(x) is true need to return true. Thanks in advance 

[jensc · Accepted solution]

Hello,

There are several ways you could do this that I can think of. Here is one;

let infoTable = yourInfoTable;

let findRow = {
	"YourColumnName":true
};
let foundRow = infoTable.Find(findRow );
result = false;
if (foundRow.length > 0) {
	result = true;
}

There are also filter and query functions if you look in the "Snippets".

There are also some arrow functions that could possibly be used as well.

Hope this gives some inspiration and guides you to something that works for you.

Regards,

Jens