Using the Query Builder in Popdock has many benefits for your reports. It allows for more efficient and faster queries as well as a full range of customizations. The Query Builder is also quite helpful when it comes to utilizing custom API endpoints for use with PowerBI as well.
Query Builder Field Names
There are a few different Query Builder field names that are utilized in this manner. This article clarifies the differences and provides information regarding each one.
Field Name
In the Query Builder, the Field Name refers to the original name of the field as it exists in the underlying table. This value is pulled directly from the table itself and identifies the field you are working with.
Alias
The alias for a field in the Query Builder is a unique name assigned to a field to identify it within the query. Every field must have a unique alias, otherwise the query will not run. This is especially important when multiple fields share the same name; assigning different aliases allows the system to distinguish between them. The alias does not affect the underlying data but ensures the query executes correctly. For more information, you can click the info icon next to the Alias label.
Name (Display Name)
The Display Name (or Name) field determines how the field appears in your report. It doesn’t need to match the actual field name or alias used in the data source. This feature is primarily used to rename fields for better readability or presentation. For example, you might label a field as “Account ID Number” instead of the default “Account ID”. This change is purely cosmetic—it affects only how the field is displayed in the report and does not impact the underlying query or its relationship to the table in the Query Builder.
Looking for more resources about Query Builder? Visit our knowledge base for related information on how to create a Query Builder list.
Questions on Query Builder field names? Email support at support@eonesolutions.com
