Skip to main content
Jan 10, 2023 1:30 PM UTC
Solved

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 

jenscAnswer
Jan 10, 2023 3:41 PM UTC

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

1 reply

jenscAnswer
Jan 10, 2023 3:41 PM UTC

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