Operator «is between» not works in module

Comments

joachim’s picture

Status: Active » Postponed (maintainer needs more info)

I can't find that string anywhere in the code.

Could you explain more what you mean?

Stan.Ezersky’s picture

I've got a «select #1» with options (Global: Dependent filter). If i choose option from «select #1» I must see «select #2». But i see «select #2» always

joachim’s picture

Sorry, still don'tget it.

could you post a screenshot, and also reproduce this with standard components and export the view?

Stan.Ezersky’s picture

StatusFileSize
new28.26 KB
new54.43 KB
new17.79 KB

Standard components work

joachim’s picture

  'field_realty_price' => array(
    'sortable' => 1,
    'default_sort_order' => 'asc',
    'align' => '',
    'separator' => '',
    'empty_column' => 0,
  ),

By 'standard components', I meant fields that are in Drupal OOTB, that I will have on my test install.
If you need to, you can create a feature with these fields and your view.

You also should be using standard field *types*. I don't recognize where that slider widget comes from.

Anonymous’s picture

Has this been resolved yet? This module does a great job with all Operators minus the "is between".

nikit’s picture

Version: 7.x-1.x-dev » 7.x-1.1
Status: Needs work » Postponed (maintainer needs more info)
StatusFileSize
new1.22 KB

Quick patch that solve this between filter element problem.

Sponsored by superdorx.com

joachim’s picture

Version: 7.x-1.1 » 7.x-1.x-dev
Status: Postponed (maintainer needs more info) » Needs work

Thanks for the patch!

Indentation and spacing needs a bit of tweaking though.

nikit’s picture

StatusFileSize
new1.22 KB

Sorry, forgot to renew settings after setup my development environment.
Refixed tabs to spaces:

Bacem’s picture

Thank you Nikit but i have another problem . even my between filter is hidden by the view exposed filter it generates me a query with a left join! I d'on't know why. do you have an idea how to resolve this issue?Thank you

nikit’s picture

Version: 7.x-1.1 » 7.x-1.x-dev
Status: Postponed (maintainer needs more info) » Needs work

2 Bacem: sorry, I don't understand what link between joins and this module issue. I assume it's issue for Views, not for this module.

Bacem’s picture

2 NIKI :of course there is a relation between the generated query and the module.

here is the generated query when my field_data_field_annee_modele is hidden(by the module)

SELECT node.created AS node_created, node.nid AS nid
FROM
{node} node
LEFT JOIN {field_data_field_annee_modele} field_data_field_annee_modele ON node.nid = field_data_field_annee_modele.entity_id AND (field_data_field_annee_modele.entity_type = 'node' AND field_data_field_annee_modele.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN ('classified')) AND (field_data_field_annee_modele.field_annee_modele_value BETWEEN '' AND '') ))
ORDER BY node_created DESC
LIMIT 12 OFFSET 0

field_data_field_annee_modele is hidden(that's ok for me after i applied your patch and thanks a lot for that) but in the query i have a left join . do you know how to resolve this problem ? thank you Niki

nikit’s picture

2 Bacem: Your issue is off-topic.
But I answer: left join used for joining content and it's field, because, some field of some node may be empty. In inner join case, you lost this node. Left join allow see all appropriate nodes (with empty fields of course). For showing only filled fields content, use views filters (empty/not empty/or comparing).
Programmatically you can use hhook_views_query_alter.

Bacem’s picture

2 Nikit: Thank you !! I will follow your advice. :-)

lukasss’s picture

Issue summary: View changes

#9 I do not work...please help

nikit’s picture

This is old time patch, I assume it should be renewed to current dev version.