Method DetailPacketDataList addDataList(String name, DataList dataList) Combines the given DataList with this one in a new DataList. Columns that match the names of this DataList are included and others are omited.
Parameters:
Returns: PacketDataList Since: 01-19-2009 DataList applyFilter(DataListFilter filter) Returns a new DataList with records from this list that match the filter.
Parameters:
Returns: DataList Since: 01-19-2009 PacketDataList bubble(String name, String idColumn, String idDelim, String countColumn, String xColumn, String yColumn, boolean relative) Performs an aggregation on the data elements of this list and returns a list suitable for use in bubble charts.
Parameters:
Returns: PacketDataList Since: 07-01-2011 String calcMD5() Returns an MD5 checksum of the contents of this list. Returns: String Since: 05-15-2014 PacketDataList collapse(String keyId, String[] keyColumns, String listColumn, String[] listColumns) Reduces a list with duplicate data into a list with unique data adding a new serialized JSON column containing the duplicate information. See also tag c:expand.
Parameters:
Returns: PacketDataList Since: 03-28-2019 PacketDataList copy(String name) Creates a new PacketDataList from this DataList.
Parameters:
Returns: PacketDataList Since: 11-19-2009 DataListFilter createAndFilter() Creates an empty DataListFilter based on this DataList. Filter will return records matching all constraints. Returns: DataListFilter Since: 01-13-2009 DataListFilter createOrFilter() Creates an empty DataListFilter based on this DataList. Filter will return records matching any constraints. Returns: DataListFilter Since: 01-13-2009 Payload createSublists(String prefix, int listSize) Returns a Payload containing one or more lists named prefixN (starting with 1) with a list called prefix containing the names of the lists created.
Parameters:
Returns: Payload Since: 05-15-2014 DataRecord findRecord(DataListFilter filter) Finds the first record matching the given filter. Returns null if no matching record found.
Parameters:
Returns: DataRecord Since: 09-11-2009 DataRecord findRecord(String column, String value) Returns the first record whose column matches the given value.
Parameters:
Returns: DataRecord Since: 04-28-2009 PacketDataList flatten(String keyId) Reduces a list with duplicate data into a list with unique data with later rows filling in empty values in prior rows that match the key.
Parameters:
Returns: PacketDataList Since: 08-07-2019 PacketDataList flatten(String[] key, String countColumn) Reduces a list with duplicate data into a list with unique data with later rows filling in empty values in prior rows that match the multi-value key. An optional countColumn can be created which represents the number of times the composite key was encountered.
Parameters:
Returns: PacketDataList Since: 06-29-2023 int getColumnCount() Returns the column count for this list Returns: int Since: 07-11-2008 String[] getColumnNames() Returns the columns of this DataList Returns: String[] Since: 01-19-2009 DataList getColumns() Returns the column names of this DataList as a DataList. Returns: DataList DataList Name: columns DataList Fields: name Since: 02-16-2011 String getName() Returns the name of this list Returns: String Since: 07-11-2008 PagingInfo getPagingInfo() Returns the paging info object. This object will only be set if the filterByPage or enablePaging methods were called from DataViewFilter. Returns: PagingInfo Since: 05-18-2009 String getQuery() Returns the query statement used to generate this list. Returns: String Since: 02-22-2016 This method has been deprecated since 05-02-2016. Use DataView or DatSet.getQuery(filter) DataRecord getRecord(int index) Returns the record at the specified index
Parameters:
Returns: DataRecord Since: 07-11-2008 DataViewRecord getRecord(int index) Returns the record at the specified index
Parameters:
Returns: DataViewRecord Since: 07-11-2008 int getRecordCount() Returns the number of records in this list Returns: int Since: 07-11-2008 double getTotal(String column, double defaultValue) Returns the total of the given column. If the value of the individual record cannot compute to a double, defaultValue is used.
Parameters:
Returns: double Since: 09-23-2008 int getTotalRecordCount(DataListFilter filter) Returns the total count of records that match the DataListFilter.
Parameters:
Returns: int Since: 03-25-2009 boolean isReadOnly() Returns true if this is a read-only list Returns: boolean Since: 08-16-2007 PacketDataList joinDataList(String name, String joinColumn, DataList dataList) Joins the DataList with this one into a new DataList that is joined by the joinColumn and that has the columns of both data lists.
Parameters:
Returns: PacketDataList Since: 03-03-2009 PacketDataList mergeDataList(String name, DataList dataList, String indexColumn) Merges the DataList with this one into a new DataList using an indexed column. All records in this list are kept but the values that match the index column are replaced by those in the supplied dataList. The index column should contain unique values representing a 1:1 relationship between the two lists.
Parameters:
Returns: PacketDataList Since: 01-19-2009 PacketDataList pivot(String key, String pivot, String amt, String op) Returns a new list with the key, the same name with columns specified by the pivot values, and the key+'Total' on the specified operation. The amt column must be numeric and maximum columns is 100.
Parameters:
Returns: PacketDataList Since: 10-30-2019 setName(String name) Sets the name of this list.
Parameters:
Since: 07-11-2008 PacketDataList split(String name, String[] columns) Returns a new datalist containing only those columns specified.
Parameters:
Returns: PacketDataList Since: 06-01-2021 PacketDataList sublist(String name, int start, int end) Creates a new PacketDataList from this DataList with the range of records specified. Returns an empty list if no more records within the range.
Parameters:
Returns: PacketDataList Since: 01-20-2011 String[] toArray(String columnName) Returns the values of the specified column as an array. Throws exception if the column does not exist.
Parameters:
Returns: String[] Since: 06-05-2013 Data toData(String keyColumn, String valueColumn, boolean addNullValues) Creates a Data object with keys coming from key column and values from value column. Overwrites any keys that are duplicated. Returns null if the keyColumn or valueColumn does not exist. If addNullValues is true then null values will be added as empty string.
Parameters:
Returns: Data Since: 10-06-2009 File toFile(String fileName, String delim) Creates csv/pipe/tab delimited file from data list. File will reflect current datalist state. Further modifications of datalist will not have effect on file contents. File limit is controlled by the max data export size of the activation key.
Parameters:
Returns: File Since: 11-02-2010 String toJSON(boolean compressDataList) Returns contents as a JSON string.
Parameters:
Returns: String Since: 08-30-2010 String toJsonArray(boolean includeNull, Data typeMap) Returns contents as a JSON Array string. An optional key map should have field name types defined as string, int, long, double, boolean, or date. This method is limited by the max export size of the activation key.
Parameters:
Returns: String Since: 09-16-2020 String toString() Returns a description of this object. Returns: String Since: 01-19-2009 |
Copyright © 2006 - 2024, ContractPal, Inc. All rights reserved. | API Date: May 01, 2024 05:15 AM |