This is probably an obvious question but how to do find the table names and field names that are named in the Top Call log? It names it only by ID. How to I find what it's associated with?
You can use the following functions in calculations to determine what the various IDs / names are...
All of these provide a list based on the FileName you provide.
Thanks I saw these already but they don't seem to be any help in determining what Tables/Fields the TopCall Log is referencing. Isn't there a way to find what table NAME the ID is referring to?
This is what the TopCall log shows me
How do I figure out what table names those are?
Updated by original answer as I was a little too quick on the copy and paste when posting. You need the corresponding TableNames, LayoutNames, and FieldNames functions as well. They return the list in the same order so it should be easy to match up the IDs.
Don't some of the third party tools that suck in the xml version of a database design report offer the ability to work with this info? (you can also just open the xml version in a text reader, tedious and you need to know at least a little about xml, but can be done....
The Field Names and Field IDs can be gotten from the FileMaker design functions, or by running a SQL query on the Virtual Schema/System Tables.https://www.databuzz.com.au/using-executesql-to-query-the-virtual-schemasystem-tables/ The object that is referred to (somewhat ambiguously) as “table” in the Top call statistics log, for example...Database::table(151)::field definitions(156)...is less ambiguously referred to as a BaseTable, which is the name that FMI uses in the DDR and also in the Save Records As Snapshot Link and Truncate Table script steps. More on this thread...tableIDshttps://community.filemaker.com/message/644586There are at least 3 ways to discover BaseTable IDs and match them up with BaseTable names, with advantages and disadvantages to each. Tony White
I think most missed that "same order". That was always my understanding of a way to match these. A loop with GetValue() on both lists should get you the id/name values together. Perhaps push those into JSON array for usage otherwise?
philmodjunk wrote: Don't some of the third party tools that suck in the xml version of a database design report offer the ability to work with this info?
Don't some of the third party tools that suck in the xml version of a database design report offer the ability to work with this info?
Yep, I use BaseElements and FMPerception; they both have that functionality.
Retrieving data ...