Tweet
I've created a custom entity called "Test", derived from Base but with an additional integer field called "value".
Inside the entityDefs/Test.json, I've added a "notStorable" bool as below:
However, when I add this field to the "Search Filters" in the layout, any attempt to filter using this results in a 500 error.
In the above instance, I get a "Column not found: 1054 Unknown column 'test.is_below_zero' in 'where clause';" error but I'm not wanting to filter against a database column.
No matter how I change the syntax, I always get this 500 error. If I change the type to a "float" and do a comparison to zero, it works fine but never works with a bool.
If anyone could point me in the direction of a back-end change which would allow me to populate this field when the record is pulled from the database, that would be great.
As a side note, this is a very primitive example of what I'm trying to do - the actual computation in my real-world "select" is much more complex and pulls data from other tables in order to get to a TRUE or FALSE value.
Inside the entityDefs/Test.json, I've added a "notStorable" bool as below:
Code:
"isBelowZero": {
"type": "bool",
"readOnly": true,
"notStorable": true,
"select": "(value < 0)",
"orderBy": "isBelowZero {direction}"
}
In the above instance, I get a "Column not found: 1054 Unknown column 'test.is_below_zero' in 'where clause';" error but I'm not wanting to filter against a database column.
No matter how I change the syntax, I always get this 500 error. If I change the type to a "float" and do a comparison to zero, it works fine but never works with a bool.
If anyone could point me in the direction of a back-end change which would allow me to populate this field when the record is pulled from the database, that would be great.
As a side note, this is a very primitive example of what I'm trying to do - the actual computation in my real-world "select" is much more complex and pulls data from other tables in order to get to a TRUE or FALSE value.