WordPress自定义字段-表字段-按表行值查询帖子

我想用custom fields在wordpress中创建一个表。看起来像这样:

+---------------------------------------------+
|  company  |          |          |           |
|           |  field1  |  field2  |   Field3  | 
|           |          |          |           | 
+----+-----------+----------+----------+------+
| 56        | 5        | 55       |  58       | 
+----+-----------+----------+-- -------+------+
| 888       | 6        | 88       |  55       | 
+----+-----------+----------+-- -------+------+
| 558       | 88       |  2       |  150      |
+----+-----------+----------+----------+------+

我需要创建一个过滤器以加载以下职位列表:

"company" == 888
"field1" <= 100 &&
"field2" >= 20 &&
"field3" >= 40

例如,在这种情况下,具有此值的帖子(例如表格)将在此列表中提及。 表格中可以有无限数量或行。

如果tere只是一个具有一个值的字段,我会做类似的事情:

$args = array(
    'numberposts' => -1,'post_type' => 'company','meta_query' => array(
        array(
            'key' => $key_name,'value' => 0,'compare' => '>'
        )
    )
);

我找不到这样查询表中数据的方法吗? 在那儿?非常感谢您的帮助。

编辑:

是我创建的服装领域。我做了一个中继器。 重要的事情:我需要找到在同一行(所有行)都满足所有条件的公司。

[
    {
        "key": "group_5dcbf625e861c","title": "Product search params (copy)","fields": [
            {
                "key": "field_5dcbf62629ce7","label": "product search by param active","name": "product_search_by_param_active","type": "true_false","instructions": "Please choose true to activate this option","required": 1,"conditional_logic": 0,"wrapper": {
                    "width": "","class": "","id": ""
                },"message": "If not checked,search engine won't show this section on website","default_value": 0,"ui": 0,"ui_on_text": "","ui_off_text": ""
            },{
                "key": "field_5dcbf6262a106","label": "product params values","name": "product_params_values","type": "repeater","instructions": "","required": 0,"conditional_logic": [
                    [
                        {
                            "field": "field_5dcbf62629ce7","operator": "==","value": "1"
                        }
                    ]
                ],"collapsed": "","min": 0,"max": 0,"layout": "table","button_label": "","sub_fields": [
                    {
                        "key": "field_5dcbf626543aa","label": "param value 1","name": "param_value_1","type": "text","wrapper": {
                            "width": "","id": ""
                        },"default_value": "","placeholder": "","prepend": "","append": "","maxlength": ""
                    },{
                        "key": "field_5dcbf6265478f","label": "param value 2","name": "param_value_2",{
                        "key": "field_5dcbf62654c14","label": "param value 3","name": "param_value_3",{
                        "key": "field_5dcbf62654fc1","label": "param value 4","name": "param_value_4",{
                        "key": "field_5dcbf62655398","label": "param value 5","name": "param_value_5","maxlength": ""
                    }
                ]
            }
        ],"location": [
            [
                {
                    "param": "post_type","value": "product"
                }
            ]
        ],"menu_order": 0,"position": "normal","style": "default","label_placement": "top","instruction_placement": "label","hide_on_screen": "","active": 1,"description": ""
    }
]

编辑2:

还有另一种方式。创建表字段。这是字段:

    {
        "key": "field_5dcdf5a673fa7","label": "product search by param settings","name": "product_search_by_param_settings","type": "table","wrapper": {
            "width": "","id": ""
        },"use_header": 0,"use_caption": 2
    }

这就是保存方式:

a:5:{s:5:"acftf";a:1:{s:1:"v";s:5:"1.3.9";}s:1:"p";a:2:{s:1:"o";a:1:{s:2:"uh";i:0;}s:2:"ca";s:0:"";}s:1:"c";a:5:{i:0;a:1:{s:1:"p";s:0:"";}i:1;a:1:{s:1:"p";s:0:"";}i:2;a:1:{s:1:"p";s:0:"";}i:3;a:1:{s:1:"p";s:0:"";}i:4;a:1:{s:1:"p";s:0:"";}}s:1:"h";a:5:{i:0;a:1:{s:1:"c";s:0:"";}i:1;a:1:{s:1:"c";s:0:"";}i:2;a:1:{s:1:"c";s:0:"";}i:3;a:1:{s:1:"c";s:0:"";}i:4;a:1:{s:1:"c";s:0:"";}}s:1:"b";a:5:{i:0;a:5:{i:0;a:1:{s:1:"c";s:4:"ffsd";}i:1;a:1:{s:1:"c";s:5:"hjkhk";}i:2;a:1:{s:1:"c";s:4:"hkjh";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:4:"fdjk";}}i:1;a:5:{i:0;a:1:{s:1:"c";s:6:"hkjhjk";}i:1;a:1:{s:1:"c";s:5:"hkjhk";}i:2;a:1:{s:1:"c";s:6:"hkjhkj";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:4:"hkhk";}}i:2;a:5:{i:0;a:1:{s:1:"c";s:6:"hkhkjh";}i:1;a:1:{s:1:"c";s:5:"hkjhk";}i:2;a:1:{s:1:"c";s:5:"hkjhk";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:5:"hkjhk";}}i:3;a:5:{i:0;a:1:{s:1:"c";s:5:"hkjhk";}i:1;a:1:{s:1:"c";s:6:"hkjhkj";}i:2;a:1:{s:1:"c";s:6:"hkjhkj";}i:3;a:1:{s:1:"c";s:6:"hkjhkj";}i:4;a:1:{s:1:"c";s:5:"hkkhk";}}i:4;a:5:{i:0;a:1:{s:1:"c";s:4:"hkhk";}i:1;a:1:{s:1:"c";s:2:"hk";}i:2;a:1:{s:1:"c";s:4:"hkhk";}i:3;a:1:{s:1:"c";s:4:"hkhk";}i:4;a:1:{s:1:"c";s:4:"hkhk";}}}}
mfj111071 回答:WordPress自定义字段-表字段-按表行值查询帖子

元查询可以采用一系列条件。您可以尝试以下方法:

$args = array(
  'numberposts' => -1,'post_type' => 'company','meta_query' => array(
   'relation' => 'AND',// AND is default,you can use OR as well
    array(
      'key' => 'company','value' => 888,'compare' => '='
    ),array(
      'key' => 'field1','value' => 100,'compare' => '<=','type'    => 'NUMERIC' // You can add a type here as well
    ),array(
      'key' => 'field2','value' => 20,'compare' => '>=','type'    => 'NUMERIC'
    ),array(
      'key' => 'field3','value' => 40,'type'    => 'NUMERIC'
    )
  )
);

以下是帮助深入了解meta_query的链接:https://rudrastyh.com/wordpress/meta_query.html

此外,这是一个元查询生成器,可帮助完成该过程: https://generatewp.com/wp_meta_query/

本文链接:https://www.f2er.com/3144467.html

大家都在问