Hi! This project is about a query to get results by date using mongoengine over mongodb to filter results by month, year and month and age So, I have a model in Mongoengine class Contact([login to view URL]): name = [login to view URL](max_length=255, verbose_name=_(u'Name')) email = [login to view URL](verbose_name=_(u'E-mail'))
We need a VBA developer that is experienced with Excel, VBA, and Jira. Need an Excel macro to connect to Jira query for Epics, stories, linked test cases, bugs found during testing. I have all of the JQL needed to find the issues in Jira.
...have a very small database (<40 entries) that I'd like to make available online in an attractive, user-friendly manner. Users should be able to take a "quiz" to select what data they're looking for (3-5 questions/search criteria), and the web app should then produce results in a preferred order. It should not look like a database but rather an attract...
I am using Power Query to access football scores data from an API service in JSON format. The API endpoint address contains my API key and API secret and everything works well. However, instead of having to do a new query with a different endpoint address every time I want to get new information, I wish to have the address dynamic so that the variable
...freelancer.com) I need the BID results on the page to be ordered by meta stored in a users profile, which is a custom post type PROFILE. I need to add functionality to my WordPress theme that will add a dropdown to reorder custom post type BID results in various ways, according to meta (numeric) in custom post type PROFILE. The drop-down will need to
...website mobile friendly with CSS media query Pages to work on : shared Header/Footers [login to view URL] [login to view URL]@/Rembrandt-Van-Rijn [login to view URL]@@/8YDJKC-Night-Watch [login to view URL] [login to view URL][Champ20_EN]+contains+%22Books%22 https://en
I am running php script on a server that puts multiple logfiles into database, which is working like a charm. So i have noticed that there is some powershell script which would need just a little bit modification to work instead of that php file. Since I am not a real powershell guy and aint going to learn it just for this script I need help with it
...who can display the answers from a questionnaire which people fill in before registering on wordpress dating website in the chatbox sidebar so that when people are chatting to each other, they can see what the opposite person has answered? That could be the query we need to run: 1. $querystr = "SELECT * FROM `wps_formmaker_submits` WHERE `user_id_wd`
For module requirement check the attached document and develop a query management module. In this development someone register for any type queries and automatically generated User ID and password for login in admin panel to post any type queries.
Fix SQL Query Issue. What to fix: Need to fetch those records / rows that contains all keywords in any column in Name, Descr or OtherDesc Columns. See txt file for details. Important Note: Please read the txt file and prepare your queries if any before posting, otherwise the bid will be rejected.
Need proper SQL Query for the following query: For E.g. there are some records in the SQL DB Table as follows: ID NAME DESCRIPTION 1 Test One This is the Test Record having test description 2 2nd Record This test record is the another one with sample text When
The solution I am after requires a data engineering development which should be able to query a postgreSQL database of 20 million records (2 crores). In the ideal scenario, the query should return 100,000 records under 5 seconds. I am looking for someone who is experienced in Apache Spark and able to show a proof of concept before developing a full
When the checkout function is used i get the error WARNING : Error while sending QUERY packet. PID in /ur/www/users/xtremezepc/[login to view URL] on line 1924 This is causing high load times when i try to check out. there are sleeping queries being created. Need fixed NOW.
Using REACT, we want to pull in API results into HTML. We want to use a query string parameter to determine which results to pull using the API call and then display results. The goal is to have the query string parameter from the following URL pull into the API: [login to view URL] The “3828840” is the result ID that will
- Data source Database type: oracle 11 (or higher). - The database is already existing and with data inside. - Server environment: windows server 2012/2016. - Development on dedicated vps server. - All phases of preparation and configuration of the Set up of Development Environment must be fully documented. The source code must be documented and commented
We have a dealer website with a login and search ability, we want to be able to have the same search ability that is always up to date to the host site minus one column of the search results.
I am looking for a product that can a.) receive texts and phone calls with an automated attendant b.) query a database and acknowledge accuracy then c.) send a call or text to another user. I will also require a simple database containing names, addresses and contact information. I would prefer to work with someone with which I can meet face to
1. The program will follow XML stream where a query will be made. 2. The query interval must be able to be determined 3. The program must work as a service (and I want to test it on command prompt or other way) 4. XML is situated in a path or address like [login to view URL] (it can also be on a different pc like 10.10.10.1234:5656 / xxxxxxxxcurrent
We need an SQL query built for a hotel group. This query will be run at any date in time, to pull historical, future or combination of both to show what segmentation is on the books [to include revenue, room nights & average daily rate] We will run the query and then the attached file is how we want the data to be exported from the Property Management
...making some queries work. This first project is for a table that I tried to put together myself but I just do not know SQL. I have pieces but not the whole. Will lead to more query projects. Hoping to find a someone that knows Open Dental tables and can accurately build reports. Sample Open Dental Queries: [login to view URL]
Hello, I need easy access query support, I have the set of data which is in Totals Select Query. There are bunch of users with 1 line per user and 5 attributes in column. I would like to have 5 lines per every user with those attributes in rows
I need a lightweight applicatio...= , < , >, <> user defined criteria. There are 4 components to the application- 1. DB connections 2. The monitor - The monitor will be a collection of sql query, schedule to run the query, contact to alert if condition is met 3. Logs showing history of when monitors are run and results. txt file based logs are ok
Part A and B Part-A. Basic SQL Dataset: ComputerStore The schema is as follows: ComputerStore manufacturers code, name products code, name, price, manufacturer The manufacturers table stores information about computer parts manufacturers as the manufacturer code and manufacturer name. The products table stores information about product as a product code, product name, product’s price a...
[login to view URL] Is the website. Using the API key the data gets extracted every 12 hours and then it goes into database. The website should offer the functionality where i could pick the day intervals to see the change in the ranking of coins etc so the coloums on the front end would reflect the time interval i select . I could be a combination
Need Import Forum Tables into Kunena 2.04 (Joomla FOrum Extension) with a MySQL/PHP Query or with Kunena Importer. the process complete not properly
...Combine 5 Excel WorkSheets across 100 WorkBooks that we are trying to solve with automation and the use of the Power Query Append Command. Do not respond to this project unless you can show us some actual examples of your Excel Power Query Workbooks which are working correctly. Every 2 weeks we get between 75 and 100 individual WorkBooks named after
I am building a database for a preschool and need to calculate the children’s ages in years and months. I can work out the ages in years using the datediff function but can’t work out how to refine that to include the date as well. I have no experience with VBA codes.
...in SQL 2008. We need to bill each month based on the number of records added to each database. We have been doing this manually up until now. I would like to write a SQL script that will allow my (inexperienced) user to 1) Create a table in the Billing database named by the MonthYear. 2) Set a biggining/ending date range for us to bill. 3) Run a
This query working SELECT DATE_FORMAT(oo.date_added, '%m/%d/%Y') as Date, ot.order_id, round([login to view URL],2) as total, round(SUM([login to view URL]*[login to view URL]),2) AS weight, round(SUM([login to view URL]*p.cost_sk),2) AS product_cost, (Select round(SUM([login to view URL]),2) from oc_order_total ot1 where [login to view URL] like 'tax' and ot1.or...
Hello, I need to modify Powershell SQL query to retrieve multiple drive mappings. RIght now it maps drive fine only if user belongs to one group. But if user belongs to multiple groups mapping gets messed up.
...with over 90 million records and trying to build a particular query in the most efficient way. PostgreSQL experience is mandatory however Python and Django skills will be advantageous. It's probably less than one hours work and urgent. So I will be choosing some one who is currently online within the next 1 hour! PS: L am not looking for any website
My Codeigniter web application is powered by 2 separate MySQL databases. I need a query that will query both databases individually on demand, on the fly, for each each user request, and combine the results programmatically.
I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required) for this.
1 step : need help creating ajax query to send and receive json data with multiple data 2nd step : need help to create php script that receive data send using ajax query and call another php script 3rd step : call another php script to perform specific function from another folder 4th stpe: send output back to web page 5th step : need to make sure
Hello, I run a Wordpress store with Woocommerce. I want to display a top 10 sales charts of "recent" sales on a page. I'm looking for a custom script / query to display a vertical list of the 10 products that sold the most copies in the last 30 days (like a current top sales charts). I would like to have it usable via a shortcode, so that I can display
...need a SQL query that will return a set of frequently used patterns / word combinations in a field, as well as the number of matches found for that pattern in the field. Any amount of text could exist before or after the pattern that's shown. I should be able to add Where clauses to the query to filter the dataset that's used for the query. Example: