How to Select Row ID

Zane Winberg shared this question 5 years ago
Answered

Hi, How can I simply select the one row's ID that I have? If I were doing a SQL select statement... it would be this:


SELECT Next_ID


FROM SystemNumbers


WHERE Table_Name = 'RepairOrders'


How do I do the same in an expression in ProtoTyper?


I keep getting a set value of 'false' with this expression: (Filter(Select(SystemNumbers,Next_ID),Table_Name)=RepairOrders)

Comments (1)

photo
1

Got it! The devil's in the details. Here's the correct expression:


Select(Filter(SystemNumbers,(Table_Name=RepairOrders)),Next_ID)


The answered question called 'How do I apply a filter to a select statement?' helped me to get the syntax correct. Thanks!