環球晶自動倉

WCS 的儲位表查詢 API, 需要支援排序
WMS 前端目前用到的欄位有 儲位編號, 母棧板編號, 子棧板編號
若能支援更多欄位排序更好

另外, 根據剛剛會議結論, 此 API 也要支援分頁
謝謝

http://localhost:19090/db/data/StallDevices
取得全部及預設結果
預設排序(direction) ASC(由小到大)
direction
ASC:小到大
DESC:大到小
預設排序欄位(properties) id
properties
id:儲位號
gPNo:子棧板號
carrierId:母棧板號
lx:X軸或Column與梭車流道位置可算出深度.. 1,2,3(梭車流道),4,5,6,7 深度ABS(lx-3) lx(1)=ABS(1-3)深度為2 lx(4)=(4-3)深度為1 ,lx(5)=(5-3)深度為2,lx(7)=(7-3)深度為4
ly:Y軸或Row
lz:Z軸或Layer或樓層

預設取的資料(size) 全部
預設取的分頁(page) 1

可過濾執行參數
direction,properties,size,page

這次資料新增lx,ly,lz 欄位
API 結果如下
[{"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"gPNo":"","id":"101010102","carrierId":"","lx":5,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"gPNo":"S0024855","id":"101010402","carrierId":"A0036","lx":5,"ly":3,"lz":4},{"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"gPNo":"S0024855","id":"101020101","carrierId":"A0002","lx":4,"ly":4,"lz":1},{"gPNo":"","id":"101010301","carrierId":"","lx":4,"ly":3,"lz":3},{"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101020203","carrierId":"A0013","lx":6,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030303","carrierId":"A0029","lx":6,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010503","carrierId":"A0045","lx":6,"ly":3,"lz":5},{"gPNo":"S0024855","id":"101020102","carrierId":"A0004","lx":5,"ly":4,"lz":1},{"gPNo":"","id":"101010302","carrierId":"","lx":5,"ly":3,"lz":3},{"gPNo":"","id":"101020402","carrierId":"","lx":5,"ly":4,"lz":4},{"gPNo":"S0024855","id":"101030502","carrierId":"A0052","lx":5,"ly":5,"lz":5},{"gPNo":"S0024855","id":"102020302","carrierId":"A0023","lx":1,"ly":4,"lz":3},{"gPNo":"S0024855","id":"102020502","carrierId":"A0047","lx":1,"ly":4,"lz":5},{"gPNo":"","id":"101010201","carrierId":"","lx":4,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020301","carrierId":"A0020","lx":4,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030401","carrierId":"A0032","lx":4,"ly":5,"lz":4},{"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020304","carrierId":"A0026","lx":7,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"gPNo":"","id":"101010103","carrierId":"","lx":6,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101030203","carrierId":"A0017","lx":6,"ly":5,"lz":2},{"gPNo":"S0024855","id":"101010403","carrierId":"A0031","lx":6,"ly":3,"lz":4},{"gPNo":"S0024855","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"gPNo":"","id":"101010202","carrierId":"","lx":5,"ly":3,"lz":2},{"gPNo":"S0024855","id":"101020302","carrierId":"A0024","lx":5,"ly":4,"lz":3},{"gPNo":"S0024855","id":"101030402","carrierId":"A0040","lx":5,"ly":5,"lz":4},{"gPNo":"S0024855","id":"102020102","carrierId":"A0001","lx":1,"ly":4,"lz":1},{"gPNo":"S0024855","id":"102030302","carrierId":"A0027","lx":1,"ly":5,"lz":3},{"gPNo":"S0024855","id":"102030502","carrierId":"A0051","lx":1,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101020201","carrierId":"A0007","lx":4,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030301","carrierId":"A0019","lx":4,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010501","carrierId":"A0043","lx":4,"ly":3,"lz":5},{"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"gPNo":"S0024855","id":"102020401","carrierId":"A0033","lx":2,"ly":4,"lz":4},{"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101020204","carrierId":"A0014","lx":7,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010504","carrierId":"A0046","lx":7,"ly":3,"lz":5},{"gPNo":"S0024855","id":"101020103","carrierId":"A0005","lx":6,"ly":4,"lz":1},{"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"gPNo":"S0024855","id":"101030503","carrierId":"A0053","lx":6,"ly":5,"lz":5},{"gPNo":"S0024855","id":"101020202","carrierId":"A0012","lx":5,"ly":4,"lz":2},{"gPNo":"S0024855","id":"101030302","carrierId":"A0028","lx":5,"ly":5,"lz":3},{"gPNo":"S0024855","id":"101010502","carrierId":"A0044","lx":5,"ly":3,"lz":5},{"gPNo":"S0024855","id":"102020202","carrierId":"A0011","lx":1,"ly":4,"lz":2},{"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"gPNo":"S0024855","id":"101030201","carrierId":"A0008","lx":4,"ly":5,"lz":2},{"gPNo":"","id":"101010401","carrierId":"","lx":4,"ly":3,"lz":4},{"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}]

!clipboard-202405031107-qyjcs.png!

!clipboard-202405071610-8mvif.png!

依今日討論結論:
WCS 支援 totalElements(總數量) 和 totalPages(總共幾頁)
謝謝

!clipboard-202405071623-avaqt.png!
目前前端支援4種過濾條件, 麻煩 WCS 也支援
母棧編號: 用 WHERE carrierId LIKE xxx 支援部分比對
子棧編號: 用 WHERE gPNo LIKE xxx 支援部分比對
儲位編號: 用 WHERE id LIKE xxx 支援部分比對
是否空儲位: WHERE carrierId is null 判斷是否空儲位

如果後端帶兩個以上的篩選條件，記得 where 要用 and 連起來喔
（只有一個篩選條件則不用 and）

Git Commit: c818ad65fcc2736b50c754a61c713011211e7393 [c818ad6]

@林冠榮 @秦鼎 @Arder

1. 改成此格式{
   "content": [],
   "totalPages": 0,
   "totalElements": 0
   }

2.加入id,gPNo,carrierId,isCarrierIdNull 條件參數
id,gPNo,carrierId為字串型態
isCarrierIdNull為Bool型態

備註:
1.條件規則及順序
allStallCarrierObjs.filter {
if (isCarrierIdNull) {
it.carrierId.isEmpty()
} else {
true
}
}.filter {
if (id.isEmpty()) {
true
} else {
it.id.contains(id)
}
}.filter {
if (gPNo.isEmpty()) {
true
} else {
it.gPNo.contains(gPNo)
}
}.filter {
if (carrierId.isEmpty()) {
true
} else {
it.carrierId.contains(carrierId)
}
}.forEach {
stallCarrierObjs += it
}

2.有帶條件page參數帶1避免有資料但分頁切錯無法呈現資料
3.有帶條件totalElements為過濾後筆數,totalPages 為 totalElements/size

API 使用範例1
http://localhost:19090/db/data/StallDevices?properties=carrierId&direction=DESC&carrierId=A003&page=1
取A003x母棧板
{"totalPages":1,"content":[{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020402","carrierId":"A0036","lx":5,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101010403","carrierId":"A0033","lx":6,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010401","carrierId":"A0031","lx":4,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3}],"totalElements":10}

範例2
http://localhost:19090/db/data/StallDevices?properties=carrierId&direction=DESC&isCarrierIdNull=true
取得空儲位
{"totalPages":1,"content":[{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}],"totalElements":20}

範例3
http://localhost:19090/db/data/StallDevices
取得全部資訊
{"totalPages":1,"content":[{"deep":4,"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010102","carrierId":"A0001","lx":5,"ly":3,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"S0024855","id":"101010301","carrierId":"A0019","lx":4,"ly":3,"lz":3},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":4,"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"ly":5,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020203","carrierId":"A0013","lx":6,"ly":4,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101030303","carrierId":"A0029","lx":6,"ly":5,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101010503","carrierId":"A0045","lx":6,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020102","carrierId":"A0004","lx":5,"ly":4,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101010302","carrierId":"A0020","lx":5,"ly":3,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101020402","carrierId":"A0036","lx":5,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101030502","carrierId":"A0052","lx":5,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020302","carrierId":"A0023","lx":1,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102020502","carrierId":"A0047","lx":1,"ly":4,"lz":5},{"deep":1,"gPNo":"S0024855","id":"101010201","carrierId":"A0007","lx":4,"ly":3,"lz":2},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":4,"gPNo":"S0024855","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101020304","carrierId":"A0026","lx":7,"ly":4,"lz":3},{"deep":4,"gPNo":"S0024852","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101010103","carrierId":"A0002","lx":6,"ly":3,"lz":1},{"deep":3,"gPNo":"S0024855","id":"101030203","carrierId":"A0017","lx":6,"ly":5,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101010403","carrierId":"A0033","lx":6,"ly":3,"lz":4},{"deep":3,"gPNo":"S0024851","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101010202","carrierId":"A0008","lx":5,"ly":3,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101020302","carrierId":"A0024","lx":5,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101030402","carrierId":"A0040","lx":5,"ly":5,"lz":4},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":2,"gPNo":"S0024855","id":"102030302","carrierId":"A0027","lx":1,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102030502","carrierId":"A0051","lx":1,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"S0024855","id":"101010501","carrierId":"A0043","lx":4,"ly":3,"lz":5},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":4,"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101020204","carrierId":"A0014","lx":7,"ly":4,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101010504","carrierId":"A0046","lx":7,"ly":3,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020103","carrierId":"A0005","lx":6,"ly":4,"lz":1},{"deep":3,"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101030503","carrierId":"A0053","lx":6,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020202","carrierId":"A0012","lx":5,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101030302","carrierId":"A0028","lx":5,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101010502","carrierId":"A0044","lx":5,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020202","carrierId":"A0011","lx":1,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"S0024855","id":"101010401","carrierId":"A0031","lx":4,"ly":3,"lz":4},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}],"totalElements":74}

!clipboard-202405081008-jv6s9.png!

isCarrierIdNull 的規則:
isCarrierIdNull 沒帶 -> 不過濾, 全回
isCarrierIdNull == 0 -> 回母棧編號非空的
isCarrierIdNull == 1 -> 回母棧編號是空的

Git Commit: d374e30a2858fc061ece10d2aa0b13c5ab568f08 [d374e30]

isCarrierIdNull 的規則:
isCarrierIdNull 沒帶 -> 不過濾, 全回
isCarrierIdNull == 0 -> 回母棧編號非空的
isCarrierIdNull == 1 -> 回母棧編號是空的

http://localhost:19090/db/data/StallDevices?properties=gPNo
{"totalPages":1,"content":[{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":4,"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"deep":3,"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024811","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024851","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"deep":4,"gPNo":"S0024852","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010102","carrierId":"A0001","lx":5,"ly":3,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010301","carrierId":"A0019","lx":4,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"ly":5,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020203","carrierId":"A0013","lx":6,"ly":4,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101030303","carrierId":"A0029","lx":6,"ly":5,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101010503","carrierId":"A0045","lx":6,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020102","carrierId":"A0004","lx":5,"ly":4,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101010302","carrierId":"A0020","lx":5,"ly":3,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101020402","carrierId":"A0036","lx":5,"ly":4,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101030502","carrierId":"A0052","lx":5,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020302","carrierId":"A0023","lx":1,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102020502","carrierId":"A0047","lx":1,"ly":4,"lz":5},{"deep":1,"gPNo":"S0024855","id":"101010201","carrierId":"A0007","lx":4,"ly":3,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101020304","carrierId":"A0026","lx":7,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101010103","carrierId":"A0002","lx":6,"ly":3,"lz":1},{"deep":3,"gPNo":"S0024855","id":"101030203","carrierId":"A0017","lx":6,"ly":5,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101010403","carrierId":"A0033","lx":6,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010202","carrierId":"A0008","lx":5,"ly":3,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101020302","carrierId":"A0024","lx":5,"ly":4,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101030402","carrierId":"A0040","lx":5,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"102030302","carrierId":"A0027","lx":1,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"102030502","carrierId":"A0051","lx":1,"ly":5,"lz":5},{"deep":1,"gPNo":"S0024855","id":"101010501","carrierId":"A0043","lx":4,"ly":3,"lz":5},{"deep":4,"gPNo":"S0024855","id":"101020204","carrierId":"A0014","lx":7,"ly":4,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101030304","carrierId":"A0030","lx":7,"ly":5,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101010504","carrierId":"A0046","lx":7,"ly":3,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101020103","carrierId":"A0005","lx":6,"ly":4,"lz":1},{"deep":3,"gPNo":"S0024855","id":"101020403","carrierId":"A0037","lx":6,"ly":4,"lz":4},{"deep":3,"gPNo":"S0024855","id":"101030503","carrierId":"A0053","lx":6,"ly":5,"lz":5},{"deep":2,"gPNo":"S0024855","id":"101020202","carrierId":"A0012","lx":5,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101030302","carrierId":"A0028","lx":5,"ly":5,"lz":3},{"deep":2,"gPNo":"S0024855","id":"101010502","carrierId":"A0044","lx":5,"ly":3,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102020202","carrierId":"A0011","lx":1,"ly":4,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102020402","carrierId":"A0035","lx":1,"ly":4,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010401","carrierId":"A0031","lx":4,"ly":3,"lz":4}],"totalElements":74}

http://localhost:19090/db/data/StallDevices?properties=gPNo&isCarrierIdNull=true
{"totalPages":1,"content":[{"deep":1,"gPNo":"","id":"101020101","carrierId":"","lx":4,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020401","carrierId":"","lx":4,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101030501","carrierId":"","lx":4,"ly":5,"lz":5},{"deep":1,"gPNo":"","id":"102020301","carrierId":"","lx":2,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"102020501","carrierId":"","lx":2,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"101020301","carrierId":"","lx":4,"ly":4,"lz":3},{"deep":1,"gPNo":"","id":"101030401","carrierId":"","lx":4,"ly":5,"lz":4},{"deep":1,"gPNo":"","id":"102020101","carrierId":"","lx":2,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"102030301","carrierId":"","lx":2,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102030501","carrierId":"","lx":2,"ly":5,"lz":5},{"deep":2,"gPNo":"","id":"102020102","carrierId":"","lx":1,"ly":4,"lz":1},{"deep":1,"gPNo":"","id":"101020201","carrierId":"","lx":4,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"101030301","carrierId":"","lx":4,"ly":5,"lz":3},{"deep":1,"gPNo":"","id":"102020201","carrierId":"","lx":2,"ly":4,"lz":2},{"deep":1,"gPNo":"","id":"102020401","carrierId":"","lx":2,"ly":4,"lz":4},{"deep":1,"gPNo":"","id":"101010101","carrierId":"","lx":4,"ly":3,"lz":1},{"deep":1,"gPNo":"","id":"101030201","carrierId":"","lx":4,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"101020501","carrierId":"","lx":4,"ly":4,"lz":5},{"deep":1,"gPNo":"","id":"102030201","carrierId":"","lx":2,"ly":5,"lz":2},{"deep":1,"gPNo":"","id":"102030401","carrierId":"","lx":2,"ly":5,"lz":4}],"totalElements":20}

http://localhost:19090/db/data/StallDevices?properties=gPNo&isCarrierIdNull=false
{"totalPages":1,"content":[{"deep":4,"gPNo":"","id":"101010104","carrierId":"A0003","lx":7,"ly":3,"lz":1},{"deep":3,"gPNo":"","id":"101010303","carrierId":"A0021","lx":6,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024811","id":"101010204","carrierId":"A0010","lx":7,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024851","id":"101020503","carrierId":"A0049","lx":6,"ly":4,"lz":5},{"deep":4,"gPNo":"S0024852","id":"101030404","carrierId":"A0042","lx":7,"ly":5,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030204","carrierId":"A0018","lx":7,"ly":5,"lz":2},{"deep":4,"gPNo":"S0024855","id":"101010404","carrierId":"A0034","lx":7,"ly":3,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101020504","carrierId":"A0050","lx":7,"ly":4,"lz":5},{"deep":3,"gPNo":"S0024855","id":"101010203","carrierId":"A0009","lx":6,"ly":3,"lz":2},{"deep":3,"gPNo":"S0024855","id":"101020303","carrierId":"A0025","lx":6,"ly":4,"lz":3},{"deep":3,"gPNo":"S0024855","id":"101030403","carrierId":"A0041","lx":6,"ly":5,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101010102","carrierId":"A0001","lx":5,"ly":3,"lz":1},{"deep":2,"gPNo":"S0024855","id":"101030202","carrierId":"A0016","lx":5,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"101010402","carrierId":"A0032","lx":5,"ly":3,"lz":4},{"deep":2,"gPNo":"S0024855","id":"101020502","carrierId":"A0048","lx":5,"ly":4,"lz":5},{"deep":2,"gPNo":"S0024855","id":"102030202","carrierId":"A0015","lx":1,"ly":5,"lz":2},{"deep":2,"gPNo":"S0024855","id":"102030402","carrierId":"A0039","lx":1,"ly":5,"lz":4},{"deep":1,"gPNo":"S0024855","id":"101010301","carrierId":"A0019","lx":4,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020104","carrierId":"A0006","lx":7,"ly":4,"lz":1},{"deep":4,"gPNo":"S0024855","id":"101010304","carrierId":"A0022","lx":7,"ly":3,"lz":3},{"deep":4,"gPNo":"S0024855","id":"101020404","carrierId":"A0038","lx":7,"ly":4,"lz":4},{"deep":4,"gPNo":"S0024855","id":"101030504","carrierId":"A0054","lx":7,"