Gravity Wiz Gravity Wiz
GF Populate Anything

gppa_object_type_col_rows_query

  1. Description
  2. Usage
  3. Parameters
  4. Examples
    1. Increase Post Meta Result Limit to 1500
  5. Since

Description

Filter the query used to pull property values into the dropdowns displayed under the GP Populate Anything field settings in the Form Editor.

Usage

add_filter( 'gppa_object_type_col_rows_query', 'my_custom_function', 10, 4 );

Parameters

  • sql string

    SQL query that will be ran to fetch the property values.

  • col string

    Column that property values are being fetched from.

  • table array

    Table that property values are being fetched from.

  • this \GPPA_Object_Type

    The current object type.

Examples

Increase Post Meta Result Limit to 1500

<?php
/**
 * Note: See https://gravitywiz.com/documentation/how-do-i-install-a-snippet/ for details on how to install snippets.
 */
add_filter( 'gppa_object_type_col_rows_query', function( $sql, $col, $table, $object_type ) {
	// Change this to the maximum number of post meta results
	$meta_limit = 1500;

	global $wpdb;
	if ( $wpdb->postmeta === $table ) {
		$sql = str_replace( '1000', $meta_limit, $sql );
	}
	return $sql;
}, 10, 4 );

Since

This filter is available since Gravity Forms Populate Anything 1.0-beta-1.9.

All Perks