I’m trying to get webform submission data from the database. My webform has a hidden field for a related node id, but I cannot use a query with a condition on the field. In the database, the field type for value is MEDIUMTEXT. If the value is a string, I can call the condition as a quoted string, but since it’s a number, I get no results. Whether I pass the value as quoted or not, I get no results.
How can I pass in the proper value to get any results?
$query = $database->select('webform_submission_data', 'wsd') ->condition('name', 'node_id', '=') ->condition('webform_id', 'scores', '=') //this is mediumtext in the database ->condition('value', "169", '=') ->fields('wsd', ('sid')); $result = $query->execute();