Solved DataBase Example

Discussion in 'Call Flow Designer' started by agesen, May 29, 2017.

Thread Status:
Not open for further replies.
  1. agesen

    Joined:
    Oct 17, 2016
    Messages:
    18
    Likes Received:
    1
    Hi

    Anyone who can provide me with more information of the SQL database structure?

    An example for use with the PhoneSupportPortal Demo would be great.

    Thanks :)
     
  2. edossantos

    edossantos Support Team
    Staff Member 3CX Support

    Joined:
    Jun 27, 2007
    Messages:
    1,367
    Likes Received:
    109
    Hi @agesen,

    Did you check this article?
    https://www.3cx.com/docs/cfd-accessing-database/

    The database structure is whatever you define. Then you create the SQL query to access that specific database...

    Kind regards.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. agesen

    Joined:
    Oct 17, 2016
    Messages:
    18
    Likes Received:
    1
    Hi

    Yes I did check that article, but still facing problems.

    I have a MS SQL 2014 and created a Database named 'CustomersDatabase'

    In that I have a Table named 'customers' and a column named 'id'

    I have inserted 1 test PIN

    The sql syntax in the example "SELECT count(*) FROM customers WHERE id={0}" is returning a syntax error.

    What i'm missing here :)
     
  4. agesen

    Joined:
    Oct 17, 2016
    Messages:
    18
    Likes Received:
    1
    Hi :)

    I found the problem - wrong configured colum type

    Everything works perfect :)
     
    jed likes this.
  5. edossantos

    edossantos Support Team
    Staff Member 3CX Support

    Joined:
    Jun 27, 2007
    Messages:
    1,367
    Likes Received:
    109
    Excellent! Thanks for the feedback!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Thread Status:
Not open for further replies.