AnsweredAssumed Answered

Select Newest Table Entry and Store in Attribute

Question asked by Seedubs on May 28, 2018
Latest reply on May 29, 2018 by jnoss

Hi there,


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?


Thank you