Analytics metrics, dimensions, and filters reference

This pageapplies toApigee andApigee hybrid.

View Apigee Edge documentation.

This topic is a reference for analytics metrics, dimensions, and filters. For more context on using these, seeAPI Analytics overview.

This topic shows the names for metrics and dimensions as they appear in the UI and as you need to use them in API calls.

Metrics

Following are the API metrics you can retrieve in custom reports and Apigee API calls.

MetricName to use in the Apigee APIFunctionsDescription
Average transactions per secondtpsNone

Average number of transactions, meaning API proxy requests, per second. Note that if you have a relatively low number of transactions over the time period, the average number of transactions per second could appear to be zero in UI custom reports if the number is smaller than two decimal places.

API syntax:tps

Cache hitcache_hitsum

Number of successful API requests that use theResponseCache instead of the response from the target service.

API syntax:sum(cache_hit)

L1 Cache elements countax_cache_l1_countavg, min, max

Number of elements in L1 (in-memory) cache per transaction over a given time period. For example, if you choosemax for the period of a day, and within that day the highest number of elements in cache is 12 for a specific transaction, then the count will be 12. Foravg, if there are three transactions in the time period you're querying, and their cache counts are 5, 6, and 7, the average is 6. L1 cache is in-memory cache as opposed to L2 database cache, as described inCache internals.

API syntax:avg(ax_cache_l1_count)

Policy errorspolicy_errorsum

Total number of policy errors over the specified time period.

Policy errors usually occur by design. For example, theVerifyApiKey policy throws an error when an invalid API key is passed in the request, and aSpikeArrest policy throws an error if the number of API calls exceeds the limit defined in the policy. So this metric is useful for finding potential trouble spots in your APIs. For example,policy_error metrics, grouped by thedeveloper_app dimension, might help you discover that an API key or OAuth token has expired for a given app; or you might find that a specific API proxy is throwing a lot ofSpikeArrest policy errors, leading you to discover that the proxy's spike arrest limit doesn't account for an increase in holiday traffic.

A policy error is logged in analytics only if the error results in API proxy failure. For example, if a policy'scontinueOnError attribute is set totrue, the API proxy continues processing a request even if the policy fails. In that case, a policy error is not logged in analytics.

The Policy Name on Error (ax_execution_fault_policy_name) dimension is useful for grouping policy errors by policy name.

A target failure (such as a404 or503) does not count as a policy failure. Those count as API proxy failures (is_error).

API syntax:sum(policy_error)

Proxy errorsis_errorsum

Total number of times API proxies failed over the specified time period. Proxy failure can occur when a policy fails or when there's a runtime failure, such as a404 or503 from the target service.

The Proxy (apiproxy) dimension is useful for grouping API proxy failures by proxy.

API syntax:sum(is_error)

Request processing latencyrequest_processing_latencyavg, min, max

Amount of time (average, minimum, or maximum), inmilliseconds, that it takes Apigee to process incoming requests. The time starts when the request reaches Apigee and ends when Apigee forwards the request to the target service.

Using different dimensions, you can examine request processing latencies by API proxy, developer app, region, and so on.

API syntax:max(request_processing_latency)

Request sizerequest_sizesum, avg, min, max

Size of the request payload received by Apigee, inbytes.

API syntax:avg(request_size)

Response cache executedax_cache_executedsum

Total number of times aResponseCache policy was executed over the given time period.

Since theResponseCache policy is attached in two places in an API proxy (once in the request and once in the response), it usually executes twice in an API call. A cacheGET and a cachePUT each count as one execution.

However, response cache execution is 0 if the<SkipCacheLookup> element in the policy evaluates to true (in the request), and 0 if the<SkipCachePopulation> element in the policy evaluates to true (in the response).

In theDebug tool, you can click theResponseCache icon in an executed API call and view theresponsecache.executedflow variable to see whether or not there was a cache execution (a value of 1).

API syntax:sum(ax_cache_executed)

Response processing latencyresponse_processing_latencyavg, min, max

Amount of time (average, minimum, or maximum), inmilliseconds, that it takes Apigee to process API responses. The time starts when the API proxy receives the target service response and ends when Apigee forwards the response to the original caller.

Using different dimensions, you can examine response processing latencies by API proxy, region, and so on.

API syntax:min(response_processing_latency)

Response sizeresponse_sizesum, avg, min, max

Size of the response payload returned to the client, inbytes.

API syntax:max(response_size)

Target errorstarget_errorsum

Total number of5xx responses from the target service. These are target service errors not caused by Apigee.

API syntax:sum(target_error)

Target response timetarget_response_timesum, avg, min, max

Amount of time (sum, average, minimum, or maximum), inmilliseconds, for the target server to respond to a call. This metric tells you how target servers are performing. The time starts when Apigee forwards a request to the target service and ends when Apigee receives the response.

Note that if an API call returns a response from cache (using theResponseCache policy, for example), the call will never reach the target service, and no target response time metrics are logged.

API syntax:avg(target_response_time)

Total response timetotal_response_timesum, avg, min, max

Amount of time (sum, average, minimum, or maximum), inmilliseconds, from when Apigee receives a request from a client to when Apigee sends the response back to the client. The time includes network overhead (such as the time it takes load balancers and routers to do their work), request processing latency, response processing latency, and target response time (if the response is served from the target service instead of cache).

Using different dimensions, you can examine processing latencies by API proxy, developer app, region, and so on.

API syntax:avg(total_response_time)

Trafficmessage_countsum

Total number of API calls processed by Apigee in the specified time period.

Use dimensions to group traffic counts in ways that are most meaningful to you.

API syntax:sum(message_count)

Monetization
Feesfeessum, avg, min, max

Fee amount.

API syntax:sum(fees)

Developer share of revenuex_apigee_mintng_dev_sharesum, avg, min, max

Developer's share in a transaction's revenue. Apigee calculates the developer's share only if you have enabled revenue sharing in your rate plan.

The developer's share is calculated using the following formula:

x_apigee_mintng_dev_share = revShareGrossPrice * (share percentage)

The value of the share percentage is fetched from your rate plan.

API syntax:sum(x_apigee_mintng_dev_share)

Monetization pricex_apigee_mintng_pricesum, avg, min, max

Total revenue of a transaction. The revenue of a transaction is set to the value of therevShareGrossPrice monetization variable captured in your DataCapture policy.

API syntax:sum(x_apigee_mintng_price)

Api price multiplierx_apigee_mintng_price_multipliersum, avg, min, max

The factor (multiplier) by which the per-transaction cost is multiplied. The per-transaction cost is specified in the rate plan'sConsumption-based fees pricing.

API syntax:avg(x_apigee_mintng_price_multiplier)

Monetization ratesx_apigee_mintng_ratesum, avg, min, max

Rate charged for a transaction. The rate charged for a transaction is calculated using the following formula:

x_apigee_mintng_rate = (consumption-based pricing rate) * perUnitPriceMultiplier value

The value of the consumption-based pricing rate is fetched from your rate plan and theperUnitPriceMultiplier value is multiplied only if the variable is captured by the DataCapture policy.

API syntax:sum(x_apigee_mintng_rate)

Dimensions

Dimensions let you view metrics in meaningful groupings. For example, seeing total traffic counts becomes much more powerful when you view them for each developer app or API proxy.

Following are the dimensions Apigee provides out of the box.

DimensionName to use in the Apigee APIDescription
Access Tokenaccess_tokenApp end user's OAuth access token.
API Productapi_product
  • Name of the API product containing the API proxies being called. In order to get this dimension, developer apps making the calls must be associated with one or more API products that contain the API proxies, and the proxies being called must check for an API key or OAuth token sent with the API call. The key or token is associated with an API product. For more information, seeHow do I generate complete analytics data?.

    If the above criteria aren't met, you'll see the value(not set). See alsoWhat does an analytics entity value "(not set)" mean?.

  • In the context of the fees metric, it contains the API product corresponding to the rate plan. The value is empty for some fee types, such as prepaid topup.

AppGroup App Nameapp_group_appName of the app being called when it is part of an AppGroup. SeeUsing AppGroups to organize app ownership for information on AppGroups.
AppGroup Nameapp_group_nameName of the AppGroup containing the apps being called, if applicable. SeeUsing AppGroups to organize app ownership for information on AppGroups.
Cache Keyax_cache_key

Key containing theResponseCache value that was accessed. For more information on how the key is constructed for response cache, seeResponseCache policy.

In theDebug tool, when you select aResponseCache policy that reads from or writes to the cache, you can see this value in theresponsecache.cachekeyflow variable.

Cache Nameax_cache_name

Name of the cache containing the keys/values used by theResponseCache policy, prefixed withorgName__envName__. For example, if the org ismyorgf, the environment istest, and the cache name ismyCache theax_cache_name isfoo__test__myCache.

In theDebug tool, when you select aResponseCache policy, you can see this value in theresponsecache.cachenameflow variable.

Cache Sourceax_cache_source

Cache level (L1 in-memory or L2 database) from which theResponseCache was retrieved. This dimension also showsCACHE_MISS when the response was delivered from the target instead of cache (and response cache was refreshed with the target response); or when a cache key in the request is invalid. Cache keys are limited to 2 KB in size.

In theDebug tool, when you select theResponseCache policy, you can see this value in theresponsecache.cachesourceflow variable.

For more information on cache levels, seeCache internals.

Client IDclient_id

Consumer key (API key) of the developer app making the API calls, whether passed in the request as API keys or included in OAuth tokens.

In order to get this dimension, proxies receiving calls must be configured to check for a valid API key or OAuth token. Developer apps get API keys, which can be used to generate OAuth tokens, when the apps are registered in Apigee. For more information, seeHow do I generate complete analytics data?.

If the above criteria aren't met, you'll see the value(not set). See alsoWhat does an analytics entity value "(not set)" mean?.

Developer Appdeveloper_app

Apigee-registered developer app making API calls.

In order to get this dimension, apps must be associated with one or more API products that contain the API proxies being called, and the proxies must check for an API key or OAuth token sent with the API call. The key or token identifies the developer app. For more information, seeHow do I generate complete analytics data?.

If the above criteria aren't met, you'll see the value(not set). See alsoWhat does an analytics entity value "(not set)" mean?.

Developer Emaildeveloper_email
  • Email of the Apigee-registered developers whose app made the API calls. This field is not set for AppGroup apps.

    In order to get this dimension, developers or AppGroups must have apps associated with one or more API products that contain the API proxies being called, and the proxies must check for an API key or OAuth token sent with the API call. The key or token identifies the developer app. For more information, seeHow do I generate complete analytics data?.

    If the above criteria aren't met, you'll see the value(not set). See alsoWhat does an analytics entity value "(not set)" mean?.

  • In the context of the fees metric, it contains the developer to whom the fee is charged.
Developer IDdeveloper

Unique Apigee-generated developer ID in the formorg_name@@@unique_id. For AppGroups, theunique_id is the AppGroup name.

In order to get this dimension, developers must have apps associated with one or more API products containing the API proxies being called, and the proxies must check for an API key or OAuth token sent with the API calls. The key or token identifies the developer. For more information, seeHow do I generate complete analytics data?.

If the above criteria aren't met, you'll see the value(not set). See alsoWhat does an analytics entity value "(not set)" mean?.

EnvironmentenvironmentApigee environment in which the API proxies are deployed. For example,test orprod.
Fault Code on Errorax_edge_execution_fault_code

Thefault code of the error. For example:messaging.adaptors.http.flow.GatewayTimeout

Flow Name on Errorax_execution_fault
  _flow_name

Namedflow in an API proxy that raised an error. For example,PreFlow,PostFlow, or the name of a conditional flow you created.

Note that the full name to use in the Apigee API isax_execution_fault_flow_name, without a line break.

Where no errors occurred, you'll see the value(not set).

Flow Resourceflow_resourceApigee use only. SeeHow to use "Resource Flow" Dimension in Analytics if you're curious.
Flow State on Errorax_execution_fault
  _flow_state

Name of the API proxy flow states that raised errors, such asPROXY_REQ_FLOW orTARGET_RESP_FLOW.

Note that the full name to use in the Apigee API isax_execution_fault_flow_state, without a line break.

Gateway Flow IDgateway_flow_idAs API calls move through Apigee, each call gets its own gateway flow ID. Example: rrt329ea-12575-114653952-1. Gateway Flow ID is useful for distinguishing metrics in high-TPS situations where other dimensions such as organization, environment, and timestamp are identical across calls.
OrganizationorganizationApigee organization in which the API proxies are deployed.
Policy Name on Errorax_execution_fault
  _policy_name

Name of the policy that threw an error and caused the API call to fail.

Note that the full name to use in the Apigee API isax_execution_fault_policy_name, without a line break.

If a policy throws an error but the policy root attributecontinueOnError is set totrue, the API proxy flow continues without failure, and the policy failure isn't counted in this dimension.

ProxyapiproxyMachine name (not the display name) of an API proxy.
Proxy Base Pathproxy_basepath

BasePath configured on the API proxy ProxyEndpoint. Base path does not include the domain and port portion of the API proxy URL. For example, if an API proxy's base URL ishttps://apigeedocs-test.apigee.net/releasenotes/, the base path is/releasenotes.

The value is also stored in theproxy.basepathflow variable.

Proxy Deployment Typeproxy_deployment_type

TheAPI proxy type for deployed proxies. Specifying a proxy type limits results to that proxy type. Potential values areSTANDARD,EXTENSIBLE, or unset.

Proxy Path Suffixproxy_pathsuffix

Resource path added to the API proxy base path. For example, if an API proxy's base URL ishttps://apigeedocs-test.apigee.net/hello/, and a call is made tohttps://apigeedocs-test.apigee.net/hello/json, thepathsuffix is/json.

If nopathsuffix is used, the value is empty.

The value is also stored in theproxy.pathsuffixflow variable.

Proxy revisionapiproxy_revisionRevision number of the API proxy that handled API calls. This doesn't necessarily mean the latest revision of an API proxy. If an API proxy has 10 revisions, the 8th revision may currently be deployed. Also, an API may have multiple revisions deployed as long as the revisions have different Base Paths, as described inDeploying proxies.
Resolved Client IPax_resolved_client_ip

Originating client IP address. This is either derived using the default client ip address resolution or the algorithm configured inconfigured client IP resolution.

With the default behavior, the value of theax_resolved_client_ip dimension is calculated from the values in theax_true_client_ip and thex_forwarded_for_ip dimensions.

Note that when using routing products such as Akamai to capture the true IP addresses of clients, the client IP is passed to Apigee in the HTTP headerTrue-Client-IP, which is then used to set theax_true_client_ip dimension.

The value of theax_resolved_client_ip dimension is calculated as follows:

  1. Ifax_true_client_ip is not null and does not contain a local IP address, then setax_resolved_client_ip toax_true_client_ip.
  2. Else, setax_resolved_client_ip to the first non-local IP address inx_forwarded_for_ip.
  3. If bothax_true_client_ip andx_forwarded_for_ip contain only local IPs, then setax_resolved_client_ip to the last local IP inx_forwarded_for_ip.
  4. If bothax_true_client_ip andx_forwarded_for_ip are null, setax_resolved_client_ip to(not set).
  5. Ifax_true_client_ip is a local IP andx_forwarded_for_ip is null, setax_resolved_client_ip to(not set).
Response Status Coderesponse_status_codeHTTP response status code forwarded from Apigee to the client, such as200,404,503, and so on. In Apigee, the response status code from the target can be overwritten with policies such asAssignMessage policy andRaiseFault policy, which is why this dimension can differ fromTarget Response Code (target_response_code).
Virtual Hostvirtual_hostThe name of the virtual host the API call was made to. For more information, seeAbout environments and environment groups.
Inbound/Client
Client IP Addressclient_ipIP address of the system that hits the router, such as the original client (proxy_client_ip) or a load balancer. When there are multiple IPs in theX-Forwarded-For header, this is the last IP listed.
Device Categoryax_ua_device_categoryType of device from which the API call was made, such asTablet orSmartphone.
OS Familyax_ua_os_familyOperating system family of the device making the call, such asAndroid oriOS.
OS Versionax_ua_os_version

Operating system version of the device making the call.

It's useful to use this as a second drill-down dimension with OS Family (ax_ua_os_family) to see the versions of the operating systems.

Proxy Client IPproxy_client_ip

IP address of the calling client, stored in theproxy.client.ipflow variable. This is often theX-Forwarded-For address of the inbound call, which is the IP address Apigee received from the last external TCP handshake. This could be the calling client or a load balancer. When there are multiple IPs in theX-Forwarded-For header, this is the last IP listed.

Referred Client IPax_true_client_ip

When using routing products such as Akamai to capture the true IP addresses of clients, the client IPs are passed to Apigee in the HTTP headerTrue-Client-IP. This dimension captures those true client IPs from that header.

To determine the original client IP Address, accessed through theax_resolved_client_ip dimension, Apigee uses theax_true_client_ip and thex_forwarded_for_ip dimensions.

Request Pathrequest_path

Resource path (not including the domain) to the target service, excluding query parameters.

For example, the Apigee sample targethttp://mocktarget.apigee.net includes several resources, including/user, which returns a greeting. Regardless of how your API proxy callshttp://mocktarget.apigee.net/user, the request_path is/user.

Request URIrequest_uri

Resource path (not including the domain) to the target service, including query parameters.

For example, the Apigee sample targethttp://mocktarget.apigee.net includes several resources, including/user?user={name} resource and query parameter to return a custom greeting to the name provided. Regardless of how your API proxy callshttp://mocktarget.apigee.net/user?user=Dude, the request_uri is/user?user=Dude.

Request Verbrequest_verbHTTP request verb in the API requests, such as GET, POST, PUT, DELETE.
User Agentuseragent

Name of the user agent, or software agent, used to make the API call. Examples:

  • A Pixel XL making a call through Chrome:Mozilla/5.0 (Linux; Android 7.1.2; Pixel XL Build/NHG47N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.92 Mobile Safari/537.36
  • An iPad making a call through Chrome:Mozilla/5.0 (iPad; CPU OS 10_2 like Mac OS X) AppleWebKit/602.1.50 (KHTML, like Gecko) CriOS/54.0.2840.91 Mobile/14C92 Safari/602.1
  • cURL from a terminal:curl/7.51.0
User Agent Familyax_ua_agent_familyFamily of the useragent, such asChrome Mobile orcurl.
User Agent Typeax_ua_agent_typeThe useragent type, such asBrowser,Mobile Browser,Library, and so on.
User Agent Versionax_ua_agent_version

Version of the useragent.

It's useful to use this as a second drill-down dimension with User Agent Family (ax_ua_agent_family) to get the version of the agent family.

Outbound/Target
TargettargetTarget endpoint that handled the request. For example,default.
Target Base Pathtarget_basepath

Resource path (not including the domain) to the target service, excluding query parameters, that is defined in the proxy's<TargetEndpoint>.

For example, say an API proxy calls the following target:

<TargetEndpoint name="default">...<HTTPTargetConnection>  <URL>http://mocktarget.apigee.net/user?user=Dude</URL></HTTPTargetConnection>

In this example, the target_basepath is/user.

If the target were this:

<TargetEndpoint name="default">...<HTTPTargetConnection>  <URL>http://mocktarget.apigee.net</URL></HTTPTargetConnection>

the target_basepath would be null.

In theDebug tool, when you select the AX icon at the end of the flow diagram, thetarget.basepathflow variable maps to the target_basepath dimension.

gRPC Service Namex_apigee_grpc_service_nameApplicable only when the target service is gRPC. The gRPC service name. For information on gRPC proxies, seeCreating gRPC API proxies.
gRPC Statusx_apigee_grpc_statusApplicable only when the target service is gRPC. The gRPC request status. For information on gRPC proxies, seeCreating gRPC API proxies.
Target Hosttarget_hostHost of the target service. For example, if an API proxy callshttp://mocktarget.apigee.net/help, the target_host ismocktarget.apigee.net.
Target IP Addresstarget_ipIP address of the target service returning the response to the API proxy.
Target Response Codetarget_response_code

HTTP response status code returned by the target service to the API proxy, such as200,404,503, and so on.

A value ofnull means the request never reached the target service. This occurs when the response is served by theResponseCache policy or when there's a failure in request processing.

This is different from theResponse Status Code (response_status_code) dimension.

gRPC RPC Namex_apigee_grpc_rpc_nameApplicable only when the target service is gRPC. The RPC name. For information on gRPC proxies, seeCreating gRPC API proxies.
Target URLtarget_url

Full URL of the target service defined in an API proxy's TargetEndpoint.

<TargetEndpoint name="default">...<HTTPTargetConnection>  <URL>http://mocktarget.apigee.net/user?user=Dude</URL></HTTPTargetConnection>

In this example, the target_url ishttp://mocktarget.apigee.net/user?user=Dude.

Note that the URL can also be overridden during API proxy processing with thetarget.urlflow variable.

Inproxy chaining, the target_url in the calling proxy is null.

X-Forwarded-For IPx_forwarded_for_ip

The list of IP addresses in theX-Forwarded-For header.

To determine the original client IP Address, accessed through theax_resolved_client_ip dimension, Apigee uses theax_true_client_ip and thex_forwarded_for_ip dimensions.

X-Forwarded-For Protox_forwarded_proto

Protocol that the client used to connect to the router. Valid values includehttp orhttps.

Time
Day of weekax_day_of_weekThree-letter day of the week abbreviation on which the API calls were made. For example, Mon, Tue, Wed.
Monthax_month_of_yearThe numeric month in which the API calls were made. For example,03 for March.
Time of Dayax_hour_of_day

Based on a 24-hour clock, the 2-digit hour in which API calls were made. For example, API calls made in the hour between 10pm and 11pm, the ax_hour_of_day would be 22.

The time value is in UTC.

Time Zoneax_geo_timezoneCommon names of the time zones the API calls were made from, such asAmerica/New_York andEurope/Dublin.
Week of Monthax_week_of_monthNumeric week of the month. For example, for API calls made in the 3rd week of a month, theax_week_of_month is 3.
Location
Cityax_geo_cityCity from which the API calls were made.
Continentax_geo_continentTwo-letter code of the continent from which the API calls were made. For example,NA for North America.
Countryax_geo_countryTwo-letter code of the country from which the API calls were made. For example,US for United States.
Geographical Regionax_geo_regionHyphenated code for the geographic region, such asSTATE-COUNTRY. For example,WA-US for Washington-United States.
Regionax_dn_regionName of the Apigee data center where API proxies are deployed, such asus-east-1.
Monetization
Fee Typefees_typeType of fee: setup fee, recurring fee, prepaid topup, or refund. This value is populated only if you have selected theFees metric.
Fee Time Createdcreated

Unix Timestamp when the fee was added for the app developer and API product. This value is populated only if you have selected theFees metric.

Revenue Currencyx_apigee_mintng_currency
  • Currency of the transaction revenue is set to the value of thecurrency monetization variable captured in your DataCapture policy. This currency is associated with the currency ofrevShareGrossPrice.
  • In the context of the fees metric, it contains the currency of the fee.
Rate Plan IDx_apigee_mintng_rate_plan_id

The monetization rate plan for the app developer.

Transaction Successx_apigee_mintng_tx_successMonetization status of the transaction is set to the value of thetransactionSuccess monetization variable captured in your DataCapture policy.
Period Startperiod_start

Start of the period for which recurring fees are charged. For example, for a monthly fee this is the first day of the month. This value is populated only if you have selected theFees metric.

Period Endperiod_end

End of the period for which recurring fees are charged. For example, for a monthly fee this is the last day of the month. This value is populated only if you have selected theFees metric.

Filters

Filters let you limit results to metrics with specific characteristics. Following are some sample filters. Use metric and dimension API-style names when defining filters.

Note: You must put filter text between single quotes, for example,'books'. Donot use double quotes.

Returns metrics for API proxies with the name books or music:

filter=(apiproxy in 'books','music')

Returns metrics for API proxies with names that start withm:

filter=(apiproxy like 'm%')

Returns metrics for API proxies with names that do not start withm:

filter=(apiproxy not like 'm%')

Returns metrics for API calls with response status codes between400 and599:

filter=(response_status_code ge 400 and response_status_code le 599)

Returns metrics for API calls with response status code of200 and a target response code of404:

filter=(response_status_code eq 200 and target_response_code eq 404)

Returns metrics for API calls with a response status code of500:

filter=(response_status_code eq 500)

Returns metrics for API calls that didn't result in errors:

filter=(is_error eq 0)

Returns metrics for API calls that didn't result innull responses:

filter=(response_status_code isnot null)

Following are operators you can use to build report filters.

OperatorDescription
inInclude in list
notinExclude from list
isUseresponse_status_code is null to filter for responses whose status code isnull.
isnotUseresponse_status_code isnot null to filter for responses whose status code is notnull.
eqEquals,==
neNot equal to,!=
gtGreater than,>
ltLess than,<
geGreater than or equal to,>=
leLess than or equal to,<=
likeReturns true if the string pattern matches the supplied pattern.
not likeReturns false if the string pattern matches the supplied pattern.
similar toReturns true or false depending on whether its pattern matches the given string. It is similar tolike except that it interprets the pattern using the SQL standard's definition of a regular expression.
not similar toReturns false or true depending on whether its pattern matches the given string. It is similar tonot like, except that it interprets the pattern using the SQL standard's definition of a regular expression.
andLets you useAND logic to include more than one filter expression. The filter includes data that meets all the conditions.
orLets you useOR logic to evaluate different possible filter expressions. The filter includes data that meets at least one of the conditions.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-17 UTC.