Differences

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

Link to this comparison view

protogrid:json-api_methode_get_current_user_profile_key [2017-10-22 16:30] – created hmaprotogrid:json-api_methode_get_current_user_profile_key [2020-12-22 15:53] (current) – Gelöscht da dedupliziert im JSON-View-Artikel dru
Line 1: Line 1:
-====== JSON-API ViewListEndpoint sums_by_proto_and_design_element_and_condition ====== 
  
-Sums over the values of a field for all Cards of a [[Proto]] given a condition from another field.  
- 
-This endpoint requires four query key components: 
-  - The Proto key 
-  - The design element key for the field to sum over 
-  - The design element key for the condition field 
-  - The conditional value in the field specified in third component 
- 
-Depending on the field type to sum over (see component 2 above) the endpoint returns: 
-  - For number fields it produces the sum of values over the field. 
-  - For text fields it produces the word count over all text entries. 
-  - For relation fields it produces the number of stored relations. 
-  - For date/time fields it produces the number of stored date/time values. 
- 
-<code> 
-Example:  
-What is the sum over all values in the “Total” field in the Proto “Invoice”, given that the relation field “customer” holds the key for “John Smith”? 
-</code> 
Print/export