Saved search formula to fetch the record data that were created or edited within the last 24 hours. Based on the updates that appeared in the “System notes,” the data for this saved search is fetched. provide these criteria in the ‘Formula text‘ CASE WHEN ({systemnotes.date}>= {today}-1 ) THEN ‘SYS_NOTE’ WHEN ({datecreated}>= {today}-1 ) THEN… Continue reading Search Criteria – To get the data that were edited or created within 24 hours
Tag: Search Criteria
Magento REST API Search Criteria
Search criterias can be added to GET request API to get required data from magento. The basic pattern for specifying the criteria is: searchCriteria[filter_groups][][filters][][field]=<field_name> searchCriteria[filter_groups][][filters][][value]=<search_value> searchCriteria[filter_groups][][filters][][condition_type]=<operator> where: field is an attribute name. value specifies the value to search for. condition_type is one of the following values: CONDITION NOTES eq Equal finset A value within a… Continue reading Magento REST API Search Criteria