Forum


TF Any pre-sales

Tom Mitchell
2%
Posts: 2
Custom Fields
December 27, 2024

I am looking for a tool to extract an ID from a DB table based on a SQL query based on two criteria involving a JOIN as the relevant criteria are, despite the simplicity of the output (an array - as in the attached image), stored in a different table.

I can see how TF Any might work to access data in a single table but can it handle a more complex query?

Joomla Fry
100%
Posts: 952
December 27, 2024

Hello

Currently, joining is not possible. Thank you for the suggestion. I have forwarded this request to development team.

However, you can use SQL field type provided by Joomla core.

Tom Mitchell
2%
Posts: 2
December 27, 2024

I will give the Custom Field option a go.  Thanks

Login to Reply