Blog

I want filter SQL database data by time interval (1 sec, 1Min, 10 Min,1Hour, 2Hour) I want to fetch data from “ProDataTable” by in between Start Date and End Date with Interval of (1 Sec, 1Min, 10 Min, 1 Hour , 2 hour) for Fetching data from Database i am using following query. Select *Read more

Is anyway to set the filter by product created date in the front-end ? I cannot see created date in product attribute in the admin page. What should I do ?Read more

In Default Magento order grid filter displayed all payment method instead of enabled payment method..Read more

I want filter information from a .xml file, the general xml rule is XMLElement[“div”, {“class” -> “art_title linkable”}, {XMLElement[“a”, {“shape” -> “rect”, “class” -> “ref nowrap”, “href” -> “XXXX”}, {“name”}]}] so I use the following code, it will word good, Cases[data, XMLElement[ “div”, {“class” -> “art_title linkable”}, {XMLElement[ “a”, {___}, {papername_}]}] :> {papername}, {0, Infinity}];Read more

I’ve got a D7 site running Commerce. On a product type called Releases I have an entity reference field for a content type called Tracks. In my Product Display I’ve got a Viewfield that renders a view called Tracklist I want the Tracklist-view to display the tracks referenced by the products that the product displayRead more

I am using Query String (URL) Filter Web Part for filtering items in list view. I followed offical guide where they are using multiple parameters for filters: Status=Elite&Status=Preferred In my case, it is filtering only by the first parameter and it is skipping the second one. Under “Advanced Filter Options” option “Send all values” isRead more

I was wondering if there’s a way to add exposed filters (taxonomy terms) to EFQ. I’m using Drupal 7. I have a page listing several stores alongside their brands and categories. Am using EFQ to get that stores list. I want to add a filtering block containing the brands and categories. There may be aRead more

We have the following category tree: Default Category | Shop categories | Sub category 1 | Sub category 2 | Sub category 3 | Sale Corner | Another category So it’s like 1 Default Category, 3 Sub categories, and the Shop Categories (which is basically a sub category) has around 20 Sub Sub categories. WhenRead more

I’m experiencing a strange issue here where the price navigation filter (layered navigation) somehow came up with negative price ranges. If I flush the price tables it seems to solve the problem, until next time prices get re-indexed. Then the negative price ranges re-appear. Another issue is that the price ranges are not even accurate.Read more

I am working in a project in android, this app needs to receives a sms from a specifict phone number to launch another app. I already attained to get the message tray, but I do not know how use a filter to be able to get the sms from that specifict phone number in orderRead more