Questions tagged [query]
The query tag has no usage guidance.
160
questions
0
votes
0
answers
11
views
Unable to generate CSV in Kibana when querying for an IP address
I'm trying to search for an IP address in my data on Elasticsearch (v8.8.0) using Kibana. If I simply enter the IP in Kibana's Discovery's query bar, and I try to export the results into CSV, I get an ...
- 603
0
votes
0
answers
13
views
How to delete all exact element tags in inspect element console with this querySelectorAll method? [duplicate]
think of this as giving a manual of how to do querySelectorAll method to dummies because it is
now dont use terms i understand that actually confuses me just explain but do it thourally please with ...
- 9
1
vote
1
answer
209
views
How to find matching yaml files based on content
I have a bunch of files that contain yaml. Some files are yaml-only, some have yaml front-matter. I would like to be able to query the list of files to return a list that match certain criteria. In ...
- 113
0
votes
1
answer
32
views
How can I create a team watchlist in Azure DevOps, similar to how individuals can follow items?
In Azure DevOps, I'm trying to create a "team watchlist" that allows visibility for the entire team to see followed items on the dashboard.
For example, queries can be filtered by ID=@...
- 1
0
votes
0
answers
114
views
Microsoft excel: Queries and connections - option to update data manually is greyed out
For my link to other excel workbook table:
For some reason, the update: manual option is greyed out for this query link in excel Data --> edit links.
I don't want the data to update automatically ...
- 103
0
votes
1
answer
67
views
how to optimize DB query for table with millions of rows when info is sorted (sorted by date in this case)
Imagine you are chatting with your SO on Whatsapp and the conversation is years long, so there are thousands if not millions of messages.
CREATE INDEX date_index ON messages_table (date_column);
and ...
- 271
0
votes
1
answer
74
views
Outlook specify mailbox in search query
Is it possible to specify the mailbox in the search query itself instead of using the dropdown on the left ? Thanks.
0
votes
1
answer
53
views
Column/Row management in Power Query
I have a .txt file with loads of data in it. I have it loaded into Power Query thusly:
[let a letter (A) equal a row of data, one column wide]
A
B
C
D
E
A
B
E
A
E
A
B
C
D
E
and so on...
I would like ...
- 3
0
votes
1
answer
358
views
Outlook query for 1 thing in subject line and 2 things not
I use a browser to access my Office 365 email. In my experience so far, the search syntax is the same as for the Outlook desktop application.
I tried the following search query:
subject:"meeting ...
- 1,201
5
votes
2
answers
5k
views
Only return state of a service when using sc.exe query
When using the following command to return information about a service to a file :
sc.exe query MyService >> MyFileLocation\MyFile.txt
I get the following information in the file :
SERVICE_NAME:...
- 195
0
votes
0
answers
20
views
Access database advice
I'm new to access so this might sound stupid.
I have few thousands csv files, each one containing few hundred rows of transactions data for an item. Each csv file is a different item.
I want to use MS ...
- 15
0
votes
0
answers
128
views
How to diagnose why Query in Microsoft Access is returning wrong results
I have a database in which I store information about what work our contractor is doing for us.
Basically I store WorkNumber, date when work was done, contract number, subcotnract number (we have ...
- 156
0
votes
1
answer
544
views
SQL QUERY not picking up EXCEL date parameter not functional
I have an overnight data set that needs refreshing everyday. I used today's date with format =NOW() and tomorrow's date as =NOW()+1. The query is not pulling up the date from cell reference despite ...
- 19
0
votes
1
answer
121
views
Query Security Events in Windows 10
I enabled Object Access auditing on my Windows 10 laptop using the instructions on this page. I then enabled auditing on a file (i.e. Sleep Times.csv). I accessed the file and manually looked ...
- 1,316
1
vote
2
answers
2k
views
Select statement using 'EXISTS' and 'IN' operator
I hit an issue to get data using 'IN' operator from another database. I need help fixing this please.
My query looks like this:
SELECT i.EXTERNAL_CODE, tc.SITE_NAME, tr.TRANSACTION_DT
FROM ...
- 653