---+!! =paraworld.users.Search (已作废)= <div style="float: right; margin: 5px; width: 250px; color: #4e5155; background-color: #f0eded; border: #ccc 1px solid; padding: 5px"> *Contents* %TOC% </div> ---++ Description 依据传入的MQL语句查找用户 %BLUE%不区分%ENDCOLOR%大小字 %BLUE%不支持%ENDCOLOR%多表联合查询,%BLUE%不支持%ENDCOLOR%聚合函数,%BLUE%不支持%ENDCOLOR%Top语句; %BLUE%支持%ENDCOLOR%where、order by 、group by语句; %BLUE%可用字段%ENDCOLOR%:uid, uname, createDate, lastActivityDate, email, isOnline %BLUE%MQL关键字%ENDCOLOR%:<br/> PageSize: 用在where语句中,以分页的形式返回数据,该值指定每页的最大数据量,必须与PageIndex一起使用才起作用,否则忽略,若指定了PageIndex,却没有提供PageSize,则默认的每页最大数据量为10<br/> PageIndex:用在where语句中,以分页的形式返回数据,该值指定返回的页码,若指定了PageIndex,则必须指定Order by。<br/> 示例:select * from users where PageIndex = 0 and PageSize = 20 order by createDate desc //每页最多20条数据,返回第一页的数据 ---++ Parameters |*Required*|*Name*|*Type*|*Description*| |<font color="#4682b4">required</font>|mql|%BLUE%string%ENDCOLOR%|规范的MQL语句。| ---++ Example Return XML <verbatim> <msg xmlns=""> <users> <param index="1"> <uid type="string">7b76d6cc-d94a-41f4-a100-6b5baa53a03e</uid> <uname type="string">test1</uname> <createDate type="string">2008-4-25 6:12:46</createDate> </param> <param index="2"> <uid type="string">e232162c-4a02-421f-9dd1-3348dd922312</uid> <uname type="string">test2</uname> <createDate type="string">2007-10-9 5:48:50</createDate> </param> <param index="3"> <uid type="string">b8872ba2-a3e5-4616-a317-16c876e06ad0</uid> <uname type="string">test3</uname> <createDate type="string">2007-10-9 5:15:29</createDate> </param> <param index="4"> <uid type="string">cc4f0925-db3e-43f5-afd4-596745487a62</uid> <uname type="string">test4</uname> <createDate type="string">2007-9-30 5:25:43</createDate> </param> <param index="5"> <uid type="string">fae5feb1-9d4f-4a78-843a-1710992d4e70</uid> <uname type="string">test5</uname> <createDate type="string">2007-9-28 7:48:19</createDate> </param> </users> </msg> </verbatim> ---++ Error Codes 当发生异常时,返回数据中会有一个“errorCode”节点,该节点记录了错误码。0:无异常 500:未知错误 499:提供的数据不完整 498:非法的访问 497:数据不存在或已被删除 496:未登录 494:语法错误 ---++ Test Cases ---+++!! case 1 Input: <verbatim> { ["mql"]="select uid,uname,createDate from users where PageIndex = 0 and PageSize = 5 and createDate > '2008-1-1' order by createDate desc", } </verbatim> _Result_: <verbatim> { ["users"]={ [1]={ ["uid"]="f5f3de7a-05b2-42a0-bd78-415a939020c2", ["createDate"]="2008-5-5 7:44:11", ["uname"]="test1", }, [2]={ ["uid"]="6ea770c6-92b2-4b2b-86da-6f574641ec11", ["createDate"]="2008-5-5 7:36:12", ["uname"]="test2", }, [3]={ ["uid"]="8ec11316-bc2e-491d-8f18-667501687e69", ["createDate"]="2008-5-5 7:36:05", ["uname"]="test3", }, [4]={ ["uid"]="3ea9e436-c68a-4316-bf90-7de514b9979e", ["createDate"]="2008-5-5 7:02:17", ["uname"]="test4", }, [5]={ ["uid"]="ed06733e-986d-4236-8fc8-9f8300456c21", ["createDate"]="2008-5-3 6:38:31", ["uname"]="test5", }, }, } </verbatim>
E
dit
|
A
ttach
|
P
rint version
|
H
istory
: r4
<
r3
<
r2
<
r1
|
B
acklinks
|
V
iew topic
|
Ra
w
edit
|
M
ore topic actions
Topic revision: r4 - 2008-12-08
-
CaoYF
Home
Site map
CCWeb web
HaqiTeen web
Main web
ParaEngine web
TWiki web
Main Web
Users
Groups
Index
Search
Changes
Notifications
RSS Feed
Statistics
导航页WebTopMenu
Preferences
开发指南
Getting Started
ParacraftSDK
NPL
MCML
NPL Reference Manual
美术Mod
Account
Log In
English
简体中文
簡體中文
E
dit
A
ttach
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback