Express Data Objects

Permalink 0 0 Browser Info Environment
For each Express Data Object (EDO) there is generated a table named dataObjectHandleExpressSearchIndexAttributes. For each attribute defined in the EDO there is created a column named ak_attributeHandle in this table, if the checkbox "Field available in advanced search" is checked on creation of an attribute. If you uncheck this field on attribute creation the column named ak_attributeHandle is not created into the table dataObjectHandleExpressSearchIndexAttributes. (dataObjectHandle and attributeHandle are place holders).

If you later check the "Field available in advanced search" checkbox on edit of the attribute, the field ak_attributeHandle neither is created into table dataObjectHandleExpressSearchIndexAttributes. This results in a runtime error, if you edit one of the EDO data entries or add an EDO list block with sort on such an attribute.

Similar happens if you change an option value of an attribute of type "subject". You can see the change in the EDO list but you'll get the old value retrieving the attribute value programatically as shown at "Getting Data From an Express Entry" section of page [https://documentation.concrete5.org/developers/express/creating-reading-searching-updating-and-deleting-express-entries],


Status: New
tdausner

concrete5 Environment Information

# concrete5 Version
Core Version - 8.4.3
Version Installed - 8.4.3
Database Version - 20180716000000

# concrete5 Packages
Automatic Email Obfuscator (2.0.1), BfB (0.23), Enhanced Version List (0.9.2), ExchangeCore Dev Tools (1.0.1), Login/Logout Link (1.0), Ronyd Expanded Search Bar (2.0), TDS Page List & Date Navigation Enhanced (0.9.0), TDS Social Media "Share this page" Icons (EU-GDPR compliant) (1.0.0), TDS Social Media "Visit my/our page" Icons (EU-GDPR compliant) (0.9.8), TDS ZIP Image Gallery (1.0.0)

# concrete5 Overrides
blocks/page_title/controller.php, blocks/page_title, src/Form/Service/Form.php, src/Form/Service, src/Form, src/prar.php

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.34 (Win32) OpenSSL/1.1.0h mod_fcgid/2.3.9

# Server API
cgi-fcgi

# PHP Version
7.1.21

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, pdo_sqlite, Phar, readline, Reflection, session, SimpleXML, SPL, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 0
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - -1
max_input_vars - 1000
memory_limit - 128M
post_max_size - 400M
sql.safe_mode - Off
upload_max_filesize - 400M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/71.0.3578.98 Safari/537.36