...means the query will run once for each class - Economy, Premium Economy, Business, First) - Maximum number of Stops (Direct, 1,2,3 stops) - For how many more days from the departure date the query should run (explained below) The tool must be able to run a query with multiple origin and destinations for the same flight dates and look for data for a custom
...for the protection of database data. · Cross-site scripting – The Freelancer will submit active content to the application in an attempt to cause a user's web browser to execute unauthorized and unfiltered code. This test is meant to validate user input controls. · Parameter tampering - The Freelancer will modify query strings and parameters, and hidden
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
...--Create Index Create sample index for few documents. I will provide sample data in jSon or CSV format or any other format required. Remaining indexes I will create myself. Advise on how to create synonyms to include in the mappings. --Write Query DSL and optimize search --Web Layout with EUI Framework (React UI Components) --Signup
I need someone to write a simple sql query to copy fields between tables
...restriction levels for Admin, Viewer, and Enroller). This will allow certain users to make changes, and view certain columsn. each user level will be able to access and view certain data. All this will be based on the 26 colums of the excel sheet. We will inform you which user lever can view or edit which column. In addition each record should have a status
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
...impressions, CTR (click through rate) and position for a fictional bike company called "example". This is example data downloaded from Google Search Console about a fictional bike company called "Example". Google Search Console allows us to download data about our website to see how we are ranking for given search terms. To explain the columns if you are not
...project are based on SMS (School Management System) which is manage all Student record And Storing the data or information of School Department,i.e attendance, Subject record, and parents query or sending the message to student parents for complain or any query from [đăng nhập để xem URL] on..this is very usefull for SMS. it is developed on the PHP technology and
...information. The code being read will be a primary key that will be used to query an already prepared viewer in the MYSQL database. The resulting data from this viewer will be presented to the user as shown below: The user can only consult the data, no change is allowed. All data manipulations will be performed at the rear and will not be the responsibility
...have installed M1 EE and I want to migrate only the data (products, orders, customers, categories and etc.) to the clean M1 EE. When I ran the installation over the CE database I receive an error: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '381' for key 'PRIMARY', query was: INSERT INTO `catalog_eav_attribute` You will work
I need you to setup / create a form within caldera forms plugin. The data needed for calculation comes from givewp and affiliatewp plugins user data plus a user input (a floating number field in the form eg 0,1). The calculation for the affiliatewp processor [Total] field is: (givewp total donated + affiliatewp unpaid referrals) * user input After
NAME: DentaKNOX Its combination of two words (Dental + KNOX) This logo will be used for professional SOFTWARE FOR DENTAL CLINIC MANAGEM...This logo will be used for professional SOFTWARE FOR DENTAL CLINIC MANAGEMENT having features to register patient/record patient treatment data etc. It will be cloud based software. Feel free to ask for any query.
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
Looking for an XLS (or what might work better) for the...would then be used to populate a master xls, If I am looking for a bartender for Tuesday night in DC, I should be able to query bartenders, DC, who is available that night and contact them. It would be ideal for the initial data entre to be web based, that info would then feed to our master xls
...our inventory quantity), plus a checkbox based upon sql query results we will provide. Add 3 buttons with the indicated functionality to the window, Pause, Remove, Un-pause. The buttons will interact with our Google PLA products and apply the indicated results to product listings. Amazon data will not be affected by the buttons. Using ftp for the change(s)
We are looking for a junior PHP Developer responsible for managing back-end services and the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, definition and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You
...to upload too much data to backend functions in site taking more than 10sec to load : [0x00007fae60e15320] query() /srv/[đăng nhập để xem URL]:25 [0x00007fae60e15220] query() /srv/[đăng nhập để xem URL]:84 [0x00007fae60e150f0] query() /srv/geekmagazine
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
...to build an elegant front end for the project fellow the data from of this API sample: [đăng nhập để xem URL] and one of the searching functionality should include by adding URL [/Im_raw_sql_query/?query=text] like this : [đăng nhập để xem URL] The job only has to deal with the front end presentation
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
Oracle identity manager product using Dbat connector back end is Java and Groovy for connector configuration and customization Groovy is used ...configuration and customization Groovy is used to connect to target database table and join another table and generate required output. Use groovy script and query table to fetch data. Query is available.
SELECT [đăng nhập để xem URL], SUM([đăng nhập để xem URL] * [đăng nhập để xem URL]) as price FROM Customers INNER JOIN Invoice ON [đăng nhập để xem URL] = [đăng nhập để xem URL] INNER JOIN InvoiceDetail ON [đăng nhập để xem URL] = [đăng nhập để xem URL] group BY [đăng nhập để xem URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but no...
...of mobile apps, web apps, and A.I. - based analytics *Design, implement, test, and maintain REST APIs *Craft robust QA systems to ensure product and data quality and reliability *Design schema and query optimization for databases (PostgreSQL, NoSQL) *Design and maintain required software version controls *Standardize processes to maintain clean, testable
I have a request table I need a few queries done on. This is an excel sheet. I need to find out quick analytics on our user behavior. It would be excellent to get the %, numbers and graphs depicting results.
Hi, I need to upload data from an excel to a database by creating a new table, and from there transfer some data to 2 sql tables from that database. More details in the attached excel file. Cosmin
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
I need someone to edit and Excel VB script that we use to refresh query data. We need to insert code to also update pivot tables at the same time. We believe we have found the correct code at: [đăng nhập để xem URL] We just don't have the inhouse expertise to add
I want a tool which will download all the candlesticks data from [đăng nhập để xem URL] view.com. It should also download that candle is green or red. Also values for all indicators at a point. so probably should query next pattern and get values for them.i may want to use it for my website.
...small reports, and for each of them we need to get: a. SQL query/SP that will fetch the data from tables. b. C# code for the Web Services which will fetch the data from DB and provide them as a data structure c. XAML code for one page of the mobile app that will call the Web Service, consume data and display it in the report. [We are using MVVM structure]