Is there any way to get the results of Broker Query in a sorted order based on the metadata of keyword, keyword itself a metafield of the component.
We have 3 types of products Gold, Silver, Platinum and we have 20 products created as components in the cms based on these 3 types. For each type we have created a keyword and associate the keyword as metadata of component.
Now we need to fetch the components using broker query in sorted order based on product type. If we define the sort order(numeric 1, 2 , 3) in metadata field of each keyword (using metadata schema) can we make a broker query to fetch sorted component list ; sorted by product type.
Thought is if sort order needs to be changed in future, then just needs to change the metafield value of keywords.