Re: Multi-Table Query Into JSON?

2018-03-23 Thread Kelderic via 4D_Tech
I ended up writing a wrapper method called SelectionToJSON (named to match our existing naming convention), which is called like this: SelectionToJSON("Table";"[Table]Field1;[Table]Field2;[RelatedTable]Field1") Inside the method, it breaks apart the second parameter and builds a template object.

Multi-Table Query Into JSON?

2018-03-22 Thread Kelderic via 4D_Tech
I have a database with tables that are linked together via IDs. Simplified example: CallLogs Table UniqueID, Date, Type, Log, CustomerID Customers Table UniqueID, FirstName, LastName, City, State A CallLogs record will be linked to a Customers record by: [CallLogs]CustomerID =