在GL中查查询某月所有日记帐,发现查询结果不是按我所要的编号序列排序,帮助---->检查----->system---->last query,得出如下结果
SELECT BATCH_NAME,HEADER_NAME,PERIOD_NAME,BATCH_DESCRIPTION,BATCH_DATE_CREATED,BATCH_POSTED_DATE,BATCH_CONTR.................................................................................................(省去若干行)_JE_BATCHES_HEADERS_V WHERE ( ( ('A' = 'A') AND (ACTUAL_FLAG IN ('A', 'B'))) OR ('A' = 'Q') OR (ACTUAL_FLAG = 'A')) AND SET_OF_BOOKS_ID = 1 AND (HEADER_JE_BATCH_ID_QRY = JE_BATCH_ID + 0) AND -1=-1 and (PERIOD_NAME='10-2004') and (JE_CATEGORY='1') order by BATCH_NAME, PERIOD_NAME
发现系统是按照 BATCH_NAME,及PERIOD_NAME字段排序的,请问高手如果我想要它按另外一个字段在操作界面排序,在哪里改动可以得到?以此类推,在从多查询界面,我都能实现个性化设置吗?
|