Vaibhav, Instead of trying to fetch product on field value, go for creating categories for your need and make product members of them. For example you may create categories 0-100, 101-200, 201-300 of type OTHER_SEARCH type as many as you want. Finally associate the products with desired categories. After that you fetching would be easy at code level.
It will take time to setup but data fetching would be easy and configurable easily (may be you can use some triggers to associate) -- Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Tue, Aug 21, 2018 at 2:42 PM Vaibhav Jain <[email protected]> wrote: > Hello all, > > *Business case:* > Goods and Service Tax is India allow to apply different tax rates on > the same product/product category on the basis of product > price(transactional value). > > *Problem: In fetching data for a specific price range* > > - In OFBiz the *TaxAuthorityRateProduct* entity is used to define the > tax rates for any product category. > - *TaxAuthorityRateProduct*.*minItemPrice* can be used to manage > different tax rates on the basis of the product price but it is > difficult > to fetch the data on the basis of a specific price range using single > column(minItemPrice) > > > Vaibhav Jain > Sr. Enterprise Software Engineer > HotWax Systems > m: 782-834-1900 e: [email protected] >
