首页 \ 问答 \ query builder：包含复合列的IN子句(query builder: IN clause with composite columns)

query builder：包含复合列的IN子句(query builder: IN clause with composite columns)

 我需要在多个列上创建一个IN条件，就像这样  
...
WHERE 
(order_date, order_number) IN (
    ('2016-03-11', 3455453), 
    ('2016-03-18', 83545454), 
    ('2016-06-17', 5354544)
)
 
 从这样的数组开始：  
$orders = [
    ['2016-03-11', 3455453], 
    ['2016-03-18', 83545454], 
    ['2016-06-17', 5354544]
];
 
 使用cake3查询生成器。 我试过了  
->where(['(order_date, order_number) IN' => $orders]);
 
 但是我收到一个错误：  
 
  无法将值转换为字符串  
 
 我知道手动创建操作数组的查询并不难，但我想知道是否有一种方法可以做到这一点。 

I need to create a IN conditions on multiple columns, like this 
...
WHERE 
(order_date, order_number) IN (
    ('2016-03-11', 3455453), 
    ('2016-03-18', 83545454), 
    ('2016-06-17', 5354544)
)
 
starting from an array like this: 
$orders = [
    ['2016-03-11', 3455453], 
    ['2016-03-18', 83545454], 
    ['2016-06-17', 5354544]
];
 
using cake3 query builder. I tried with 
->where(['(order_date, order_number) IN' => $orders]);
 
but I get an error:  
 
 Cannot convert value to string  
 
I know it's not hard to manually create the query manipulating the array, but I'd like to know if there is a cake way to do it.

原文：https://stackoverflow.com/questions/37919141

更新时间：2023-12-30 11:12

最满意答案

 范式发生了很大变化。 在OpenLayers 3中，您创建一个具有簇样式的新图层，并将“阈值”设置为图层选项中的maxResolution或minResolution。 如同：  
var clusterLayer = new ol.layer.Vector({
                visible: true,
                zIndex: insightMap.totalServcies - element.SortOrder,
                id: Id,                                           
                serviceId: element.Id,
                minResolution: clusteringThreshold,
                cluster: true,
            });
 
 您也可以根据文档使用minZoom和maxZoom，但我遇到了一致性问题。 

The paradigm has changed considerably. In OpenLayers 3 you create a new layer, with a cluster style, and the "threshold" is set as a maxResolution, or minResolution in the layer's options. Similar to: 
var clusterLayer = new ol.layer.Vector({
                visible: true,
                zIndex: insightMap.totalServcies - element.SortOrder,
                id: Id,                                           
                serviceId: element.Id,
                minResolution: clusteringThreshold,
                cluster: true,
            });
 
You can also use minZoom and maxZoom according to the documentaiton, but I've encountered issues with them performing consistently.

query builder：包含复合列的IN子句(query builder: IN clause with composite columns)

最满意答案

相关问答

OpenLayers使用BBOX策略找出用户的缩放级别(OpenLayers finding out a user's zoom level with the BBOX strategy)[2022-04-03]

OpenLayers功能数组为空(OpenLayers features array is empty)[2022-10-01]

WKT和openlayers(WKT and openlayers)[2023-07-11]

烧瓶和OpenLayers(Flask and OpenLayers)[2022-06-09]

OpenLayers 2.13：集群策略不起作用(OpenLayers 2.13: clustering strategy is not working)[2022-06-17]

Openlayers 3.5和GeoJSON(Openlayers 3.5 and GeoJSON)[2022-12-06]

OpenLayers 2，GeoJSON无法获得坐标工作(OpenLayers 2, GeoJSON cant get coordinates to work)[2023-12-30]

要求Openlayers指南满足我的要求(Require Openlayers guide for my requirement)[2022-01-18]

openlayers 3中集群策略的阈值在哪里？(Where is threshold for cluster strategy in openlayers 3?)[2024-03-01]

Openlayers：从WFS层搜索(Openlayers: search from WFS layer)[2023-02-17]

相关文章

最新问答