which AXL to get  Line CSS

Version 1
    This document was generated from CDN thread

    Created by: Nattawut Boonpramook on 19-09-2008 07:13:20 PM
    which one i shoud look in to ?

    Thanks

    Natta

    Subject: Re: which AXL to get  Line CSS
    Replied by: Madhukar Bhandaryr on 23-09-2008 02:19:34 PM
    I was not sure about the version;

    Checked in CCM version 6.1

    The tag name for updating the CSS for a line is
    shareLineAppearanceCSSName/CSSId. You can also use updateLine API.


    Using ExecuteSQLQuery API

    The query would be
    "update numplan setfkcallingsearchspace_sharedlineappear = 'pkid_of_CSS_in_CSSTable'
    where
    dnorpattern='directory_number' ".
    The pkid in CSS table can be found
    with the query "select pkid from CallingSearchSpace".

    HTH

    Thanks and Regards,
    Madhukar

    Subject: Re: which AXL to get  Line CSS
    Replied by: Nattawut Boonpramook on 30-09-2008 07:41:21 AM
    Madhukar, Thank for ur answer ...

    your reply is kind of update the css on the specific line... what i need to achieved is to get what css was configured on the line.... is there any example ?

    Rgds,

    Natta

    Subject: Re: which AXL to get  Line CSS
    Replied by: SENOL KARAHASAN on 29-12-2008 12:59:21 PM
    Hi all,

    you join two tables, dnorpattern and callingsearchspacetable and it is like that

    SELECT
    CallingSearchSpace.name
    FROM CallingSearchSpace
    INNER JOIN dnorpattern ON
    (CallingSearchSpace.pkid = numplan.fkcallingsearchspace_sharedlineappear)
    WHERE
    numplan.dnorpattern = 'XXXXXXXX'

    I hope this will be help you,

    Thanks,
    Bilgehan.

    Edited by: SENOL KARAHASAN on 29.Ara.2008 08:00