Hi
Is there a way whereby the artists can be grouped and displayed by designation? I have two groups of artists Musician and Workshop Facilitator and I want to show them under different menu headings?
Hi
Is there a way whereby the artists can be grouped and displayed by designation? I have two groups of artists Musician and Workshop Facilitator and I want to show them under different menu headings?
Apolozy for the inconvenience. Unfortunately, it is not possible to group and display artists by designation in the way described.
Surely it is possible to add a where or group by clause to the sql that is selecting the data?
Thank you for your input. While it may technically be possible to implement, it is a very complicated task as there is no separate designation table. The designation values are stored directly within the artist table, which would require significant custom development to modify the query and structure appropriately.