Stack Overflow
Stack Overflow

Questions tagged [exclude-constraint]

28 questions
0
votes
1 answer

How to plot lat/long points but exclude some based on another variable?

I'm using python to plot a fish population in a certain area and my lat/long coordinates indicate every trawl while recording where the species is/isn't. I want to plot all of my coordinates where the species is by excluding the coordinates where…
Christina Ziccardi
  • 5
  • 1
0
votes
0 answers

How to execlude same month and year in Postgres

short code drop table if exists x; create temp table x( d date, exclude using gist (extract(month from d) with =, extract(year from d) with =) ); how to make this possible CREATE EXTENSION if not exists btree_gist; -- i…
Rami Jamleh
  • 1,819
  • 1
  • 13
  • 10
0
votes
1 answer

Exclude one sheet from being looped through by VBA Macro code

I want to exclude 1 worksheet from being looped in the code, how do I go about adding/doing that? I want to exclude my mailing list from being run through the code ("WB Mailling List"). I've tried a couple different suggestions that I found in…
Kenna
  • 1
  • 1
0
votes
1 answer

maven-assembly-plugin: use config.properties during development and but pack config.default.properties as config.properties on jar-with-dependencies

I've got two configuration files (with usernames and passwords for the database for the testing phase) in src\main\resources\{config.properties,config.default.properties} During the development and my own testing I would like use…
arthur
  • 1,034
  • 2
  • 17
  • 31
0
votes
2 answers

Google Analytics exclude internal traffic not working

I try to create a new filter but it didn't work! When I exclude my Ip Address. I can still view my tracing moves on page "Real-time". I have a link with Google Tag Manager... Should I set something else for exclude my Ip Address?
Youri Van Laer
  • 3
  • 1
0
votes
1 answer

Can I exclude a specific category of a custom post type from both search and archives?

I have a custom post type "courses" and the taxonomy for categories within this post type is "course-category." I have a course category called "Academy" and I would like to exclude that category from any search, and from any archive pages for that…
fuadmurad
  • 7
  • 3
0
votes
1 answer

Sum Only Specific Values in a Column

I have a query in MS Access that display's the following information: ID Count Complete_Type UserA 10 Replied UserA 20 Sent UserA 30 Closed without Response I want to create a new SQL query that uses the query above but sum's the…
Tkbuc
  • 1
  • 1
0
votes
0 answers

excludeTags in facets does not exclude a term

My document collection has an attribute cfname2. Using JSON API I can query *:* and facet on this attribute and exclude 00 term: GET http://localhost:5555/solr/db/query HTTP/1.1 content-type: application/json { "query" : "*:*", "limit":…
arthur
  • 1,034
  • 2
  • 17
  • 31
0
votes
2 answers

How to exclude records from SQL query?

Given the following SQL query: select t from tableA t, tableA t2 where t.validAt = :validAt1 and t2.validAt = :validAt2 and t.uniqueId = t2.uniqueId and nvl(t.code, 'xNVLx') != nvl(t2.code, 'xNVLx'); the result is that I get the records of the…
DerBenniAusA
  • 727
  • 1
  • 7
  • 13
-1
votes
1 answer

SQL with CTE that has ROW_NUMBER Over Partition remove rn column

I have a script that returns results that are including the RN = 1 column, So all rows have this value 1 with column name RN. If I try to change select * to select my as 'column_name' I get strange results where the column names are in all the…
Dominic Legendre
  • 123
  • 1
  • 7
-1
votes
2 answers

SQL query help needed: How to exclude or prioritize rows in SQL in the same table

PROBLEM I HAVE I have an application with Users, Roles, Clients and Systems. I have a table named 'policies' that contains the 22 policies/rules my application relies on. Each one of the 22 can be defined at one or more levels. The levels can be:…
Bernat
  • 469
  • 4
  • 8
-1
votes
1 answer

Not does not exclude query info

I have a really long query and I'm finding that my NOT is not excluding what's in parenthesis after the NOT. I saw Exclude and where not exists, but I'd have to re-select for that, and there's too many complicatedly joined tables in what I selected…
Michele
  • 3,617
  • 12
  • 47
  • 81
-2
votes
1 answer

PostgreSQL custom CHECK on column

I have the following table: DROP TABLE IF EXISTS employees; CREATE TABLE cars ( model VARCHAR (50), brand VARCHAR (50), price INTEGER ); Which looks like the following: model brand price Clio Renault 3000 Clio …
Louis GRIMALDI
  • 101
  • 1
  • 12
1
2