It seems that using JSON to store the extra fields is a little short sighted.
I want to be able to write a module / component that searches through my custom item types and pick out certain rows and use that information to do a webservice call.
However, in order to do this I need to select all items from a particular category, decode the JSON and filter on the results. Then I can use this to send some data off to my webservice.
And what if I want to query the database on the basis of the webservice call to pick out a row based on one of the extra fields? It can't be done with a simple select x,y,z from ....
Is it possible that we can store each extra field in a column on it's own rather than in one JSON field? It seems almost impossible to pull out selected pieces of information from the custom item type this way? It's all or nothing?
I see that the search plugin puts all search terms into a separate column separated bv comma. Can this be extended to put each extra field into a separate column?
I want to be able to write a module / component that searches through my custom item types and pick out certain rows and use that information to do a webservice call.
However, in order to do this I need to select all items from a particular category, decode the JSON and filter on the results. Then I can use this to send some data off to my webservice.
And what if I want to query the database on the basis of the webservice call to pick out a row based on one of the extra fields? It can't be done with a simple select x,y,z from ....
Is it possible that we can store each extra field in a column on it's own rather than in one JSON field? It seems almost impossible to pull out selected pieces of information from the custom item type this way? It's all or nothing?
I see that the search plugin puts all search terms into a separate column separated bv comma. Can this be extended to put each extra field into a separate column?