Support for Joomla core custom fields (com_fields)

com_fields's field type support in TJReports

com_field field type	tjreport indexer table column type	how / what indexer stores values for this	what type of filter in tjreports used for this
calendar	datetime	save user entered	daterange filter
checkboxes	varchar (255)	save TEXT and not VALUE	select / equal match
color	varchar (7)	save user entered	-
editor	text	save user entered	text / equal match
integer	int (11)	save user entered	select / equal match
list	varchar (255)	save TEXT and not VALUE	select / equal match
imagelist	not supported	NA	NA
media	not supported	NA	NA
radio	varchar (255)	save TEXT and not VALUE	select / equal match
repeatable	not supported	NA	NA
sql	text	save TEXT and not VALUE	text / equal match
text	text	save user entered	text / equal match
textarea	text	save user entered	text / equal match
url	varchar (250) [based on joomla weblinks table]	save user entered	text / equal match
user	varchar (400) [based on joomla user table]	store user's name	select / equal match
usergrouplist	varchar (100) [based on joomla usergroups table]	store usergorup title	select / equal match

Database table used for this (indexed data)

• Every tjreport plugin will rely on a certain table where custom fields data is stored in rows (1 record per row)
  • eg. If context is com_users.user -> table name should be #__tjreports_com_users_user
• Column which is needed here in this example is
  • record_id int (11)