I have a linked table:
and would like to select the person from the most recent entry whenever the table is refreshed and store it in an attribute.
PI AF does not like when MAX is used in WHERE as shown below:
query: SELECT person FROM employees WHERE Date = SELECT MAX(Date) from employees
Are there any alternatives and more robust ways of calling new values from a table?