https://wiki.isikhnas.com/index.php?action=history&feed=atom&title=Translations%3ASMS_handler_setup%2F35%2FenTranslations:SMS handler setup/35/en - Revision history2026-09-03T01:18:32ZRevision history for this page on the wikiMediaWiki 1.31.16https://wiki.isikhnas.com/index.php?title=Translations:SMS_handler_setup/35/en&diff=13202&oldid=prevFuzzyBot: Importing a new version from external source2014-09-01T11:04:15Z<p>Importing a new version from external source</p>
<p><b>Halaman baru</b></p><div>=== Text array ===<br />
The SQL is required. It returns an array of ID values for the codes in the input array. The requirements are rather special:<br />
* two %s parameters<br />
** First one: select %s from<br />
** Second one: (select unnest(regexp_matches(%s,'([a-z]+)', 'igx')) as code) as dat<br />
* join to main table: left outer join diseases s on upper(dat.code) = upper(s.code)<br />
** table '''must''' be aliased 's'<br />
* other join clauses and filters</div>FuzzyBot