FAQ Database Discussion Community


Excel Advanced Filter not working with Wildcard (* asterisk) using regular numbers and hyphenated number system

excel,filter,wildcard
I have set up an advanced filter in Excel. I can not get the advanced filter to produce any output when using wildcard asterisks (*), using a source list that contains numbers and hyphenated numbers, OR alternatively when using a separate list which is producing a number from a formula....

Filter rows in R using subset

r,filter,subset
I have 12 columns of data in a table called df, the first column contains several thousand strings such as AA150502-01,AA150502-02,BB150502-01,BB150502-03 etc. I want to filter the table so that i only see the rows ending with the suffix -01, how do i go about doing this? I so far...

UnderscoreJS : filter part of string

string,filter,find,underscore.js
I would like to filter data but without giving the whole string. For example, I have an Array with value:'myString', I would like to filter that even if i just pass 'my' or 'String'. Any idea ?...

Can the HTTP method “PATCH” be safely used across proxies etc.?

http,caching,filter,proxy,http-patch
Suppose my server exposes an HTTP-based API that uses the PATCH method introduced by RFC 5789. Is it possible that clients (browsers or otherwise) behind corporate firewalls, proxies, caches, parental controls filters and the like will encounter any problems using this method? If so, how likely is this? Given that...

Python pandas: exclude rows below a certain frequency count

python,pandas,filter,dataframes
So I have a pandas DataFrame that looks like this: r vals positions 1.2 1 1.8 2 2.3 1 1.8 1 2.1 3 2.0 3 1.9 1 ... ... I would like the filter out all rows by position that do not appear at least 20 times. I have seen...

Wordpress filter products by price using numeric comparison

php,wordpress,filter,filtering
With pre_get_posts I extend the query with filters. I'm now trying to make a custom price filter, because i can't use the original filter De code i'm using: $minprice = 0; $maxprice = 0; if ( isset( $_GET['min_price'] ) && $_GET['min_price'] > 0 ) $minprice = $_GET['min_price']; if ( isset(...

CKEditor allow all content except font-size, line-height, uppercase

filter,ckeditor
Is there a config option in CKEditor to allow all content except certain styles (font-size, line-height, uppercase,....). Is that possible? I checked ACF but I didn't see that option....

AngularJS search array of objects

javascript,arrays,angularjs,filter
I have an array of objects in my controller eg: $scope.fields = [ {fieldName:'houseNum',fieldLabel:'House Number',disabled:false}, {fieldName:'street',fieldLabel:'Street',disabled:false}, {fieldName:'city',fieldLabel:'City',disabled:true}, {fieldName:'state',fieldLabel:'State',disabled:true}, ] In the HTML I would like to be able to get a fieldLabel where fieldName=='street'. The AJS documentation presumes that every filter case should be in the context of ng-repeat -...

PHP filter hashtags from string and write result back to file

php,filter,fopen,fwrite,word
I'm using fopen() and fwrite() to write some JSON content to a file. My question: Is there a way to filter the content and write only specific words to that file? E.g.: I retrive "I #love #love #love you so #much my dear #brother!" from the JSON file and I...

Filter array of objects with another array of objects

javascript,jquery,arrays,object,filter
This question is similar to this one Jquery filter array of object with loop but this time I need to do the filter with an array of objects. Exemple: I have an array of objects like this: myArray = [ { userid: "100", projectid: "10", rowid: "0" }, { userid:...

Optimize performance of Removing Hidden Rows in VBA

performance,vba,loops,excel-vba,filter
I am using the following code to remove hidden/filtered lines after applying autofilters to a big sheet in VBA (big means roughly 30,000 rows): Sub RemoveHiddenRows() Dim oRow As Range, rng As Range Dim myRows As Range With Sheets("Sheet3") Set myRows = Intersect(.Range("A:A").EntireRow, .UsedRange) If myRows Is Nothing Then Exit...

How intercept response and modify response body with play framework 2.2.x? [closed]

java,filter,httpresponse,playframework-2.2,interceptor
I need to intercept request and response. I have already intercepted request. But I cant intercept response and get response body with java. I need to intercept response in play framework 2.2.x with java

ionic: I have a scope variable empty from a stringified json

json,angularjs,sqlite,filter,ionic
I'm trying to filter a JSON result from a SQLite query. The filter works when I use JSON directly, but it doesn't when I use the query from the service. Then, the $scope.arrayme just appears as empty. Where is the error? Thank you! This is the service: getSubtipos: function() {...

Filter results with ajax and modify URL

jquery,ajax,laravel,filter
I'm trying to build a filter feature for a website I am currently building in Laravel, that will enable the customer to filter a product down by it's attributes. At the moment, the URL to filter products is /filter?size=1,2,3&construction=102,204&brand=4,37. What I'd like to be able to do, is change the...

AngularJS filter based on an array of strings almost there

javascript,arrays,angularjs,filter
I am trying to create a custom angular filter based on an array of strings, for example: $scope.idArray = ['1195986','1195987','1195988'] The data I want to filter is in the format: $scope.data = { "moduleName": null, "contentholder_0": { "moduleName": "contentholder", "id": "-1", "name": "", "content": "" }, "webapps_1": { "moduleName": "webapps",...

SQL Query Filter to locate DUPLICATES in a column based on Values in 2 other columns

sql-server,filter,duplicates
I am using SQL Server 2014 and I am working with a table named ReservationStay. It contains the records of all guests with their names, arrival dates and departure dates. An operation has been undertaken that has split the records of hundreds of guests into 2 separate entries, which means...

Wordpress custom register form errors filters and prev values

wordpress,filter,registration,frontend
I created a front end registration form, I used the filters 'registration_errors' to customize the messages. After WP detects the error and use 'wp-redirect' to return to the registration page and display an error if the email or the user exists for example. My question is: how I can keep...

Spring boot - adding a filter

filter,spring-boot
I am wondering how I can add a filter in spring boot if the java class is only available in the app container ie it is not available at compile time. FilterRegistrationBean can only add a Filter class and not a String of a class name that will get instantiated...

Opencart 2.0 How to duplicate filters?

filter,opencart,colorfilter
We are creating filters on Opencart 2.0. We gonna create the "color" filter, but the problem is that this filter will go on every category. Do we have to put this filter manually in each category or is there any way to duplicate filter or to applicate it directly to...

Jquery Filter Out Radio Buttons ( .not( ) )

php,jquery,filter
I want to remove the radiobuttons from my multiple choice quiz so users can review their answers. I put all of the questions to be reviewed in a div called reviewQuestions var question = '#question' + zz; // zz is a variable that produces a number var someVariable = $(question).not("input[type=radio]").html();...

Filtering and multiplying filtered matrix in matlab

matlab,matrix,filter,multiplication
I'd like to filter my matrix according to a specified criteria, then doing multiplication on filtered matrix and then joining multiplied filtered matrix with remainder part of matrix. E.g. I've matrix a as follows: a = 1 2 3 4 4 5 6 2 then, i'm going to filter it...

Using Python, I want to parse each file in one directory with format YY-MM-DD.CSV but ignore all others

python,regex,file,filter
I'm new to Python, so my example represents the mess one aggregates when all experiments so far have failed. #!/usr/bin/python import glob import os import re path = '/home2/SunnyDataBackup/currentGenerated/SBEAM/' files = '[1][0-9]-[0-1][0-9]-[0-3][0-9].CSV$' #if I use '*.CSV', it works but doesn't filter the files fullpath = os.path.join(path, files) print fullpath #fullpathC...

How to retrieve filtered data from json with double for loop

javascript,json,loops,for-loop,filter
So i have build up this json file (http://www.smartbustracking.be/json/data.json) and now i am able to retrieve data. but what i would like to achieve is to filter data based on id with a for loop. i am able to show one item of a specific id but not all the...

Display all results when a checkbox is unchecked with angularjs filters

angularjs,checkbox,filter
I'm just trying to do a simple thing which give me headache. In an app with Angularjs, I have a dictionary with values. I want to filter my values using a checkbox. If the checkbox is checked, the list is refreshed with the elements which have is_streaming : TRUE. But...

Django - Feeding only part of Foreignkey in models

django,forms,filter,model,foreign-keys
i'm new to django and as a exercise I want to make "home expenses". I've already did simple model and form : (from models) #models.py #these are the type (groceries/clothes/etc. ) class TypWydatku(models.Model): typ_wydatku = models.CharField(max_length=25) data_wpisu=models.DateField(auto_now_add=True) #these are the actual input with dates/prices/etc class Wpisy(models.Model): data_zakupu=models.DateField(default=timezone.now()) data_wpisu=models.DateField(auto_now=True) typ_wydatku=models.ForeignKey(TypWydatku)...

Performance of deleting many rows from an autofilter in VBA

excel,performance,vba,filter
I would like to know if there is a faster way do this than the code I am using. I got the code using xlUp from the recorder. rCnt = Cells(Rows.Count, "B").End(xlUp).Row ActiveSheet.Range("$B$1:$J" & rCnt).AutoFilter Field:=5, _ Criteria1:=Application.Transpose(arrCodes), Operator:=xlFilterValues Rows("2:" & rCnt).Delete Shift:=xlUp And actually, if there was some way...

angularjs filter an array with string values as integers in contoller

arrays,angularjs,filter
I'm using AngularJS filter to filter an array of objects inside a controller. These objects all have a quality that is a string. I want to be able to filter the array from largest to smallest. But I can't get it filter on value of the integer inside the string....

Unable to get a response with Lambda Stream Filter [duplicate]

java,filter,java-stream
This question already has an answer here: How do I compare strings in Java? 23 answers Here is the stream "airportFilteredList" i am having trouble with, it should print the country name that matches the filter of the given "Turkey" string but it doesn't print anything to the console,...

How can I filter instances of a model in django, with a queryset value of filter field?

python,django,filter
I am creating an application in django, and I have the next question: I want to filet objects of modelA, by the field att1, and I have a queryset of values of the field att1. I mean, my models are: class modelA(models.Model): att1 = models.ForeignKey(modelB) ... class modelB(models.Model): ... I...

How to subset by distinct rows in a data frame or matrix?

r,matrix,filter,data.frame,subset
Suppose I had the following matrix: matrix(c(1,1,2,1,2,3,2,1,3,2,2,1),ncol=3) Result: [,1] [,2] [,3] [1,] 1 2 3 [2,] 1 3 2 [3,] 2 2 2 [4,] 1 1 1 How can I filter/subset this matrix by whether or not each row has duplicate values? For example, in this case, I would only...

Filter array field in couchbase

android,view,filter,mapreduce,couchbase
I m working on couchbase lite android. I have series of documents, every document contains a field which it's value is array of string. now I want to filter value of this field. { type : "customer", name: "customerX", states: [ "IL" , "IO" , "NY" , "CA" ] },...

Sphinx filter by second id in php api

php,filter,sphinx
im facing a problem since weeks, i cannot filter my search results by an second id here is my source source src1 { type = mysql sql_host = **** sql_user = **** sql_pass = **** sql_db = **** sql_port = 3306 # optional, default is 3306 sql_query_range = SELECT MIN(id),MAX(id)...

Skeleton Smoothing not working properly

c++,filter,kinect
I have to apply smoothing over the skeleton Joints. I have used Joint Filtering proposed at this link, but it is not giving correct result. Is there is any other filter or anyother way to apply the smoothing to the Skeleton? For example: I have passed all Kinect Joints to...

Angular Filter Service inside Controller

javascript,angularjs,service,filter,locale
first post ever so be gentle!! Got an issue inside Angular 1.3 and using a Stateful Filter within a controller. In short when you use the $filter('custom')(data) method as a pose to the {{ data | custom }} method - and the cutom filter updates (say a service updates), only...

dataTables custom filtering of if class list contains a class

jquery,filter,datatable,datatables
How can I filter datatable rows by class when the row has multiple classes. I need for the row to appear in any instance when the class list contains the class I filter for. <tr class="gradeA">...</tr> <tr class="gradeA gradeC">...</tr> <tr class="gradeC">...</tr> The row with "gradeA gradeC" should appear in both...

Multiple filters using JQ

json,filter,jq
My boss wants our team to use JQ to parse JSON files. An app I use produces JSON that I need to transform. I have a file that looks like this: { "Collections": [ { "OptionGroups": [ { "OptionGroupName": "Test1", "Status": "in-sync" } ], "Version": "3.4.25", "InstanceIdentifier": "Dev1" }, {...

Grab, filter and show this data in PHP

php,filter,grab
This is example what I mean: I wanna grab result from this url web1.com/do.php?id=45944 Example output: "pk":"bn564vc3b5yvct5byvc45bv","1b":129,"isvalid":true,"referrer":true,"mobile":true Then, I will show data result on other site web2.com/show.php But I just wanna see data value "pk", "1b" and "isvalid". I don't need "referrer" and "mobile" data. So, when I access web2.com/show.php,...

AngularJs ng-options for a nested JSON with a filter condition on the parent object

html,json,angularjs,filter
I have a JSON structure $scope.table = [{ 'ContainerNo': 'EGSU9014188', 'ISO': '4510', 'Type': 'IMPORT-FCL', 'Status': 'YARD', 'Hold': 'CUSTOMS', 'BLBENo': 'NIL', 'IDOExpiry': '30-05-2015', 'Remarks': 'Not valid for any transaction', 'flag': true, 'TransList': [{ 'Values': '' }] }, { 'ContainerNo': 'EMCU3886883', 'ISO': '2201', 'Type': 'IMPORT-FCL', 'Status': 'YARD', 'Hold': 'NIL', 'BLBENo': 'I/25493/2013', 'IDOExpiry':...

xmllint give attribute only if elements are present unix

xml,unix,xpath,filter,xmllint
I have an XML as shown below: <?xml version="1.0" encoding="UTF-8"?> <tns:myproject> <tns:site name="London"/> <tns:site name="Paris"/> <tns:site name="New York"/> <tns:node hostname="S1" IP="10.10.10.1" siteid="London"> <tns:elements> <tns:database/> </tns:elements> </tns:node> <tns:node hostname="S1" IP="10.10.10.2" siteid="London"> <tns:elements> <tns:admin/> </tns:elements> </tns:node> <tns:node hostname="S2" IP="10.10.10.3"...

Excel VBA - ShowAllData fail - Need to know if there is a filter

excel,vba,excel-vba,filter
I have automated a proper record input into the table that I use as a database, and when the table is filtered the input don't work. So I have code this to unfilter DataBase before every record input. Public Sub UnFilter_DB() Dim ActiveS As String, CurrScreenUpdate As Boolean CurrScreenUpdate =...

LDAP More than one negation operators in filter

filter,ldap,negation
I try to write a LDAP filter with two negations. I need all users who are not disabled AND don't belong to OU=Abt99 . This is my filter at the moment: (&(objectClass=user)(objectCategory=person)(samaccountname={USERNAME})(!(userAccountControl:1.2.840.113556.1.4.803:=2))) I tried (&(objectClass=user)(objectCategory=person)(samaccountname={USERNAME})(!(userAccountControl:1.2.840.113556.1.4.803:=2)(OU=Abt99))) and...

How to find multiple strings in VBA

excel,vba,loops,excel-vba,filter
Assume an Excel sheet contains the following values in a random column: VARIABLE X AbbA AddA bbAA ccbb KaaC cccc ddbb ccdd BBaa ddbB Bbaa dbbd kdep mCca mblp ktxy Now the column should be searched for several words and word-phrases at the same time, for example the following: (1)...

Php filter system

php,mysql,filter
I want to make a php filter system like this with 4 variables: echo"<form action='' method='GET' class='form-inline' role='form'>"; $query = "SELECT Naam FROM Soortmaaltijd"; //Alle soortmaaltijden ophalen $result= mysql_query($query) or die(mysql_error()); echo"<div class='row'>"; echo"<div class='form-group' >"; echo"<label for='soortmaaltijd'>Soort maaltijd</label></br>"; echo"<select name='Soortmaaltijd' class='form-control' id='soortmaaltijd'>"; echo"<option...

Odoo , Domain, filter date and month

python,date,filter,odoo
I try to create a filter domain in sale.report as : Month(order_date) = month(current_date) AND Day(order_date) <= Day(current_date). filter string="This Month" domain="[(('date').strftime('%%m'),'=', ((context_today()).strftime('%%m'))),(('date').strftime('%%d'),'&gt;=', ((context_today()).strftime('%%d')))]"/> I have a problem in left side of domain : ('date'), System say: AttributeError: object has no attribute 'strftime'. try many combination, but response it's same....

How can i fill in all the blanks in Column B using the data found in Column C

excel,vba,excel-vba,filter
I have completely rewritten my original question, i hope this is okay as far as Stack Etiquette? (That was not a 3rd question) ****SAMPLE DATA**** Date Order Reference Field 1 06/03/15 **865754iFP 002** 06/03/15 **865754iFP 002** 06/03/15 **818013Dc6 002** 06/03/15 **817660RiV 004** 06/03/15 **920488Hgg 001** 06/03/15 **920488Hgg 001** 06/03/15 **123771Pq2002**...

Is there a way to use AutoFac Web Api Authorization Filters through Attributes instead of injection?

asp.net-web-api,filter,dependency-injection,authorization,autofac
I have an Autofac Web Api Authorization Filter like that: public class MyAuthorizationFilter : IAutofacAuthorizationFilter { public void OnAuthorization(HttpActionContext actionContext){} } public class MyAuthorizationAttribute : Attribute { public MyAuthorizationAttribute() { } } Right now the only way I can have an Autofac Web Api Authorization Filter is through injecting it...

With angular, how do i call the result of a custom filter in a ng-show?

javascript,angularjs,filter,ng-repeat,ng-show
I have a dictionary with some datas. I'm filtering these datas with a custom filter which looks the current date and compares it with the date of the schedule. If the current date is between the dates of the schedule, it displays the schedules. My problem is I want to...

NgGrid with MVC cellFilter doesn't work

angularjs,datetime,filter,ng-grid
I am working with MVC and AngularJs. The problem is that my model (class) has property of type DateTime. When I get JSON from database, it converts data to /Date(1432617857710)/ "Solution" that is posted here should help, but it does not. What am I doing wrong? Here is my gridOptions:...

Select variables that contain value in R

r,filter
I apologize if this question has been answered. I have searched this for way too long. I have coded data that has a prefix of a letter and suffix of numbers. ex: A01, A02,...A99 ### (for each letter A-Z) I need R code that mirrors this SAS code: Proc SQL;...

Show / Hide divs based on search.keypress (filter)

javascript,jquery,html,search,filter
I have a webpage with lots of "cards" I want to filter away some cards as I type into the search field, and when I remove a character, show them again (all when empty). My problem is that it does not seem to work properly, it is "1 character behind"...

AngularJS programatically call filter from service (sort by custom filter)

javascript,angularjs,sorting,filter
I have a the following situation (a translation filter in a service, used in the html file) // serviceFile angular.module('myModule') .service('translation') .filter('translate', function(translation) { // translate stuff return 'translatedString'; }); // controllerFile angular.module('myModule') .controller('StringsController', function(blabla, translation) { $scope.mySort = function() { return "some magic should happen here"; }; }); //...

Using this.store.filter with the ID of the belongs_to model

ember.js,filter,belongs-to
I'm trying to retrieve all the layouts for a given account. /app/models/account.js import DS from 'ember-data'; export default DS.Model.extend({ companyName: DS.attr('string'), layouts: DS.hasMany('layout') }); /app/models/layout.js import DS from 'ember-data'; export default DS.Model.extend({ name: DS.attr('string'), account: DS.belongsTo('account', { async: true }) }); /app/routes/layouts.js import Ember from 'ember'; export default Ember.Route.extend({ model:...

How to get specific value of an dictionary

c#,object,dictionary,filter
i have an Dictionary of type int, myclass. in myclass i have following attributes: an string, int, and an string array. Evrything works fine when i save the data in dictionary. But i want now to look in the dictionary, if there is an value, in myclass, at the position...

Get every other value of array in PHP

php,arrays,filter
I have an array: Array ( [A] => 4 [B] => 4 [D] => 4 [E] => 8 [F] => 4 [G] => 8 [H] => 8 [J] => 12 [K] => 12 [L] => 11 [M] => 11 [O] => 10 [P] => 10 [Q] => 10 [R] =>...

How to pass modified/wrapped HTTPServletRequest to subsequent Zuul Filters?

filter,servlet-filters,netflix,netflix-zuul
We have a Zuul Pre-Filter (Filter1) which will inspect the incoming HTTPServletRequest and make some changes to the query parameters in it to embed it to a custom created request (wrapping HttpServletRequestWrapper). Now, i want to pass this custom wrapped request to the next Zuul Pre-Filter (Filter2). How can i...

Mysql select from one table by options from other

mysql,select,join,filter
F.E. I have 2 tables: Products (id,description,price) Specifications (id_product, id_specif, specif_val) I need to select all products wich have multiple needed specification values. F.E. select all products which have id_specif=153 and a value for this specif_val="test1" and id_specif=55 and a value for it specif_val="test2" Updated with my select statement, but...

How to check if element of an array is in another array?

ios,arrays,swift,filter
I have two Array holding the instances of class MYItems. FavoriteItems holds the favorite items from the array Items var Items :[MYItems] = [] var favoriteItems = [MYItems]() Now i want to check if the Items array contains the favoriteItems in the . How can i acheive this? i tried...

Python - Why is my list not being modified outside the scope of this method? How do I modify my code so that it is?

python,list,filter,scope
I have the following method: def instances(candidate, candidates): count = candidates.count(candidate) # Removing candidate from candidates. # list(filter(candidate.__ne__, candidates)) return {candidate: count} Its intended purpose is to find how many instances of a certain element are in a list, delete those instances from the list, and return a Key:Value pair...

filter from listbox regex

c#,regex,filter
I am trying to filter data in a listbox based on an input when I click a filter button. The lines that are in the list are in this format: Id: 1 Leefijd patiënt: 12 Gave blood: yes So my idea was to get each of the lines of the...

3 condition in WHERE clause for filtering

c#,filter
Basically I am trying to filter the distinct time and temperature from my database based on 3 condition. (column) UnitNo = txtUnit.Text (what user input in textbox) (Start date) Date >=ComboStart.Text (what user selected for 1st combobox) (End date) Date <=ComboEnd.Text (what user selected for 2nd combobox) I know the...

Recalculate markercluster and downloadUrl

google-maps,google-maps-api-3,filter,markerclusterer
I am trying to fix the problem with out success. As you can see when you uncheck the VDSL or ADSL option the markercluster still having the same value. downloadUrl("php_to_xml.php", function(data) { var xml = data.responseXML; var markers = xml.documentElement.getElementsByTagName("marker"); for (var i = 0; i < markers.length; i++) {...

AngularJS - Filtering Json by a variable

json,angularjs,filter
I am working on a single page app using dynamic routing. I get my bookid from the URL as below myApp.controller('BookCtrl', function($scope,$routeParams) { $scope.mybookid=$routeParams.bookurl; }); Here is my data var bookdata = { "records": [ { "seriesid": "SpectrumSeries", "name": "White Curse", "bookid": "WhiteCurse", "image": "book1", } ... ]}; In the...

Excel VBA range after filtering xlCellTypeVisible

excel,vba,excel-vba,filter,range
What I want to accomplish: Open a workbook from a specific address, Filter the first column for value equal to 36 or 541 (I got this first part working), then check column 3 to see if a value of 2 exists and if it exists then filter out everything except...

Firebase: combine filtering with ordering in swift

swift,filter,order,firebase
So I have a sports app, which handle matches and championships data. I have two displays using the same data: All future matches All future matches from a certain championship The data is structured like this - championships - libertadores - name: Libertadores da América - matches - 2j6g42kjhg62 -...

Lowpass filter non working

matlab,image-processing,filter
I have a noisy image that I am trying to clean using a lowpass filter (code below, modified from here). The image I get as a result is essentially identical to the one I gave as an input. I'm not an expert, but my conclusion would be that the input...

String query Search and filter between Dates

sql,date,search,filter,between
String query = "SELECT * FROM salesTable where timeStamp BETWEEN '"+startdate+"' AND '"+enddate+"' ( sellid LIKE '%"+search_str+"%' OR tastemodel LIKE '%"+search_str+"%' OR bezeichnung LIKE '%"+search_str+"%' OR sellid LIKE '%"+lastName+" "+firstName +"%' ) ORDER BY timeStamp DESC"; How can I combine a normal string search with between two dates?...

Filter arrays in Javascript and return all related objects

javascript,arrays,object,filter
I want to filter an array of objects with JavaScript. array( (int) 0 => array( 'DetailedWorkingHour' => array( 'id' => '326', 'start' => '07:00:00', 'end' => '16:00:00', 'date' => '2015-06-17', 'working_hour_template_id' => '3' ), 'WorkingHourTemplate' => array( 'color' => 'red', 'id' => '3' ) ), (int) 1 => array( 'DetailedWorkingHour'...

Creating filtering by 'Created_at' and/or presence of data in multiple columns

ruby-on-rails,search,filter
Big newbie here. Started rails recently. I've been searching and I'm stuck on forward progress where I've reached filtering. Currently on my index page, I'm showing all orders created. Customers (first_name, last_name) pay by 'cash', 'credit', or 'check' (shown in decimal(8,2)). I would like to create a filter where manager...

DOORS Compound Filter Dilemma

filter,dxl,doors
DOORS Version: 9.5.2.1 I'll try to break this down as simple as I can. First, I'll start with the data. Assume I have a module, Module, in DOORS. Module is comprised of: Tree Structure Assume that Object Text for headings and sub-headings are blank, and assume Object Text for the...

How do I apply filter_input to superglobals

php,netbeans,filter,filtering,superglobals
According to netbeans IDE, I need to add some sort of a filter to superglobals, filter_input() suggested by netbeans, for the code below $page = (isset($_GET['p']) && !empty($_GET['p'])) ? $_GET['p']: 'home'; After researching, I found this example on stackoverflow $name = ($name = filter_input(INPUT_GET, 'name')) ? $name : 'default_value'; But...

How to specify callback function when filtering array with object elements in php?

php,arrays,filter
I have an array whose items are of a certain object type, let it be my_object. The class defining the my_objects has a function that I want to use to filter the array. How can I specify that function when calling array_filter? class my_class{ private $exclude; public filter_function(){ return !$this->exclude;...

AngularJS - Filter out single object in nested data structure

angularjs,filter,nested,ng-repeat
Data var data = { "records": [ { "name": "Spectrum Series", "seriesid": "SpectrumSeries", "book": [ { "name": "White Curse", "bookid": "WhiteCurse", "image": "book1" }, { "name": "Blue Fox", "bookid": "BlueFox", "image": "book2" } ] … other series } Controller dnleoApp.controller('BookCtrl', function ($scope, $routeParams) { $scope.mybookid = $routeParams.bookid; $scope.myseriesid = $routeParams.seriesid;...

Woocommerce Filter Product by Attribute

filter,attributes,woocommerce,product
I've been searching for many blogs and forum but this seems not yet answered yet. So i am trying to find a way how to filter product by attribute. I am using ajax to pull data and append it.The question is what will be the query to make a loop...

Autofilter Column data one by one using buttons

function,excel-vba,data,filter
I have a some filtered data in a column that I would like to see for one value at a time by a macro. so far I have got up to the code below but it filters out when I manually select a value from the column. Is it possible...

ACCESS 2007 - Form / subform filtering between dates

vba,date,ms-access,filter
In ACCESS 2007 I have a main form with two unbound comboboxes named cmbStavOd and cmbStavK, both formatted as Short Date. I have a subform named frm_qryNaklady_subform, based on a query with a field named datNakladDatum (textbox name datNakladDatum), formatted as Short Date. I'd like to allow users to enter...

Filter array by common object property in Angular.js?

javascript,arrays,json,angularjs,filter
I've been struggling with this over a few hours. The situation is, I have an app, that receives data about people in this JSON format: "people": [ { "name": "Ivan", "city": "Moscow", "country": "Russia" }, { "name": "John", "city": "Seattle", "country": "United States" }, { "name": "Michael", "city": "Seattle", "country":...

AngularJS Filter two select inputs with values less than or equal to value

javascript,angularjs,select,filter,compare
I would like to setup two select inputs so that the combined value of either select input should be less than or equal to a specific value. Newbie to the AngularJS world so I may have overlooked something. I assume a filter but it might be ng-change that I should...

Filtering, Slicing, Sorting in Javascript through Angular Factory

javascript,arrays,angularjs,object,filter
I'm trying to create a list of data items that have first been filtered by value, then sorted by descending value, then sliced to only show the top 5 items. I'm using an Angular factory to return these values to my controller, so that I can display the values in...

Angular.JS filter items using selected option in select dropdown

json,angularjs,wordpress,filter,angularjs-filter
Using the WP API I am outputting a list of posts onto a page from the JSON file. I am trying to filter these posts using an input field and two selects. Currently I am able to filter the posts through the input field (searchrecipe) when I search for a...

Logstash filter section

filter,logstash,zabbix
Could you please advise how to filter a specific words with Logstash 1.5? For example, it's necessary to filter the following words: Critical, Exit, Not connected. As I remember, in previous versions of Logstash (i.e 1.4 and earlier) it has been possible with grep filter. Currently my logstash.conf contains: input...

JSON log file compaction

json,filter,unique,stream-compaction
Given a file with line delimited JSON records: {"id": 1, "position": 1234} {"id": 2, "position": 23} {"id": 3, "position": 43} {"id": 1, "position": 223} I would like to compact such a file, by keeping only the last record for an id, e.g. for the above example I would like to...

Git > diffs filtered, show only certain changed classes/files

git,filter,grep,diff,git-log
I have 2 versions of a software (i.e. tag 4.1 and tag 4.2). Now I want to filter out in which java classes of version 4.1 there were fixed bugs. If I enter git diff r4.1 r4.2 --name-only > patch.csv I get a list of all changed classes from version...

Primeface Datatable filtering removed when sorting with o:form includeRequestParams=“true”

primefaces,filter,datatable,omnifaces,http-request-parameters
this is an issue following this one: Primeface datatable.filter() and url parameter is use PrimeFaces-5.1 and omnifaces-2.1 to render a datatable with pagination, filtering and sorting while using request parameters. my datatable is constructed like this: <o:form includeRequestParams="true"> <p:dataTable id="hostStateHistoryTable" value="#{HostHistoryBean.hostStateHistoryList}" var="status" widgetVar="statusTable" filteredValue="#{HostHistoryBean.filteredHostStateHistoryList}" rowStyleClass="#{status.state eq 0 ? 'up' :...

How to filter keys of an object with lodash?

javascript,filter,lodash
I have an object with some keys, and I want to only keep some of the keys with their value? I tried with filter: var data = { "aaa":111, "abb":222, "bbb":333 }; var result = _.filter(data, function(value, key) { return key.startsWith("a"); }) console.log(result); But it prints an array: [111, 222]...

Filter (no display) layers in GeoExt.LegendPanel using LIKE operator [closed]

filter,panel,openlayers,legend,geoext
This works to avoid Basemap layers such as Google Maps and overlays such as WMS to appear in the GeoExt Legend Panel: var legendPanel = new GeoExt.LegendPanel({ border: false, filter: function(record){ if(!(record.getLayer().isBaseLayer) && (record.getLayer() instanceof OpenLayers.Layer.WMS)){ return true; } } }); The problem is that I need to filter (ie....

R: how to split list into AM/PM

r,filter,split
The time stamp on the survey grouped all of my data into one column under StartTime, but I need to split my data into AM and PM groups. For example, right now my data looks like 8:37 PM 3:58 PM 10:22 AM 2:48 PM 6:33 PM 7:10 AM 10:59 AM...

Android listview filter without pressing search button issue

android,database,listview,filter
I have a ListView which work fine. Now I have put an EditText at the top of my ListView. What I want is that when a enters a letter "A", only the names starting with an "A" should appear in the list . I have try to do this but...

Angular Show All When No Filter Is Supplied

javascript,angularjs,checkbox,filter
I have been working on trying to get my Angular application to show all results if no filter is selected. I have looked at similar questions on here, but their answers did not work for my application for some strange reason. I have it working initially, but after a filter...

Can I filter an Android app by the mobile network operator?

android,networking,filter,operator-keyword,carrier
For example, I want to make a specific app so that it only shows up and can be downloaded by users on the Vodafone network.

Angularjs make invisible accordion if subelement are filtered

angularjs,filter,accordion,visibility,ng-repeat
i have created an accordion dynamically with angular. Code: <input type="text" class="form-control pull-left" ng-model="searchSingoloCampo.title"> <accordion-group ng-repeat="category in categories"> <li ng-repeat="resource in category.resources | filter:searchSingoloCampo"> </li> </accordion-group> The accordions is generated by a list , and inside each accordion there is a sublist of elements. I can filter the element inside...

Filter SELECT output by string in Spaql

filter,sparql
I have a Sparql query like this : PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX owl: <http://www.w3.org/2002/07/owl#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX hrdata:<http://www.hrdata.com/ontologies/hrdata.owl#> SELECT ?tableName2 ?fieldName ?primaryKey1 ?primaryKey2 ?tableName1 WHERE { ?tableName1 hrdata:hasField hrdata:EFFDT. ?fieldName hrdata:relatedField hrdata:EFFDT. ?tableName2 hrdata:hasField ?fieldName....

SAS: How can I filter for (multiple) entries which are closest to the last day of month (for each month)

loops,date,filter,sas
I have a large Dataset and want to filter it for all rows with date entry closest to the last day of the month, for each month. So there could be multiple entries for the day closest to the last day of month. So for instance: original Dataset date price...

filtering based on the last two current values in java rx

java,filter,reactive-programming,pair
I'm trying to build a simple application using java reactive extensions. I have two streams that emits temperature values continuously, I want to detect and filter out spikes of sensed temperature that could be errors, for doing so I need to take account of the precedent value too so that...

angularJs filter in ng-repeat

angularjs,filter,angularjs-directive
I am trying to provide a pagination to a table: Let's say there are 100 records and records per page is 10. If I am in 3rd page, records from 21 to 30 should be prepared in the table. So I am trying to filter those records using angular filter...

VBA fails to limit to just .dat files if there are zip files present in the folder

vba,filter,folder,zipfile
I have added a filter to the type of files allowed to selected (.dat files) however I have found that if there are zip files present in the folder the script does not work correctly as it also opens the zip files. 'Specify folder where measurement files are stored With...

How do I do to count rows in a sheets with filters? With a suppress lines

excel,vba,filter
I have a sheet with lots of columns, but when I filter and use count = Application.WorksheetFunction.CountA(Range("A:A")) It returns all the rows non Empty. Not only the rows I filtered....

Creating a list of items with different tags + filter

javascript,html,list,filter
I have prepared an example what I would like to produce: link. I have already looked for something and I have found the way to create a filter but just for one value... In my case I need more values all together combined. So that if I wanted a flat...

codeigniter filter database

codeigniter,filter,model,conditionals
i have a few checkboxes that filter my elements from a database but i don't know how to apply a filter like price with a min value and a max value, since from my view i can pass to the controller only one value of my inputs For example: i...

Displaying list of options based on another select in Angular

javascript,angularjs,filter
I have two select dropdowns where options in the second select depend on what option is selected in the first select. At the moment I am trying to figure out what way I should return my data from the server which would depend on the way I setup my filter(s)....

Syntax error while using Lambda functions

python,filter,lambda
I have a list with some dummy email address as below: listEmails = [[email protected]', [email protected]', [email protected]'] I was trying to use lambda and filter to get the list of valid email address. let's assume [email protected] is the only invalid email address. I used the regular expression to filter out the...