[TYPO3-dam] fields without TCA info

[Oliver Rowlands]

Hi Jigal,

I would refer to the following fields as 'system' TYPO3 fields:

uid
pid
crdate
cruser_id
sorting
t3ver_oid
t3ver_id
t3ver_wsid
t3ver_state
t3ver_stage
t3ver_count
t3ver_tstamp

It is for this reason that they do not appear in the TCA of any TYPO3 
tables. Unfortunately the only way I can think of finding the data types 
of these fields would be to hardcode this information in your search 
form or extension.

The 'active' and 'search_content' fields on the other hand should be 
define in the TCA of EXT:dam.

The 'active' field from what I understand is not actually used anywhere 
(legacy field maybe?) and is actually just commented out in EXT:dam/tca.php.

The 'search_content' field is used by the indexer to store content 
extracts of the documents. Though it is meant to be non-editable, I do 
not really understand why it has not been defined in the TCA with a 
'readOnly' => true.

Finding the data types of additional fields defined in other extension 
is not particularly difficult: if they have been written correctly then 
they will be extending the DAM TCA meaning that you can access that 
information from your extension.

You will notice that TYPO3 will not load up the full DAM TCA (which 
includes the additional field definitions) when browsing the site in the 
FE, instead you will get the an array containing only the fields defined 
in EXT:dam core. In order to get around this the easiest is to load up 
the TCA of the other extensions in your 'typo3conf/extTables.php' file, 
for example:

t3lib_div::loadTCA('tx_i_extend_the_dam');

This will ensure that the additional fields defined in 
'tx_i_extend_the_dam' are available within the DAM TCA.

HTH

Oliver

Jigal van Hemert | alterNET internet BV wrote:
> Hi list members,
> 
> For a search form I try to automatically determine the field type of fields
> in tx_dam. Unfortunately the following fields have no information in TCA:
> uid
> pid
> crdate
> cruser_id
> active
> sorting
> t3ver_oid
> t3ver_id
> search_content
> t3ver_wsid
> t3ver_state
> t3ver_stage
> t3ver_count
> t3ver_tstamp
> 
> For some of them one could argue that it is unnecessary to search in that
> field, but others (search_content for example) might be very useful. Any
> suggestions on how to find the field type and for some field types the
> possible values and labels (apart from defining them myself)?
> 
> Furthermore there is the challenge of finding this information for columns
> which are added to the table by other extensions. Any ideas for this are
> also very welcome.


-- 
Oliver Rowlands
:: Liquid Light ::

E - oliver at liquidlight.co.uk
W - http://www.liquidlight.co.uk

T - 00 44 (0)845 6 58 88 35
F - 00 44 (0)845 6 58 44 35