By using this web site, you agree to all terms and conditions for acceptable use.

ServiceLedger KnowledgeBase Knowledgebase Home Page > ServiceLedger > Technical | Contact Us

Search the Knowledge Base Browse by Category

ServiceLedger provides this content as-is for self help support purposes. ServiceLedger assumes no liability for any steps you take based on the directions in our knowledge base, and assumes that you have the knowledge to determine whether a given step is appropriate for your situation. Certain solutions can affect third-party software that ServiceLedger relies on or integrates with; it is your responsibility to consult with the documentation or publishers of such third-party software to understand whether any changes suggested here will have negative effects on other applications.


Common ServiceLedger SQL Commands (Advanced Users Only)

Would you like to...

Print this page
Email this to a friend

THE FOLLOWING INFORMATION IS SUPPLIED FOR INFORMATION PURPOSES ONLY.  USERS SHOULD NOT PERFORM THESE PROCEDURES AND THEY SHOULD ONLY BE PERFORMED BY QUALIFIED SERVICELEDGER PERSONNEL.  ANY ATTEMPT TO USE THIS INFORMATION WITHOUT SERVICELEDGER'S KNOWLEDGE MAY COMPROMISE THE INTEGRITY OF YOUR DATA.

Common Search Commands

select * from ticket where ticket_id = 'xxxx' - search the ticket table to find a specific ticket for modification

select * from entry where entry_id = "xxxx' - search the entry table to find a specific entry for modification

select * from ticket_item where ticket_id = 'xxxx' - search the work order invoice charges for a specific ticket.

select * from client_quote where client_quote_id = 'xxxx' - search the quote table to find a specific quote

select * from client_quote_item where client_quote_id = 'xxxx' - search a specific quote for items associated with quote.

COMMON TABLE AND ENTRY ID'S

company_user / company_user_id

resource / resource_id

client / client_id

client_location / location_id

client_quote / client_quote_id

ticket / ticket_id (common - ticket_item, entry, ticket_equipment)

equipment / equipment_id

item / item_id

invoice / invoice_id (common - invoice_item)

agreement / agreement_id

task / task_id (common task_item)

project / project_id

purchase_order / purchase_order_id (common purchase_order_item)

bill / bill_id (common bill_item / bill_id)

payment / payment_id

 

 


Related Questions:

Attachments:

No attachments were found.


ServiceLedger KnowledgeBase Copyright © 2019 support.serviceledger.com
Powered by AcitveKB Knowledgebase Software