If they are all in different tables it gets more complicated. You will need scripting.
If you import everything into one table and the timestamp is recognized by FM it gets easier. Is this possible? If so you can do a filtered & sorted portal with one row. You would filter by your DeviceID and then sort descending to show your most recent timestamp in the portal. This may not be the fastest way depending on the number of records, but should take only a few seconds or less in most cases. No difficult scripting required.
Thank for your response.
I think it's possible to import to on table using file-> import?I'm not sure I understand how it'll work.
But the timestamp is each line comes from different table is different.
I need to get result taken from each table from last timestamp line in this table.
So do you need one timestamp that is the latest one regardless of table (one result) or do you need the latest timestamp from each table (many results)?
If you need a timestamp from each table this would just use a sorted filtered portal for each table.
I would advise the sort is built into the relationship and the relationship is based on a global that matches to the device. this will be faster.
I need latest timestamp from each table, meaning latest device result from each table.
I've build the relationships based on common key "device, but when building the portal from one of the layouts, results from this table couldn't be sorted.
Is it possible to built portal not from one of the layouts?
Portal can always be sorted. Best to do with relationship sort. What does your time stamp look like?
You should have a separate independent table with a global field for your selected device. The portals are based there.
timestamp looks like
What is the process to build this separate table?haw I need to create it from other tables?
There are many devices as well, not only one.
Just make a new table in manage database.