AnsweredAssumed Answered

how to create in FM Pro a search equivalent to SELECT TOP in SQL

Question asked by ErmannoAntonelli on Apr 8, 2011
Latest reply on Apr 11, 2011 by ErmannoAntonelli

Title

how to create in FM Pro a search equivalent to SELECT TOP in SQL

Post

Hi Guys,

I'm new to FM Pro and I have been doing pretty much all I need, but I'm struggling with one particular search.

Here is what I have done:

I have a Layout in my main project reading values from table (JOBS), I have a relationship with another table (TASKS) that i present in a portal. 

What works so far:

I can search for all records in my JOBS DB that have a particular value in (TASKS::TASK_DESCRIPTION)

What I want is to show only the result only if the value in TASKS::TASK_DESCRIPTION with the most recent date inserted.

I have attached a screen shot of a unwanted search result.

I would fin the value in SQL with SELECT TOP, but I dnot' seem to find the way with the scripting tool.

Any suggestion is appreciated.

Thanks,

Ermanno

screenshot.png

Outcomes