How to resvole source table fields having foreign IDs of other tables?
How to resvole source table fields having foreign IDs of other tables?
![moli](https://secure.gravatar.com/avatar/112f6b6eaaffcfc8dcd60494cf138d1b/?default=https%3A%2F%2Fvanillicon.com%2F112f6b6eaaffcfc8dcd60494cf138d1b_200.png&rating=g&size=120)
I've recently used DataTables to provide a user access to a MySQL-table which is access through an self-made REST-API from the table. This works pretty nice so far, but the accessed table has some foreign-IDs of some other tables in it, which i'd like to present als readable text to the user.
Is there a way to resolve the IDs in each record with a field (e.g. "label") of the foreign table, or do i need to create a special API endpoint returning that data as a result of a SQL JOIN operation?
Answers
Sounds like you have created your own server script, instead of using one provided by Datatables. In this case you will need to create your own queries to fetch the data you want.
Kevin