How to extract a value with a condition from ref table

[Nadhirah]

I have done an application to generate a report. There should be select month and select document button. 
These buttons is from referenced table. I would like to only able the select month value for the status closed. I tried (Work Order[status] = “Closed”, Work Order[Month]) but unfortunately it returns error and say list cannot be compared with text. 

Work Order = tablename

Does anyone have any other suggestion for me to fix this issue ?

[TeeSee1 · Accepted solution]

SELECT(Work Order[Month], [status]="Closed")

[Nadhirah]

It works, Thank you so much! Do you know if we could use standard SQL script when using appsheet? 

[TeeSee1]

You cannot call script files or stored procedures directly from AppSheet.

If you want to directly update the SQL database, either via script, stored procedures or triggers, I believe you can do it similar to the way you can update google spreadsheet manually or via Apps Script. Since I do not use any DBMS, I am not aware of any gotcha that you should be careful about.