Using [Last()] In XML/XPath Parsing SQL Results
Posted: Mon Jul 29, 2024 4:46 pm
Does Switch not support the use of "[Last()]" in specifying a Metadata field? Appears not.
I have a SQL query returning multiple hits most of the time, and I just want the last one out of the results.
i.e.: [Metadata.Text:Dataset="FMP_Data",Model="XML",Path="/Log/SQLStatementValue/Row[Last()]/Column[1]"]
I have a SQL query returning multiple hits most of the time, and I just want the last one out of the results.
i.e.: [Metadata.Text:Dataset="FMP_Data",Model="XML",Path="/Log/SQLStatementValue/Row[Last()]/Column[1]"]