Get details of Products Prices.

Select

The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.

• Id supports the '=' operator.
• Code supports the 'LIKE' operator.
• Name supports the 'LIKE' operator.
• FirstChar supports the '=' operator.
• FilterId supports the '=' operator.
• UserId supports the '=' operator.
• GetSummary supports the '=' operator.
• Ids supports the '=,IN' operators.

For example, the following query is processed server side:

SELECT * FROM ProductsPrices WHERE Id = 14

SELECT * FROM ProductsPrices WHERE Name LIKE '%Cdata%'
    
SELECT * FROM ProductsPrices WHERE code LIKE '%123%'
    
SELECT * FROM ProductsPrices WHERE FirstChar = 'c'
    
SELECT * FROM ProductsPrices WHERE FilterId = 1
     
SELECT * FROM ProductsPrices WHERE UserId = 1       
    
SELECT * FROM ProductsPrices WHERE GetSummary = 1
    
SELECT * FROM ProductsPrices WHERE Ids IN (1, 2) 

Columns

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.