I already posted the following request to the TextFilter Forum but didn't get any answer. I do not want to cross post but I was hoping maybe the glossary experts could give me a hint.
As I'm trying to build a multilang glossary ao I have inserted the concepts like this:
<span lang="fr_ca" class="multilang">french concept</span><span lang="en" class="multilang">english concept</span>
With a bit of coding the autolink is working fine. The problem is with sorting and searching the concepts (all my entries start with "<" (special character).
I thought the following query would do it (e.g. to display french-R concepts):
SELECT ge.*, ge.concept pivot FROM mdl_glossary_entries ge WHERE (ge.glossaryid = '1' or ge.sourceglossaryid = '1') AND (ge.approved != 0 OR ge.userid = 3) AND left(ucase(trim(LEADING '<lang lang="fr_ca">' FROM concept)),1) = 'R'ORDER BY ge.concept LIMIT 0, 10
This query is working when executed through phpMyAdmin but doesn't when inserted into Moodle.
Any reason why?
Many thanks !