Retrieve details of customers associated with a project.

Select

This is a project-level view.

• Name supports '=,!=,CONTAINS' operators
• City supports '=,!=,CONTAINS' operators
• State supports '=,!=,CONTAINS' operators
• Country supports '=,!=,CONTAINS' operators
• ZipCode supports '=,!=,CONTAINS' operators
• AddressFirst supports '=,!=,CONTAINS' operators
• AddressSecond supports '=,!=,CONTAINS' operators
• WebAddress supports '=,!=,CONTAINS' operators
• IsPrimary supports '=,!=' operators

• Columns that support server-side ORDER BY: Id, Name, City, State, Country, ZipCode, AddressFirst, AddressSecond, WebAddress, IsPrimary

For example, the following query is processed server side:

SELECT * FROM Customers WHERE Name = 'John Doe' ORDER BY Id

Columns

Name	Type	Description
Id [KEY]	Long	Customer Id.
Name	String	Customer Name.
Type	String	Customer Type.
City	String	Customer City.
State	String	Customer State.
Country	String	Customer Country.
ZipCode	String	Customer Zip Code.
AddressFirst	String	Customer Address First Line.
AddressSecond	String	Customer Address Second Line.
AssociatedContactCount	Integer	Number of contacts associated with the customer.
AssociatedUserCount	Integer	Number of users associated with the customer.
WebAddress	String	Customer Web Address.
IsPrimary	Boolean	Customer Is Primary.