I need to someone to help me create a dynamical data structure query in MySQL, with an output from parent to child, as the following: Level | ParentID | ChiledID Output notes: - The results must be in the same order as you see in the excel file. - The query must get the output dynamically. For example, when I insert new level into the table
Install Scalable Voip Platform Including Asterisk, a Sip Router a Billing System. The install...Openser or OpenSips ) Split for incoming and outgoing calls Asterisk Realtime (4 instances) Billing System (A2Billing or Suggested alternative) CRM (Vtiger, SugarCRM or Other CRM) MySQL Database (Master/Slave) System Testing Tools Security Tools
Hello! Need help to build a laravel query. I'm trying to access the latest messages from a table with content: message_id -> incremented value from_id -> can be either $userId or another id to_id -> can be either $userId or another id message -> the message created_at -> timestamp A user's user id can appear in both the to and from column
...this to use database query results. I only have basic web development experience. I just need help adding these database results... <?php $connect = mysqli_connect("localhost", "user123", "pass123", "page_list"); $query ="SELECT page_name, page_url FROM page_list ORDER BY page_name"; $result = my...
We use Office 365 for e-mail and would like to have custom reports for auditing mailboxes. O 365 provides a way to connect and extract the data we want. We'd like the database to contain a table of mailboxes that list the features and permissions they should have, that can be compared against what is actually in O 365, then report on discrepancies
We provide court reporting to law firms for depositions and hearings. These law firms must use the court reporting agency that has contracted with various insurance carriers. We need a salesperson who can reach the right people at these insurance carriers who have the power to contract with us.
I want to make a Round Robin configuration setting in the Kannel for the below message sending given that I have 2 SMSC(SMSC0 and SMSC1). When no SMSC is present in the query string, I like to use SMSC0 and SMSC1 in a Round Robin fashion. This is something like making a Default SMSC setting that will handle those things not explicitly handled by any
Need to add some reporting capabilities to simple [url removed, login to view] app
We use osTicket for our support tickets, but we would like to have it integrated with our CRM so we won't have to replicate the ticket there. This is what we need to integrate: - When a new ticket comes in, it should go to our CRM and create a ticket associated to the Lead, Account or Contact that has the same email address associated to that ticket in osTicket - When a ticket closed in ...
...currently have a MySQL Geometry database which is filled with MultiPolygons. I need to retrieve all polygons within a certain radius (for example 100km) of a given point. I looked at ST_Buffer but not sure if this will work. All I need is someone to make the query for me and for it to work. To give you the table names for this query, please see below
Need SQL SERVER Expert Who can build a n level query for json data coming from multiple tables
Develop a Repository using for General Ledger Transactions. Develop a Dashboard with 3 pages 1) GL summary 2) GL Transaction Detail 3) GL Trial Balance User should be able drill down from GL summary to Transactions.
Hi, looking to develop BI reporting Tool for startup capl centre business. I need to generate reports analystics daily, weekly and monthly reports, ad-hoc reports. I need aomething like Microsoft Power BI or oracle BI Publsiher. Please let me know if abyone can make ot for us. Thanks!
An existing website needs new landing pages added to subdomain and the data/results of enquiry forms on the site pages to be passed to mailchimp and sugarcrm
Hello! We are displaying data from a mySQL 5.1 database on our website. In the past we used an SQL query to gather the following fields from a table: - first_name - city - state - profession - date_of_birth where the "status" field of the user was confirmed. In the past this was easy because all the users were stored in one table (wp_net_user)