checking both updated_at and created_at filter with OR condition for product collectionLimit 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
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;
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
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
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
edited May 31 at 9:05
Muhammad Wasif
15311
asked May 31 at 8:28
Stack userStack user
1628
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
magento-1.9 products product-collection resource-model
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
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
edited May 31 at 9:05
Muhammad Wasif
15311
15311
asked May 31 at 8:28
Stack userStack user
1628
asked May 31 at 8:28
Stack userStack user
1628
asked May 31 at 8:28
Stack userStack user
1628
1628
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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();
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
);
);
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
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
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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();
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();
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();
answered May 31 at 8:41
Rk RathodRk Rathod
2,210315
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();
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
answered May 31 at 8:41
Rk RathodRk Rathod
2,210315
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 |
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
but I also want updated_at in filter with OR condition.
– Stack user
May 31 at 10:06
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
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
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 |
Thanks for contributing an answer to Magento Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
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
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
