Skip to main content
K
KT_101073188-Gravel
8-Gravel
January 10, 2023
Solved

Infotable columns quering

  • January 10, 2023
  • 1 reply
  • 1040 views

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 

Best answer by jensc

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

J
jensc17-PeridotAnswer
17-Peridot
January 10, 2023

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

    Terms & ConditionsAccessibility statement