Ttdfjt

How to handle self harm scars on the arm in work environment?

Implement Own Vector Class in C++

Why didn't Voldemort recognize that Dumbledore was affected by his curse?

Wooden cooking layout

How can this tool find out registered domains from an IP?

Teaching a class likely meant to inflate the GPA of student athletes

Overlapping String-Blocks

How is water heavier than petrol, even though its molecular weight is less than petrol?

Mathematically, why does mass matrix / load vector lumping work?

How to hide rifle during medieval town entrance inspection?

Does a scale have more than seven chords?

CROSS APPLY produces outer join

Is an entry level DSLR going to shoot nice portrait pictures?

When would it be advantageous not apply Training Ground's cost reduction?

Union with anonymous struct with flexible array member

A IP can traceroute to it, but can not ping

Thread Pool C++ Implementation

Is it possible to have a wealthy country without a middle class?

Arriving at the same result with the opposite hypotheses

Did Milano or Benatar approve or comment on their namesake MCU ships?

What makes Ada the language of choice for the ISS's safety-critical systems?

Has there been a multiethnic Star Trek character?

Winning Strategy for the Magician and his Apprentice

Is this use of the expression "long past" correct?

checking both updated_at and created_at filter with OR condition for product collection

Limit Product collectionHow to add a condition in sort order?Filter Product Collection by BOTH multiple catgeoriesHow to add filter option in product details page?Magento - “created_at” field does not set automatically with the rest of the datamagento 1.9.2 - apply layer filter to custom product collectionHow to filter product collection by matching string like search in Magento 2?Magento2 - Filter out Configurable Products with out of stock child products from product collectionHow to filter product collection by custom text attributeFilter product collection with source

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

Hello Please help me to updated this query to apply updated_at filter too with OR condition.

Here If I want to add 'updated_at' too in the filter with the same condition like 'created_at' then what should I do in below query:

 $products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => strtotime('-2 days', time()),
 'to' => time(),
 'datetime' => true
 ))->load();

Please help

magento-1.9 products product-collection resource-model

share|improve this question

edited May 31 at 9:05

Muhammad Wasif

15311

asked May 31 at 8:28

Stack userStack user

1628

add a comment | 

0

Hello Please help me to updated this query to apply updated_at filter too with OR condition.

Here If I want to add 'updated_at' too in the filter with the same condition like 'created_at' then what should I do in below query:

 $products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => strtotime('-2 days', time()),
 'to' => time(),
 'datetime' => true
 ))->load();

Please help

magento-1.9 products product-collection resource-model

share|improve this question

edited May 31 at 9:05

Muhammad Wasif

15311

asked May 31 at 8:28

Stack userStack user

1628

add a comment | 

Hello Please help me to updated this query to apply updated_at filter too with OR condition.

Here If I want to add 'updated_at' too in the filter with the same condition like 'created_at' then what should I do in below query:

 $products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => strtotime('-2 days', time()),
 'to' => time(),
 'datetime' => true
 ))->load();

Please help

magento-1.9 products product-collection resource-model

share|improve this question

edited May 31 at 9:05

Muhammad Wasif

15311

asked May 31 at 8:28

Stack userStack user

1628

 $products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => strtotime('-2 days', time()),
 'to' => time(),
 'datetime' => true
 ))->load();

share|improve this question

edited May 31 at 9:05

Muhammad Wasif

15311

asked May 31 at 8:28

Stack userStack user

1628

share|improve this question

edited May 31 at 9:05

Muhammad Wasif

15311

asked May 31 at 8:28

Stack userStack user

1628

edited May 31 at 9:05

Muhammad Wasif

15311

edited May 31 at 9:05

Muhammad Wasif

15311

asked May 31 at 8:28

Stack userStack user

1628

asked May 31 at 8:28

Stack userStack user

1628

1 Answer
1

active

oldest

votes

0

Try This :-

$fromDate = date('Y-m-d H:i:s', strtotime('-2 days', time());
$toDate = date('Y-m-d H:i:s', strtotime(now()));
$products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => $fromDate,
 'to' => $toDate,
 'datetime' => true,
 ))->load();

share|improve this answer

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  but I also want updated_at in filter with OR condition.
  
  – Stack user
  May 31 at 10:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please explain briefly which you want ??
  
  – Rk Rathod
  May 31 at 10:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I want to get all products which are either created or updated from last two days.
  
  – Stack user
  May 31 at 10:17
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f276833%2fchecking-both-updated-at-and-created-at-filter-with-or-condition-for-product-col%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Try This :-

$fromDate = date('Y-m-d H:i:s', strtotime('-2 days', time());
$toDate = date('Y-m-d H:i:s', strtotime(now()));
$products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => $fromDate,
 'to' => $toDate,
 'datetime' => true,
 ))->load();

share|improve this answer

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  but I also want updated_at in filter with OR condition.
  
  – Stack user
  May 31 at 10:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please explain briefly which you want ??
  
  – Rk Rathod
  May 31 at 10:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I want to get all products which are either created or updated from last two days.
  
  – Stack user
  May 31 at 10:17
  

  
  
  
  

add a comment | 

0

Try This :-

$fromDate = date('Y-m-d H:i:s', strtotime('-2 days', time());
$toDate = date('Y-m-d H:i:s', strtotime(now()));
$products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => $fromDate,
 'to' => $toDate,
 'datetime' => true,
 ))->load();

share|improve this answer

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  but I also want updated_at in filter with OR condition.
  
  – Stack user
  May 31 at 10:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  please explain briefly which you want ??
  
  – Rk Rathod
  May 31 at 10:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I want to get all products which are either created or updated from last two days.
  
  – Stack user
  May 31 at 10:17
  

  
  
  
  

add a comment | 

Try This :-

$fromDate = date('Y-m-d H:i:s', strtotime('-2 days', time());
$toDate = date('Y-m-d H:i:s', strtotime(now()));
$products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => $fromDate,
 'to' => $toDate,
 'datetime' => true,
 ))->load();

share|improve this answer

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315

$fromDate = date('Y-m-d H:i:s', strtotime('-2 days', time());
$toDate = date('Y-m-d H:i:s', strtotime(now()));
$products = Mage::getResourceModel('catalog/product_collection')
 ->addAttributeToSelect('*')
 ->addFieldToFilter('created_at', array(
 'from' => $fromDate,
 'to' => $toDate,
 'datetime' => true,
 ))->load();

share|improve this answer

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315

answered May 31 at 8:41

Rk RathodRk Rathod

2,210315