Can currentRow be used in a SQL statement

💬 Queries and Resources
1

I was trying to run this query and I keep getting an error that currentRow is undefined?

SELECT *
FROM pools_built
WHERE sequence = {{ table1.currentRow.serial_num }}
2

I don't believe you can.

Try WHERE sequence = {{ table1.selectedRow.serial_num }}

3

I was using that, but I don't think it was working. I basically want to run a query that checks to see if the serial number value of each row is in another database table and if it is, the color of the text changes. I don't want just the selected row.

4

Ok, I'm getting a better picture. Can you please send a screenshot showing the table?

5

If you want to compare the serial number in two tables I would first join the tables and include the id of your second table.

Afterward, include this column in your table. If that id in the row is not null then add a color to the text in the column with a condition. Something like this:
chrome_Mx0yuMwy7B

The more screenshots you send the easier it will be to help you. :slight_smile:

6

Hey @tomm

You should use {{ table1.selectedRows }} instead of {{ table1.currentRow }}, as the select option in the table requires the use of selectedRows to refer to the selected entries.

3 Likes
7

@Shawn_Optipath, you're solution led me to a workaround that did the job quite nicely, so thank you.

2 Likes