RE: [odata] Agenda for OData TC meeting on 2017-08-31 - chat transcript

["Handl, Ralf" <ralf.handl@sap.com>]

[14:48] Room information was updated by: Stefan Hagen

OASIS Open Data Protocol (OData) TC OData TC Weekly Meeting (Conference Call) #185

- Thursday, 31 August 2017, 08:00am to 10:00am PDT

  - i.e. 2017-08-31 17:00 to 19:00 CEST (UTC+2)

  - other timezone? Try eg.:

  - https://www.timeanddate.com/worldclock/meetingdetails.html?year=2017&month=8&day=31&hour=15&min=0&sec=0&p1=47&p2=69&p3=179

UsefulPlaces:

- Chat:

  - http://webconf.soaphub.org/conf/room/odatatc   # ... this place 

- ScreenShare and Voice:

  - https://sap.emea.pgiconnect.com/OData-TC/

Next Planned meetings (tentative):

- Thursday September 07, 2017 during 8-10 am PDT?

  - https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43994

- Thursday September 14, 2017 during 8-10 am PDT?

  - https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43995

- Thursday September 21, 2017 during 8-10 am PDT?

  - https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43996

Agenda-Draft E-Mail URL:

- E-Mail Public URL = "" href="https://lists.oasis-open.org/archives/odata/201708/msg00102.html" target="_blank">https://lists.oasis-open.org/archives/odata/201708/msg00102.html

Minutes Draft Public URL (previous meeting):

- URL = "" href="https://www.oasis-open.org/committees/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html" target="_blank">https://www.oasis-open.org/committees/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html

Online document walkthroughs or presentations:

- URL = "" href="https://sap.emea.pgiconnect.com/OData-TC/" target="_blank">https://sap.emea.pgiconnect.com/OData-TC/

Timeline:

- URL = "" href="https://www.oasis-open.org/committees/download.php/59862/TC%20Timeline-2017-01-25.docx" target="_blank">https://www.oasis-open.org/committees/download.php/59862/TC%20Timeline-2017-01-25.docx

Agenda Draft (for meeting #185):

==============================================================

1. Roll call [8:00 am PT]

1.1  Self-registration link: https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993 

2. Approve agenda [8:05 am PT]

3. Approve minutes from previous meeting(s) [8:10 am PT]

3.1  Minutes from August 24, 2017 TC meeting: https://www.oasis-open.org/committees/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html 

4. Review action items [Action item list: https://www.oasis-open.org/apps/org/workgroup/odata/members/action_items.php] [8:15am PT]

4.1  Action items due

4.1.1  None

5. Data Aggregation [8:20 am PT]

5.1  Gerald to walk us through the proposal on 

5.1.1    Grid-Like Access to Aggregated Data.docx

6.  Version 4.01 Public Review - 05 July 2017 to 03 August 2017  - Issues [9:20 am PT]

6.1    ODATA-1100 Add mechanism for specifying match type for $search

6.2    ODATA-1105 Simplify selection of properties of complex type

6.3    ODATA-1107 Introduce instance annotation to specify which types an instance "implements"

6.4    ODATA-1108 Disallow empty parens for implicit parameter syntax

6.5    ODATA-1109 Clarify that 'parameter' aliases can also be used to substitute expressions

7.  Issues [9:40 am PT]

7.1  Vocabularies: NEW or OPEN

7.1.1    ODATA-1099 Add annotations to describe custom query options and custom headers

  META 1: use issue-specific branches for new terms, types, properties, or add them to master branch and mark them as experimental?

  META 2: add examples to term definitions as shown here via annotation Core.Example?

7.1.2    ODATA-1067 Consider ability to define computed default values

7.1.3    ODATA-1060 Improve specification of element response requirements

7.1.4    ODATA-1005 Make sure we have capabilities for all new 4.01 functionality

7.1.5    ODATA-884 Add term ErrorCodes to describe possible codes in error messages (public comment c201510e00019)

7.2  Vocabularies: APPLIED

7.2.1    ODATA-958 Capabilities: FilterRestrictions and SortRestrictions for navigation properties

7.2.2    ODATA-1055 DeepInsertSupport: allow applying to entity sets and collection-valued navigation properties

7.2.3    ODATA-1064 Add ability to annotate collections to return only count and NextLink

7.2.4    ODATA-1069 New term Core.OperationAvailable

7.2.5    ODATA-1079 Several issues with latest standard vocabularies

7.2.6    ODATA-1082 Add term Constraint to Validation vocabulary

7.2.7    ODATA-1089 Org.OData.Aggregation.V1 missing Nullable="false" for Function ReturnType

7.2.8    ODATA-1098 xxxRestrictions can be applied more broadly

8.  Next meetings [9:50 am PT]

8.1   Thursday September 07, 2017 during 8-10 am PDT

9.  AOB and wrap up [9:55 am PT]

==============================================================

Meeting Member URL:

- URL = "" href="https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993" target="_blank">https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993

  - Please use starting approx. 15 minutes before the meeting for self registration. Thanks.

  - Self registration deep link (as a service):

    - https://www.oasis-open.org/apps/org/workgroup/odata/record_my_attendance.php?event_id=43993&confirmed=1

 

[14:51] Stefan Hagen: Currently (since this morning) the scribe seems to rarely be able to access the OASIS backend systems that contact read-write attendance info ... thus attendance might need tracking based on chat and by the officers for post meeting entry into the kavi systems

[15:07] Stefan Hagen: KeepAlive

[15:16] Stefan Hagen: KeepAlive

 

[15:33] Stefan2: KeepAlive

 

[16:00] Stefan: KeepAlive

 

[16:04] Stefan1: KeepAlive

 

[16:25] Stefan: KeepAlive

 

[16:41] Stefan Hagen: KeepAlive

 

Room Information:

OASIS Open Data Protocol (OData) TC OData TC Weekly Meeting (Conference Call) #185

- Thursday, 31 August 2017, 08:00am to 10:00am PDT

  - i.e. 2017-08-31 17:00 to 19:00 CEST (UTC+2)

  - other timezone? Try eg.:

  - https://www.timeanddate.com/worldclock/meetingdetails.html?year=2017&month=8&day=31&hour=15&min=0&sec=0&p1=47&p2=69&p3=179

UsefulPlaces:

- Chat:

  - http://webconf.soaphub.org/conf/room/odatatc   # ... this place 

- ScreenShare and Voice:

  - https://sap.emea.pgiconnect.com/OData-TC/

Next Planned meetings (tentative):

- Thursday September 07, 2017 during 8-10 am PDT?

  - https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43994

- Thursday September 14, 2017 during 8-10 am PDT?

  - https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43995

- Thursday September 21, 2017 during 8-10 am PDT?

  - https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43996

Agenda-Draft E-Mail URL:

- E-Mail Public URL = "" href="https://lists.oasis-open.org/archives/odata/201708/msg00102.html" target="_blank">https://lists.oasis-open.org/archives/odata/201708/msg00102.html

Minutes Draft Public URL (previous meeting):

- URL = "" href="https://www.oasis-open.org/committees/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html" target="_blank">https://www.oasis-open.org/committees/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html

Online document walkthroughs or presentations:

- URL = "" href="https://sap.emea.pgiconnect.com/OData-TC/" target="_blank">https://sap.emea.pgiconnect.com/OData-TC/

Timeline:

- URL = "" href="https://www.oasis-open.org/committees/download.php/59862/TC%20Timeline-2017-01-25.docx" target="_blank">https://www.oasis-open.org/committees/download.php/59862/TC%20Timeline-2017-01-25.docx

Agenda Draft (for meeting #185):

==============================================================

1. Roll call [8:00 am PT]

1.1  Self-registration link: https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993 

2. Approve agenda [8:05 am PT]

3. Approve minutes from previous meeting(s) [8:10 am PT]

3.1  Minutes from August 24, 2017 TC meeting: https://www.oasis-open.org/committees/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html 

4. Review action items [Action item list: https://www.oasis-open.org/apps/org/workgroup/odata/members/action_items.php] [8:15am PT]

4.1  Action items due

4.1.1  None

5. Data Aggregation [8:20 am PT]

5.1  Gerald to walk us through the proposal on 

5.1.1    Grid-Like Access to Aggregated Data.docx

6.  Version 4.01 Public Review - 05 July 2017 to 03 August 2017  - Issues [9:20 am PT]

6.1    ODATA-1100 Add mechanism for specifying match type for $search

6.2    ODATA-1105 Simplify selection of properties of complex type

6.3    ODATA-1107 Introduce instance annotation to specify which types an instance "implements"

6.4    ODATA-1108 Disallow empty parens for implicit parameter syntax

6.5    ODATA-1109 Clarify that 'parameter' aliases can also be used to substitute expressions

7.  Issues [9:40 am PT]

7.1  Vocabularies: NEW or OPEN

7.1.1    ODATA-1099 Add annotations to describe custom query options and custom headers

  META 1: use issue-specific branches for new terms, types, properties, or add them to master branch and mark them as experimental?

  META 2: add examples to term definitions as shown here via annotation Core.Example?

7.1.2    ODATA-1067 Consider ability to define computed default values

7.1.3    ODATA-1060 Improve specification of element response requirements

7.1.4    ODATA-1005 Make sure we have capabilities for all new 4.01 functionality

7.1.5    ODATA-884 Add term ErrorCodes to describe possible codes in error messages (public comment c201510e00019)

7.2  Vocabularies: APPLIED

7.2.1    ODATA-958 Capabilities: FilterRestrictions and SortRestrictions for navigation properties

7.2.2    ODATA-1055 DeepInsertSupport: allow applying to entity sets and collection-valued navigation properties

7.2.3    ODATA-1064 Add ability to annotate collections to return only count and NextLink

7.2.4    ODATA-1069 New term Core.OperationAvailable

7.2.5    ODATA-1079 Several issues with latest standard vocabularies

7.2.6    ODATA-1082 Add term Constraint to Validation vocabulary

7.2.7    ODATA-1089 Org.OData.Aggregation.V1 missing Nullable="false" for Function ReturnType

7.2.8    ODATA-1098 xxxRestrictions can be applied more broadly

8.  Next meetings [9:50 am PT]

8.1   Thursday September 07, 2017 during 8-10 am PDT

9.  AOB and wrap up [9:55 am PT]

==============================================================

Meeting Member URL:

- URL = "" href="https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993" target="_blank">https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993

  - Please use starting approx. 15 minutes before the meeting for self registration. Thanks.

  - Self registration deep link (as a service):

    - https://www.oasis-open.org/apps/org/workgroup/odata/record_my_attendance.php?event_id=43993&confirmed=1

 

[16:59] Ralf Handl (SAP SE): Please note: self-registration currently doesn't work

 

[17:00] Stefan Hagen: So present are currently: Ralf, Ted and Stefan

 

[17:00] Ralf Handl (SAP SE): George and Mark announced to be late today

 

[17:01] Stefan Hagen: Hubert also entered, that makes currently 4 voting members

 

[17:01] Ralf Handl (SAP SE): So far no one in the call

 

[17:02] Stefan Hagen: I currently have trouble on my end to enter anything more "complex" - working on it.

[17:02] Stefan Hagen: So we will have quorum (norm is 12) when we have more than 6 members register / note their attendance

[17:03] Stefan Hagen: Actually now :-)

[17:03] Stefan Hagen: Present Gerald, Hubert, Matt, Mike, Ralf, Stefan, and Ted that makes 7 / 12

 

[17:04] anonymous morphed into Martin Z. SAP SE

 

[17:04] Matt Borges (SAP): I'm having trouble self-registering

 

[17:04] Ralf Handl (SAP SE): We all do :-)

[17:04] Ralf Handl (SAP SE): Stefan will register us later

 

[17:04] Stefan Hagen: Do not worry Matt, we will do this after the meeting

[17:04] Stefan Hagen: race condition :-) thanks Ralf

[17:05] Stefan Hagen: Martin also noted as present

 

[17:05] Michael Pizzo: I am here.

 

[17:06] Ralf Handl (SAP SE): Quorum reached: 8 out of 12 voting members

[17:06] Ralf Handl (SAP SE): Waiting for Mike and Ted to join the telco

[17:07] Ralf Handl (SAP SE): Apparently there's also some lag with the telco system

[17:08] Ralf Handl (SAP SE): Note: you might have to install the Adobe Connect plugin (again)

 

[17:09] Ted Jones (Red Hat): Sorry.. trying to pull up the conf code. :(

 

[17:09] Ralf Handl (SAP SE): - URL = "" href="https://sap.emea.pgiconnect.com/OData-TC/" target="_blank">https://sap.emea.pgiconnect.com/OData-TC/

 

[17:09] Ted Jones (Red Hat): Thanks Ralf

 

[17:10] Ralf Handl (SAP SE): 2.Approve agenda [8:05 am PT]

[17:10] Ralf Handl (SAP SE): Agenda is approved

[17:10] Ralf Handl (SAP SE): 3.Approve minutes from previous meeting(s) [8:10 am PT]

a.Minutes from August 24, 2017 TC meeting: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html

[17:11] Ralf Handl (SAP SE): Minutes are approved

[17:11] Ralf Handl (SAP SE): 4.Review action items [Action item list: https://www.oasis-open.org/apps/org/workgroup/odata/members/action_items.php] [8:15am PT]

a.Action items due

i.None

[17:11] Ralf Handl (SAP SE): 5.Data Aggregation [8:20 am PT]

a.Gerald to walk us through the proposal on 

i.Grid-Like Access to Aggregated Data.docx

 

[17:30] Stefan Hagen: Ramesh also noted for post-meeting registration batch

[17:30] Stefan Hagen: Jeremy also noted ...

 

[17:37] anonymous morphed into George Ericson (Dell)

 

[17:38] Stefan Hagen: George also noted for registration batch post meeting :-)

[17:41] Stefan Hagen: @Mark and Martin: Both of you also noted for registration batch

 

[17:43] Ramesh Reddy(Red Hat): we always enforced a implicit ordering based on the key when $orderby is not defined

 

[17:44] Hubert Heijkers (IBM): OData Protocol does indeed state that: If no unique ordering is imposed through an $orderby query option, the service MUST impose a stable ordering across requests that include $skip.

[17:44] Hubert Heijkers (IBM): Same wording for $top

 

[18:15] Stefan Hagen: @All: George, Gerald, Hubert, Jeremy, Mark, Martin, Matt, Mike, Ralf, Ramesh, Stefan, and Ted now registered in OASIS kavi.

 

[18:23] Ralf Handl (SAP SE): 6.Version 4.01 Public Review - 05 July 2017 to 03 August 2017 [9:20 am PT]

a.Issues

[18:24] Ralf Handl (SAP SE): i.ODATA-1100 Add mechanism for specifying match type for $search

ii.ODATA-1105 Simplify selection of properties of complex type

iii.ODATA-1107 Introduce instance annotation to specify which types an instance "implements"

iv.ODATA-1108 Disallow empty parens for implicit parameter syntax

v.ODATA-1109 Clarify that 'parameter' aliases can also be used to substitute expressions

[18:24] Ralf Handl (SAP SE): v.ODATA-1109 Clarify that 'parameter' aliases can also be used to substitute expressions

[18:25] Ralf Handl (SAP SE): Current text "hidden" near the end of Part 2: URL Conventions

5.3 Parameter Aliases

Parameter aliases can be used in place of literal values in entity keys, function parameters, or within a $filter or $orderby _expression_.

Parameter aliases MUST start with an @ character, see rule parameterAlias in [OData-ABNF].

The semantics of parameter aliases are covered in [OData-Protocol]. The [OData-ABNF] rule aliasAndValue defines the formal grammar for passing parameter alias values as query options.

Example 124:

http://host/service/Movies?$filter=contains(@word,Title)&@word='Black'

Example 125:

http://host/service/Movies?$filter=Title eq @title&@title='Wizard of Oz'

Example 126: JSON array of strings as parameter alias value  note that [, ], and " need to be percent-encoded in real URLs, the clear-text representation used here is just for readability

http://host/service/Products/Model.WithIngredients(Ingredients=@i)?@i=["Carrots","Ginger","Oranges"]

[18:26] Ralf Handl (SAP SE): http://docs.oasis-open.org/odata/odata/v4.01/csprd02/part2-url-conventions/odata-v4.01-csprd02-part2-url-conventions.html#sec_ParameterAliases

 

[18:27] Matt Borges (SAP): $filter=@a&@a=contains('Black',Title)

 

[18:29] Ralf Handl (SAP SE): Example 67: return the number of products whose Price is less than $10.00

GET http://host/service/Products/$filter=@foo/$count?@foo=Price lt 10.00

[18:29] Ralf Handl (SAP SE): Example 79: delete all products older than 3

DELETE /service/Products/$filter=@foo/$each?@foo=Age gt 3

 

[18:32] Michael Pizzo: Customers?$filter=startswith(FirstName,'A') AND @a&@a=endswith(LastName,'Z')

 

[18:36] Ralf Handl (SAP SE): filterInPath = '/$filter' EQ parameterAlias

[18:49] Ralf Handl (SAP SE): $filter=Name eq 'Joe'

[18:49] Ralf Handl (SAP SE): $filter=Name eq 'James'

[18:50] Ralf Handl (SAP SE): $filter=Name eq @x&@x'Joe'

[18:50] Ralf Handl (SAP SE): $filter=Name eq @x&@x='Joe'

[18:51] Ralf Handl (SAP SE): $filter=Name eq @x&@x=concat('Jo','e')

[18:51] Ralf Handl (SAP SE): $filter=Name eq concat('Jo','e')

 

[18:57] Michael Pizzo: $filter=startswith(FirstName,@a)&@a='A'

[18:58] Michael Pizzo: $filter=startswith(FirstName,'A') AND @a&@a=endswith(LastName,'Z')

[19:03] Michael Pizzo: $filter=Orders($filter=ShipTo eq @a)&@a=City

 

[19:03] Ralf Handl (SAP SE): ODATA-1109 is OPEN

[19:03] Ralf Handl (SAP SE): Please add comments to this issue for your concerns or pros and cons

 

[19:03] Michael Pizzo: Customers?$filter=Orders($filter=ShipTo eq @a)&@a=City  => is City the city of the customer or the order....

 

[19:04] Ralf Handl (SAP SE): Meeting is adjourned

[19:04] Ralf Handl (SAP SE): Next meeting next week same time

 

 

From: odata@lists.oasis-open.org [mailto:odata@lists.oasis-open.org] On Behalf Of Handl, Ralf
Sent: Mittwoch, 30. August 2017 14:29
To: odata@lists.oasis-open.org
Subject: [odata] Agenda for OData TC meeting on 2017-08-31

 

Here [1] is a draft agenda for the OData TC (Technical Committee) meeting scheduled on Thursday August 31, 2017 during 8-10 am PDT (17:00-19:00 CEST). For additional information, such as dial-in details and chat room, refer to [2]. For TC timeline, see [3]. Feel free to suggest additions or modifications.

 

Thanks.

 

[1] Agenda

 

1.        Roll call [8:00 am PT]

1. Self-registration link: https://www.oasis-open.org/apps/org/workgroup/odata/event.php?event_id=43993

 

2.        Approve agenda [8:05 am PT]

 

3.        Approve minutes from previous meeting(s) [8:10 am PT]

1. Minutes from August 24, 2017 TC meeting: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/61447/latest/odata-meeting-184_on-20170824-minutes.html

 

4.        Review action items [Action item list: https://www.oasis-open.org/apps/org/workgroup/odata/members/action_items.php] [8:15am PT]

1. Action items due

                                  i.    None

 

5.        Data Aggregation [8:20 am PT]

1. Gerald to walk us through the proposal on

                                  i.    Grid-Like Access to Aggregated Data.docx

 

6.        Version 4.01 Public Review - 05 July 2017 to 03 August 2017 [9:20 am PT]

1. Issues

                                  i.    ODATA-1100 Add mechanism for specifying match type for $search

                                 ii.    ODATA-1105 Simplify selection of properties of complex type

                                iii.    ODATA-1107 Introduce instance annotation to specify which types an instance "implements"

                                iv.    ODATA-1108 Disallow empty parens for implicit parameter syntax

                                 v.    ODATA-1109 Clarify that 'parameter' aliases can also be used to substitute expressions

 

7.        Issues [9:40 am PT]

1. Vocabularies: NEW or OPEN

                                  i.    ODATA-1099 Add annotations to describe custom query options and custom headers

1. META 1: use issue-specific branches for new terms, types, properties, or add them to master branch and mark them as experimental?
2. META 2: add examples to term definitions as shown here via annotation Core.Example?

                                 ii.    ODATA-1067 Consider ability to define computed default values

                                iii.    ODATA-1060 Improve specification of element response requirements

                                iv.    ODATA-1005 Make sure we have capabilities for all new 4.01 functionality

                                 v.    ODATA-884 Add term ErrorCodes to describe possible codes in error messages (public comment c201510e00019)

 

2. Vocabularies: APPLIED

                                  i.     ODATA-958 Capabilities: FilterRestrictions and SortRestrictions for navigation properties

                                 ii.     ODATA-1055 DeepInsertSupport: allow applying to entity sets and collection-valued navigation properties

                                iii.    ODATA-1064 Add ability to annotate collections to return only count and NextLink

                                iv.    ODATA-1069 New term Core.OperationAvailable

                                 v.    ODATA-1079 Several issues with latest standard vocabularies

                                vi.    ODATA-1082 Add term Constraint to Validation vocabulary

                               vii.    ODATA-1089 Org.OData.Aggregation.V1 missing Nullable="false" for Function ReturnType

                              viii.    ODATA-1098 xxxRestrictions can be applied more broadly

 

8.        Next meetings [9:50 am PT]

1. Thursday September 07, 2017 during 8-10 am PDT

 

9.        AOB and wrap up [9:55 am PT]

 

[2] References

• Conference call details: https://www.oasis-open.org/apps/org/workgroup/odata/download.php/56760/TC%20meeting%20dial-in%20details.htm
• Chat room: http://webconf.soaphub.org/conf/room/odatatc

 

[3] Timeline

• https://www.oasis-open.org/committees/download.php/59862/TC%20Timeline-2017-01-25.docx