Data Table
Discussion List
-
Can we use BMQL query where condition using case insensitive text comparing Data table column text?Summary: In Oracle CPQ cloud we have some data in data table column that has in different cases. so is it possible to query using bmql irrespective of the case of text a… -
Get table row ID in CSV ExportSummary: When we get a table using REST API, we see a id for each row. Is it possible to get it in CSV export? I want to delete table data but my table does not have nat…
-
Friday Fun - Quiz on Data TablesHi all, it is Friday! Let's have some fun along with knowledge check with Data Tables😊 These are very simple questions which we are starting with. Quiz 1) What is the ma… -
How to update/delete data from data tables via importSummary: How to update/delete data from data tables via import Content (required): Looking for a sample import file to update and delete data from data tables Version (i…S.Kumar 41 views 1 comment 0 points Most recent by Emmanuel Zambrano-Support-Oracle Configure Price Quote
-
Filter data table on a SKU with - (dashes) in itSummary: so weird I searched for a part number 4550V2-101-0050 in a data table with prices and a bunch of records come up because the records have 4550 in a different co…User_2025-02-11-03-24-41-964 21 views 1 comment 0 points Most recent by bla-Oracle Configure Price Quote -
bmql select best options when fields can be blankSummary: wondering if there is a way to find best record option when 3 of the fields can be blank meaning any input Content (required): we have a table that we use a lar…User_2025-02-11-03-24-41-964 51 views 6 comments 0 points Most recent by Matt916 Configure Price Quote
-
create a util to count number of records in a recordsetSummary: often we need to see how many records are in a record set or to see if its empty. isnull or isempyty don't work so we have to manually count it using a for each…User_2025-02-11-03-24-41-964 51 views 3 comments 0 points Most recent by User_2025-02-11-03-24-41-964 Configure Price Quote
-
How to Clear all Records from Datatable using SOAP API?Summary: To clear all records from a data table using a SOAP call. Content (required): I want to clear all records from a datatable using SOAP. Im able to see the option… -
How to increase the number of decimal places in the float columns of data tables?**This post was created as part of a How to Service Request (SR) Release: 22B Patch 2 Summary of the question: How to increase the number of decimal places in the float …Adrian-Support-Oracle 42 views 1 comment 0 points Most recent by Adrian-Support-Oracle Configure Price Quote