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:

11.png

 

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:

12.PNG

 

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

Outcomes