cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Infotable columns quering

KT_10107318
6-Contributor

Infotable columns quering

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 

1 ACCEPTED SOLUTION

Accepted Solutions
jensc
13-Aquamarine
(To:KT_10107318)

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".

jensc_0-1673365242293.pngjensc_1-1673365266653.png

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

View solution in original post

1 REPLY 1
jensc
13-Aquamarine
(To:KT_10107318)

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".

jensc_0-1673365242293.pngjensc_1-1673365266653.png

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

Announcements