Elasticsearch nest query exampleεργασίες

Έχουμε ενα script σε python σε fast food. To fast food διαθέτει ηλεκτρονικο κατάστημα. - Συνδεεται καθε λεπτό στο mysql server του ηλεκτρονικου καταστήματος - κανει query, αν υπάρχει ΝΕΑ παρα&gamma...

Σε wordpress site (theme true mag) θέλουμε 1. Φίλτρο αναζήτησης των posts με βάση categories και να γίνεται sorting των αποτελεσμάτων με βάση newest, oldest, most viewed. Το επιθυμητό αποτέλεσμα είναι το φίλτρο στις ομιλίες το&upsilo...

...προβολής. Στην συνέχεια θα εμφανίζει μια πανοραμική εικόνα του αμφιθεάτρου. Απο εκεί ο χρήστης θα επιλέγει την θέση που θέλει με την οθόνη αφής του κινητού το...

...ώρα προβολής. Στην συνέχεια θα εμφανίζει μια πανοραμική εικόνα του αμφιθεάτρου. Απο εκεί ο χρήστης θα επιλέγει την θέση που θέλει με την οθόνη αφής του κινητού ...

Good morning, for my client i need to make an implementation on WooCommerce - on the store the client selects a product and then the website sends a query to the website - provide the number of products on the network. The system will then return a list of places with available quantities of a given product. The system API is in JSON format. An authorization token is required to execute the query.

...Please bid only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, par...

Necesito alguien que puede dar un curso de power Bi en 10 sesiones en total 15 horas por sesion es de 1 hora y media, 2 sesiones por semana martes y jueves de 4 a 5:30 de la tarde hora Guatemala. Empezando 23 de abril y terminando 23 de mayo. Alrededor de 15 personas, las sesiones son por google meet. Temas a impartir. Editor de consultas de Power BI Extracción de datos: Extracción vs Direct Query Conectar datos alojados en diferentes orígenes Enlazar datos desde la consulta Entorno de trabajo para modelar con Power BI Introducción al modelado tabular con Power BI Tablas y relaciones Power BI – Modelos de datos Iniciación a DAX Fundamentos DAX 1. DAX en la práctica 2. Columnas calculadas y medidas 3. Tablas Calculadas ...

I am seeking a developer with intermediate level experience IOS Swift. The task will be to help me get the example code working from the documentation at This is my first time working with IOS and the docs leave out some of the implementation. For example, in this code there is not map function, only "..." Bids under £70 only please. ``` var totalUsageByCategory: [ActivityCategory:TimeInterval] totalUsageByCategory = (…) ```

I'm looking for a tech-savvy individual who can help me set up my Google Nest Audio Wi-Fi speakers. Key tasks include: - Connecting the speakers to my home network - Troubleshooting any potential connection issues You should have prior experience with setting up Wi-Fi enabled speakers and be comfortable working through potential connectivity problems. Familiarity with Google Nest Audio in particular would be a huge plus. Look forward to working with a skilled individual on this small, yet crucial project.

...City Streets, We've Got Your Home Covered." 6. "Turning Louisiana Houses into Homes, One Family at a Time." 7. "Where Louisiana Living Meets Expertise: Nicole Spellman Group." 8. "Louisiana's Heartbeat: Let's Find Your Perfect Home." 9. "Nicole Spellman Group: Your Gateway to Louisiana's Best Properties." 10. "Making Louisiana Real Estate Easy – Let's Get Started!" 11. "Find Your Louisiana Love Nest with Us." 12. "Navigating Louisiana Real Estate, Simplified." 13. "From Shreveport to New Orleans, We're Your Louisiana Connection." 14. "Nicole Spellman Group: Where Home Dreams Come True." 15. "Louisiana Living Starts Here – Let's Begin Y...

I am looking for an experienced React Native developer who can develop a functional driver app for both iOS and Android platforms. I already have UI screens, however, are open to guidelines and suggestions. The Primary function of the app ...should have: - Proven experience in React Native Development - Proficiency in working with both iOS and Android platforms - Excellent understanding of GPS integration and real-time notifications - Ability to work with provided UI screens and enhance functionality - Expertise in payment processing integration. I'm excited to see how your skills and experience match this project. If you have any query or suggestion please let me know. Looking forward to collaborating with you. Note : There are 20 UI Screens and we put a 150 Rupees per s...

...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.

Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...

...activate the account. - **1.2 Login** - Users must log in using their registered school email address. - The system should provide password recovery options. #### 2. User Dashboard - **2.1 Access** - Upon successful login, users are directed to their dashboard. - **2.2 Features** - A search box to look up universities by name. - A list of universities should appear based on the search query. - Users can select a university to view more details. #### 3. University and Course Interaction - **3.1 University Selection** - After selecting a university, a list of available courses is displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...

FOR MELBOURNE BASED FREELANCERS ONLY I am a finance professional with over 30 years experience in the investment markets. I need an experienced tutor in Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The complet...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow co...

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the y...

...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...

I am ...view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

...printed directly on the board, where kids can draw lines connecting food items to the alligator. - Habitat Description: - A black and white map showing alligator distribution in the US, with certain areas left blank for students to fill in with patterns or textures. #### Panel 3: Offspring & Interesting Facts - Header: “Alligator Families and Fun Facts” - Provide outlined images of an alligator nest, eggs, and baby alligators for coloring. - Interactive Question: "What do baby alligators eat?" Include a small, outlined wheel that students can spin after coloring each section with possible food options. - Fun Facts: - Create bubbles with fun facts that are written in a large, clear font. These bubbles can have borders or backgrounds that students can col...

I need an experienced freelancer to replicate the design, layout & structure from an existing website to serve as a starting point for our own site. Key tasks involve: - Implementing the structure or an an existing example website on Wordpress. This includes the pages, placeholders for posts, menu structure, etc. - Utilizing Spectra blocks/Kadence theme, contact form 7 Ideal candidate should have strong skills in Wordpress and Spectra/Kadence theme implementation. Please include examples of past work in your application. You will be working from a clean Wordpress install.

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...

... Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The votes are expected to be collected as per IP, hence, experience with IP-specific data handling is highly desirable. In summary, I need a Laravel and MySQL expert to revamp our online voting architecture for seamless perfo...

...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers

...as peer the dashboard screen provided in figma file. The dashboard and others menus must be created in dynamic way as its menus items and widget in dashboards are different according with the user profile. - Menus and Submenus: The SaaS web app has about 18 screens that allow user to interact with some operations like add a new financial product, query data in tables or grids, update and delete data. All this screen must have filters for query and pagination capabilities. - Data Analytics and Reporting: It's essential that the platform has the capability to collect and analyze data, and present these insights in a user-friendly manner. Further details: - The design of the application should be sleek, intuitive, and responsive and must follow the figma design that...

Hi Quick Website SEO, I noticed your profile and would like to offer you my project. We can discuss any details over chat. We discussed over hat about about the SEO services I need since we worked together in the past.

I'm in search of an experienced MS SQL professional who can provide online training that covers from intermediate to advanced concepts. This will focus particularly on, but not limited to: - Database Administration - Query Optimization - Stored Procedures Ideal Qualifications: - Proficient with MS SQL - Previous experience in teaching or training - Ability to explain complex concepts in a simple, understandable manner - Capable of tailoring the lessons to my specific needs No preference on the tools or software versions for the training as the focus is more on learning the subjects rather than mastering specific tools. Feel free to propose the platform or versions you are most comfortable teaching with.

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what SQL databases can achieve together!

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

...programming expert, proficient in either Ruby or Python, with intermediate-level ElasticSearch querying capabilities. The primary task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CS...

...improvements to my existing Laravel application. The selected freelancer will be responsible for: - Backend Development: Your skills should allow you to work efficiently on my application's backend, ensuring all new integrations are seamless. - Database Optimization: I am specifically looking for you to boost the performance of my existing application by optimizing the database, which includes indexing, query optimization, and normalization wherever necessary. - API Integration: Your experience integrating APIs will be crucial, as a key part of this project will involve utilizing various APIs to extend the functionality of the application. - User Interface Improvement: The right candidate will not solely focus on the technical side, they must also be able to make necessa...

We're developing a scanner app coupled with an query response system. Seeking a Flutter expert with Django knowledge for UI and backend development, respectively. The ideal candidate will excel in Flutter UI design and possess the skills to manage data storage in Django backend, along with handling API integrations seamlessly.

Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other

...require: Features: - User Registration and Authentication: Proficiency in handling user data securely and maintaining user privacy is necessary. - Search Functionality: The website should include essential features such as Full-Text Search, Faceted Search, and Auto-complete/Suggestions powered through Elastic Search. The capacity to execute comprehensive indexation, accurate retrieval, and fast query processing is crucial. - Responsive Design: The site must be mobile-friendly and capable of rearranging its layout based on the user device screen size. Design Style: - Modern: The web design should align with the modern style. Minimalism, adaptive grids, and scalable graphics are what I'm looking for. The design should be functional yet aesthetically pleasing and user-friend...

...scheduler on my website. Your mission will be to set up API calls to request data specifically for certain resources. Key Skills/Knowledge required: - Familiarity with API integration - Experience working with DevExtreme scheduler - Strong understanding of data request and retrieval The job requirements are as follows: - To be able to query the api for scheduler data and present it. The API is already available and I can modify it at any time. I simply need to query it and present the 3 consts (tasks, appointments and assignees). Kindly note, the type of data to be retrieved and the presentation style for this data in the scheduler are yet to be defined. Your input and suggestions during this phase would be highly appreciated. Please place your bid and let's di...

...particularly in creating data visualization platforms. - Proficiency in real-time data integration. - Database integration - API integration - Search Engine Optimization - Query Optimization - Postgre Notes: - We have a website template that includes code for both the backend and frontend. You would just need to customize it. This is what the template looks like: - Although the template at the link looks like html, we have paid for and downloaded the django code - We have provided two screenshots of part of the django and reactJS code as an example of the code in the template - Our database (for stationary data) is postgre hosted by Supabase - Any real-time data will come from a third party's Rest API - Our website

I need an EXPERIENCED Javascript developer to write me a custom React fetching mechanism. Use the Tanstack library to write me a custom hook that can fetch data and cache it too. These features should be implemented: - Assume API call always returns an array of data. - I can pass a modifiedFrom query param which is just a string ISO date. 1. Fetch the data using the cached lastFetched date for that key/api call 2. Mutate the result in the stored cache and updated the lastFetched date in cache 3. Allow data to be cleared from cache after an x time

I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertl...robust backup and recovery strategies, thus to ensure database availability and consistency at all times. - Security Management: Protection of data is paramount, and as such, I require a comprehensive security configuration to guard against unauthorized access or data breaches. - Database Optimization: I'm looking to increase the efficiency of my current database setup. It involves improving query performance and optimizing database storage with a focus on increasing system scalability. It would be best if the candidate is proficient in Oracle and MySQL and has hands-on experience dealing with performance issues, backups, s...

...queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures handling multi-table JOIN queries. GetInvKardexPorLote rows : 10924, max : 96'' GetKardexInventario rows : 4931, max : 72'' GetLibroAuxiliar rows : 3007, max : 94' Ge...

I'm looking for a seasoned PHP and MySQL programmer to establish the architecture of a ranking system for my multiplayer gaming site. Tasks will include but are not limited to: - Database design - Data modeling - Query optimization The ranking system will make use of user ratings, vote counts, and engagement metrics. The ideal freelancer for this project should have ample experience with ranking systems and must exhibit prowess in PHP and MySQL, with a keen understanding of database design, data modeling, and query optimization. Familiarity with gaming sites is a plus. Let’s build a competitive gaming environment together.

...I can fix this for myself so I don't run into this problem again. • If you have a knack for teaching complex concepts in a simplified manner, you are the perfect fit. I wish to understand this aspect deeply, hence it'll be a bonus if you can assist in creating a workflow that I can follow to understand and execute similar tasks in the future on my own. Let's enhance my Fusion 360 skills one query at a time....