cannot find record data in bmql query result
Code:
msgRS=bmql("SELECT MessageID, Message FROM MessageMaster2 WHERE LanguageCode = $languageCode OR LanguageCode='*' ORDER BY LanguageCode ASC,ModifiedDate ASC" );
Current language is ko_KR and checked in data table MessageMaster2, for messageID ‘VM-51_HPI’, we have two records matched.
But can only find one record which languageCode='*'.
do we have the query number limitation? can you extend this?