My Query List

Query ID
Title
SQL Query
Object Name
Action
82564
Test
Select * from V_WMS_PurchaseOrderObj
Inward
|
|
82698
Receiving Data Will Show
Select * from al_ReceivingDataWillShow
Inward
|
|
82697
Outbound Transaction
Select * from al_OutboundTransaction
Outward
|
|
82656
SKU Detail
Select * from al_SKUDetail
Outward
|
|
1-1 of 70 Records 1234567
Execute Query
QueryID
Title
SQL Query
Select From-TO Date
Object Name
Customer
Warehouse
Action
82563
Purchase Data Will Show
|
Inward
|
|

Product Code
Description
Sequence
Data Type
Lottable
Lottable Value
Sku1001010
Test P1
1
Date Time
Exp Date
01/05/2023
Sku1001010
Test P1
1
Date Time
Exp Date
01/05/2023
Sku1001010
Test P1
1
Date Time
Exp Date
01/05/2023
Sku1001010
Test P1
1
Date Time
Exp Date
01/05/2023
Sku1001010
Test P1
1
Date Time
Exp Date
01/05/2023
Edit Query
V_WMS_UserObj
display as
LastName
display as
RoleName
display as
Warehouse
display as
CompanyID
display as
Company
display as
Customer
display as
MobileAccess
display as
Active
display as
ModifiedBy
display as

Condition
Customer
Warehouse
AND
OR

Condition


Conditions
Group Bracket / Bracket Conditions: ADD


SQL ->
First Name
Last Name
Role Name
Warehouse
Company ID
Comapany
Customer
Mobile Access
Active
Modified By
Brilliant
Admin
Super Admin
Westcoast
2905
Westcoast
Brilliant
1
True
0529
Brilliant
Admin
Super Admin
Westcoast
2905
Westcoast
Brilliant
1
True
0529
Brilliant
Admin
Super Admin
Westcoast
2905
Westcoast
Brilliant
1
True
0529
Brilliant
Admin
Super Admin
Westcoast
2905
Westcoast
Brilliant
1
True
0529
Brilliant
Admin
Super Admin
Westcoast
2905
Westcoast
Brilliant
1
True
0529
Query Builder Notification
QueryID
Title
Object
Notification To
Interval
DAILY
WEEKLY
MONTHLY
Send At
Day of Week
 MON
 TUE
 WED
 THU
 FRI
 SAT
 SUN
Day of Month
First Day of Month
Last Day of Month
Specific Day of Month
Select Day
 
Save Query
Title

SQL Query
Select * from al_PurchaseOrder

SQL Query
Select * from al_PurchaseOrder



From
To