glossary filter by letter arabic query using oracle database?

glossary filter by letter arabic query using oracle database?

by Murad Jamal -
Number of replies: 2

Hi all,

I found this query in moodle 1.9.4:

SELECT

ge.*, ge.concept AS glossarypivot FROM s_glossary_entries ge WHERE (ge.glossaryid = '161' OR ge.sourceglossaryid = '161')

AND (ge.approved != 0 OR ge.userid = 361)

AND concept = 'م'

ORDER BY ge.concept

what this query does is filtering out glossary concepts in the view page of glossary by the arabic letter "م"  .. it works fine if moodle uses mysql, but in case of oracle 10g, it returns empty result !!

anybody can help ?

Average of ratings: -
In reply to Murad Jamal

Re: glossary filter by letter arabic query using oracle database?

by Joseph Rézeau -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers Picture of Translators
Hi Murad,
I don't think your question will be answered in this forum. The best thing to do is to post a bug report in the Moodle bug tracker, where hopefully a developer will see it and come up with an answer.
Joseph
Average of ratings: -
In reply to Joseph Rézeau

Re: glossary filter by letter arabic query using oracle database?

by Murad Jamal -

Thank you Mr. Joseph for your note ...

please vote for the bug in MDL-22681 ...

thank you .

Average of ratings: -