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

Community Tip - New to the community? Learn how to post a question and get help from PTC and industry experts! X

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
17-Peridot
(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
17-Peridot
(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

Top Tags