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
Last revisionBoth sides next revision
protogrid:json_api_database_views [2022-05-14 00:48] – [Overall Views With Filtering/Sorting] druprotogrid:json_api_database_views [2022-05-14 00:51] – [Adjustments to Views With Version 2.2.2] dru
Line 273: Line 273:
 } }
 </code> </code>
- 
-=== by_proto_and_search_term_and_sortstring_and_id === 
-This view contains all non-deleted and non-hidden Cards by proto and searchterm (see also [[#by_search_term_and_sortstring_and_id|by_search_term_and_sortstring_and_id]]. Therefore the key is composed of the Proto key, the searchterm, the Card sorting string and the Card key. Example: 
-<code> 
-["9c2bdd7d-05bd-4d16-8339-11116e737b3a", "wants", "Priscilla Molesworth - wishes an offer - Luxor 600t", "21f28df9-b0fd-431d-a773-5c6f58ff94a2"] 
-</code> 
- 
-Example Request to get all Cards of Proto "9c2bdd7d-05bd-4d16-8339-11116e737b3a" containing the string "wants": 
-<code> 
-https://example.protogrid.com/api/v2/apps/produktekatalog/views/by_proto_and_search_term_and_sortstring_and_id?start_key=["9c2bdd7d-05bd-4d16-8339-11116e737b3a","wants",null,null]&end_key=["9c2bdd7d-05bd-4d16-8339-11116e737b3a","wants",{},{}] 
-</code> 
- 
-Example response: 
-<code javascript > 
-{ 
-    "errors": [], 
-    "result": { 
-        "rows": [ 
-            { 
-                "key": [ 
-                    "9c2bdd7d-05bd-4d16-8339-11116e737b3a", 
-                    "wants", 
-                    "Priscilla Molesworth - wishes an offer - Luxor 600t", 
-                    "21f28df9-b0fd-431d-a773-5c6f58ff94a2" 
-                ], 
-                "value": null 
-            }, 
-            ... 
-        ] 
-    } 
-} 
-</code> 
- 
  
 === by_proto_and_design_element_and_sortstring_and_id === === by_proto_and_design_element_and_sortstring_and_id ===
Line 356: Line 323:
 === deleted_by_sortstring_and_id === === deleted_by_sortstring_and_id ===
 This view contains the IDs of all the deleted Cards as keys. The value is null. The request and response are analog to view [[#by_sortstring_and_id|"by_sortstring_and_id"]]. This view contains the IDs of all the deleted Cards as keys. The value is null. The request and response are analog to view [[#by_sortstring_and_id|"by_sortstring_and_id"]].
- 
-=== deleted_by_search_term_and_sortstring_and_id === 
-This view contains all deleted Cards for a certain search term by id. The value is null. The request and response are analog to view [[#by_search_term_and_sortstring_and_id|"by_search_term_and_sortstring_and_id"]]. 
  
 === deleted_by_design_element_and_sortstring_and_id === === deleted_by_design_element_and_sortstring_and_id ===
Line 645: Line 609:
     * View columns of "by_design_element_and_sortstring_and_id" before: ["816950eb-1b70-41e2-89f5-5400f9636345", "nightTable 2.0", "9a5f37ab-30a7-4c91-b99f-f573a1c7d1b9"]     * View columns of "by_design_element_and_sortstring_and_id" before: ["816950eb-1b70-41e2-89f5-5400f9636345", "nightTable 2.0", "9a5f37ab-30a7-4c91-b99f-f573a1c7d1b9"]
     * View columns of by_design_element_and_sortstring_and_id"" now: ["816950eb-1b70-41e2-89f5-5400f9636345", "nightTable 2.0", "nightTable 2.0 - furniture", "9a5f37ab-30a7-4c91-b99f-f573a1c7d1b9"]     * View columns of by_design_element_and_sortstring_and_id"" now: ["816950eb-1b70-41e2-89f5-5400f9636345", "nightTable 2.0", "nightTable 2.0 - furniture", "9a5f37ab-30a7-4c91-b99f-f573a1c7d1b9"]
 +
 +==== Standard Views Decommissioned With Version 2.6.0 ====
 +  * by_search_term_and_sortstring_and_id
 +  * by_proto_and_search_term_and_sortstring_and_id
 +  * deleted_by_search_term_and_sortstring_and_id
Print/export