iGarment Wiki

User Tools

Site Tools

Trace:
en:db_api

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
en:db_api [2026/06/03 09:51] – administratoren:db_api [2026/06/05 07:14] (current) – administrator
Line 1: Line 1:
-====== Datebase API ======+====== Database API ======
  
 ===== iGarment API: Query ===== ===== iGarment API: Query =====
Line 36: Line 36:
 Example, single SQL Example, single SQL
  
- { 
    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;    select orderNo from saomstr where issdate >= '2024-05-15' limit 2 into t_Filter;
    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo    select a.orderno, a.issdate, b.style, b.description from SAOMSTR a inner join t_Filter o on o.OrderNo = a.OrderNo inner join SAOSTYLE b on b.OrderNo = a.OrderNo
- } 
  
 Return data Return data
Line 101: Line 99:
 <file_name> is real file name saved in system, can query it from attach table or system image table. <file_name> is real file name saved in system, can query it from attach table or system image table.
  
-==== Request Example ====+**Request Example**
  
 eg: get style image (example with trial505, https://trial505.igx.biz/api) eg: get style image (example with trial505, https://trial505.igx.biz/api)
Line 117: Line 115:
 step 2. url: ~/db/get_file/b9b957b159d66ceec231a26c776dd9d390 step 2. url: ~/db/get_file/b9b957b159d66ceec231a26c776dd9d390
  
-Return Example+**Return Example**
  
   {   {
en/db_api.1780480284.txt.gzip · Last modified: by administrator