How to get reservations happened in a specific period

[Vaibhav Jain]

Hello team,

We are managing the master inventory data in the OFBiz and want to do
real-time/hourly basis inventory sync up with a third party system.

Question:
How can we get the reservations that happened in a specific period?

Kind Regards,
Vaibhav Jain
cell: 782 834 1900

OFBIZ-11995

[Girish Vasmatkar]

Hi All

Continuing the efforts done on OFBIZ-11328, I have now added an XML based
REST DSL that facilitates declarative resource bindings to OFBiz services
(for now only OFBiz service).  Various commits are pushed under OFBIZ-11995.
It attempts to allow each component to define their own set of APIs that
eventually end up being in a single runtime. At the moment, a single
OpenAPI spec (JSON and YAML) is generated clubbing together APIs defined in
all components. I wish to provide separate OpenAPI for each component
considering the combined spec becomes too huge.

I have also developed a demo component under my forked plug-in to give you
an idea of how the resources can be defined and mapped to OFBiz services.
Pl take a look at -
https://github.com/girishvasmatkar/ofbiz-plugins/tree/trunk/rest-impl-demo

In the demo, I have configured some resources like below -

POST  /rest*/*products (Create a new product)
GET /rest/products/{productId} (Get product)
POST /rest/products/features (Create a new feature)
POST /rest/products/{productId}/features (Apply feature to product)
GET /rest/products/{productId}/features/{featureId}

POST /rest/categories (Create a new category)
GET /rest/categories (Get all categories)

Schema file can be defined under
/api/.rest.xml

For now, JSON is supported and I intend to bring in XML in the mix as well
based on the Content-Type header.
There may be some refinement needed and some extra use cases that may not
work, so please feel free to let me know how it goes and any changes you
would like to make and I will try to accomodate.

Best,
Girish
HotWax Systems

Re: JIRA issue 12021 created for: RE: varchar(255) in fieldtypepostgres.xml

[Jacques Le Roux]

Thanks,

We can continue the discussion there. I agree with Paul there that it's a good idea. I see no problem with that, we just have to check that all DBMS 
settings are OK.


Jacques

Le 23/09/2020 à 00:04, Development a écrit :

I guess I'm supposed to annnounce here that I created the JIRA issue...


I've created a JIRA issue: https://issues.apache.org/jira/browse/OFBIZ-12021

Basically the fields "comment" and "description" are limited to 255 char.  
(note: most tables have a short name field that is seperate from the description field).

I know I do, and I would imagine people could easily go over 255 char when 
writing things like a comment or description about something.

I put a proposed fix in the JIRA issue.


From: Jacques Le Roux [jacques.le.r...@les7arts.com]
Sent: Tuesday, September 22, 2020 4:09 AM
To: Development
Cc: dev@ofbiz.apache.org
Subject: Re: varchar(255) in fieldtypepostgres.xml

Hi,

Since this is more an OFBiz development (improvement) than its usage, I 
recommend to create a Jira issue
https://issues.apache.org/jira/projects/OFBIZ/summary

And to refer to it from the dev ML https://ofbiz.apache.org/mailing-lists.html 
(please subscribe before if not done already)

We need to discuss with the community. It would be a pity to work on it and get 
rebuffed by the community.

I start by copying your message to the dev ML...

TIA

Jacques

Le 20/09/2020 à 22:25, Development a écrit :

:)

No problem.  Obviously, i don't always respond to email right away either :)

Since this email is long, I figured I should send it to you direct instead of 
sending it to the list.

Anyway, this is what I was thinking:


diff --git a/framework/entity/fieldtype/fieldtypeadvantage.xml 
b/framework/entity/fieldtype/fieldtypeadvantage.xml
index 9f81c3ec42..c7fd6910fa 100644
--- a/framework/entity/fieldtype/fieldtypeadvantage.xml
+++ b/framework/entity/fieldtype/fieldtypeadvantage.xml
@@ -50,8 +50,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypeaxion.xml 
b/framework/entity/fieldtype/fieldtypeaxion.xml
index 2ce5f3b13e..bc9cd405f8 100644
--- a/framework/entity/fieldtype/fieldtypeaxion.xml
+++ b/framework/entity/fieldtype/fieldtypeaxion.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypedaffodil.xml 
b/framework/entity/fieldtype/fieldtypedaffodil.xml
index 8abda563f6..5a43a1e44b 100644
--- a/framework/entity/fieldtype/fieldtypedaffodil.xml
+++ b/framework/entity/fieldtype/fieldtypedaffodil.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypederby.xml 
b/framework/entity/fieldtype/fieldtypederby.xml
index 80d2cfed14..d7aa9f7e45 100644
--- a/framework/entity/fieldtype/fieldtypederby.xml
+++ b/framework/entity/fieldtype/fieldtypederby.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypefirebird.xml 
b/framework/entity/fieldtype/fieldtypefirebird.xml
index d449c1c4a9..191ef84c22 100644
--- a/framework/entity/fieldtype/fieldtypefirebird.xml
+++ b/framework/entity/fieldtype/fieldtypefirebird.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypehsql.xml 
b/framework/entity/fieldtype/fieldtypehsql.xml
index fe96fff90a..3c72490ac9 100644
--- a/framework/entity/fieldtype/fieldtypehsql.xml
+++ b/framework/entity/fieldtype/fieldtypehsql.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypemssql.xml 
b/framework/entity/fieldtype/fieldtypemssql.xml
index 25e2d05199..88a69be1ef 100644
--- a/framework/entity/fieldtype/fieldtypemssql.xml
+++ b/framework/entity/fieldtype/fieldtypemssql.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypemysql.xml 
b/framework/entity/fieldtype/fieldtypemysql.xml
index beb9fa36d3..2f07bff189 100644
--- a/framework/entity/fieldtype/fieldtypemysql.xml
+++ b/framework/entity/fieldtype/fieldtypemysql.xml
@@ -46,8 +46,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypeoracle.xml 
b/framework/entity/fieldtype/fieldtypeoracle.xml
index 03e66ab9fe..394951a0a4 100644
--- a/framework/entity/fieldtype/fieldtypeoracle.xml
+++ b/framework/entity/fieldtype/fieldtypeoracle.xml
@@ -60,8 +60,8 @@ under the License.
   
   

-
-
+
+
   
   

diff --git a/framework/entity/fieldtype/fieldtypepostgres.xml 
b/framework/entity/fieldtype/fieldtypepostgres.xml
index 8cb243e068..3e3555a5c1 100644
---