ChannelField::getDataTable() always returns 'channel_data'
Developer Preview
7 years ago
I’m trying to determine where a given channel field is stored. Thought I could use the getDataTable() on the ChannelField model, but that always returns 'channel_data', even for Fluid fields, which will never be in that table.
7 years ago
I’m guessing it will be tricky to determine what to return when a given field can be stand-alone or part of a Fluid field… But, ideally, this method should return the table name where the content is stored. Is this going to be the case? It will be very useful for building custom queries that aren’t currently possible using Models (like calculating Haversine distance using 2 fields as lat and long values).
7 years ago
Low,
I’m adding the following method to FieldModel in the next release:
public function getDataStorageTable()
{
if ( ! $this->hasProperty($this->getColumnPrefix().'legacy_field_data')
|| $this->getProperty($this->getColumnPrefix().'legacy_field_data') == TRUE)
{
return $this->getDataTable();
}
return $this->getTableName();
}