• Home
  • Pricing
  • Free Resources
  • About
  • Docs
  • Support
  • Account

Gravity Wiz

Magically enhanced tutorials, snippets and plugins for Gravity Forms!

  • Gravity Perks
    • Gravity Perks
    • Pricing
  • Blog
    • Free Resources
    • About
  • Support
    • Docs
    • Support
    • Account

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

  • GF Address Autocomplete
  • GF Advanced Calculations
  • GF Advanced Phone Field
  • GF Advanced Save & Continue
  • GF Auto List Field
  • GF Auto Login
  • GF Better User Activation
  • GF Blocklist
  • GF Conditional Logic Dates
  • GF Conditional Pricing
  • GF Copy Cat
  • GF Date Time Calculator
  • GF Disable Entry Creation
  • GF Easy Passthrough
  • GF eCommerce Fields
  • GF Email Users
  • GF Entry Blocks
  • GF Expand Textareas
  • GF File Renamer
  • GF File Upload Pro
  • GF Google Sheets
  • GF Inventory
  • GF Limit Checkboxes
  • GF Limit Choices
  • GF Limit Dates
  • GF Limit Submissions
  • GF Live Preview
  • GF Media Library
  • GF Multi-Page Navigation
  • GF Nested Forms
  • GF Notification Scheduler
  • GF Page Transitions
  • GF Pay Per Word
  • GF PayPal One-time Fee
  • GF Placeholder
  • GF Populate Anything
  • GF Post Content Merge Tags
  • GF Preview Submission
  • GF Price Range
  • GF QR Code
  • GF Randomizer
  • GF Read Only
  • GF Reload Form
  • GF Terms Of Service
  • GF Unique ID
  • GF Word Count

Copyright © 2023 · Powered by WordPress · Gravity Wiz LLC

  • Support
  • Affiliates
  • About
  • Sitemap
  • Terms & Conditions of Use
  • Privacy Policy
  • Cookies Policy