ODBC Driver for SAP Concur

Build 23.0.8791

ListItemsV4

Lists list items based on the search criteria

Table Specific Information

Select

The 本製品 uses the SAP Concur APIs to get list items based on the search criteria.

Searching list items by listId retrieves the first level of list items. In order to get all children recursively, you must set the RecursionDepth connection property to the desired depth of list. This retrieves a list that includes children up to the specified depth automaticaly.

In the following queries, the 本製品 offloads the processing to the SAP Concur APIs:

SELECT * FROM ListItemsV4 where id IN ( '665E58E7E1226346BC424861DEC93F30','3FB790E49CDC924F8B4BA29623B18D2D')
SELECT * FROM ListItemsV4 where ListId IN ( '3e5ce609-bcf7-7d49-884c-baf70588d4bc','241563a3-bf89-4842-a0fb-6cbd06c87c0c')
SELECT * FROM ListItemsV4 where ListId = '3e5ce609-bcf7-7d49-884c-baf70588d4bc' AND Id = '3FB790E49CDC924F8B4BA29623B18D2D'

Columns

Name Type References Description
Id [KEY] String The unique identifier of the list item.
Code String List item long code.
ShortCode String List item short code.
Value String List item value.
ParentId String The unique identifier of the parent list item.
ListId String The unique identifier of the list that contains the list item.
Level Int Level of the list item within the list.
HasChildren Boolean If true, the list item has children in this particular list.
Lists String The unique identifiers of the lists that contains the list item. The list item may exist under one or more lists.
IsDeleted Boolean Indicates the deleted state of the item in a particular list. If false, the list item is not deleted from one or more lists. The lists field will include only the lists that contain the list item in a not-deleted state. isDeleted will only be true when the list item is deleted from all lists. The lists field will include all lists that contain the list item.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8791