ITCanopy

Go to Contact for which you want to mute ring tone: Touch on Default Ringtone and select None . When this contact calls you will not hear ring tone, but if you have enabled vibration or mobile is in vibration mode you mobile will still vibrates.

Below query will return column details: SELECT COL.ROW_ID AS 'Column Id' ,COL.NAME AS 'Column Name' ,COL.LENGTH AS 'Column Length' ,TAB.NAME AS 'Table Name' FROM S_COLUMN COL LEFT JOIN S_TABLE TAB ON TAB.ROW_ID = COL.TBL_ID WHERE 1=1

Add below in your SQL query and it will get date difference and convert into years: (DATEDIFF(MONTH,TABLE.BIRTH_DT,CURRENT_TIMESTAMP)/12) The DATEDIFF() function returns the difference between two dates. DATEDIFF(Interval, date_1, date_2) The CURRENT_TIMESTAMP() function returns the current date and time. SELECT CURRENT_TIMESTAMP()

Add below in your SQL query and it will subtract date column from today's date and convert into days: CONVERT(INT, GETDATE() - TABLE.CREATED_DATE) AS 'Age' OR DATEDIFF(DAY,TABLE.CREATED,GETDATE()) The GETDATE() function returns the current database system date and time. SELECT GETDATE() The CONVERT() function converts a value (of any type) into a specified datatype. CONVERT(data_type), expression/ value) SELECT CONVERT(INT, 1.1) The DATEDIFF() function returns the difference between two dates. DATEDIFF(Interval, date_1, date_2)

For getting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set SessionAccessService in Business Service Name. Set GetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Add Profile Attribute name against Name input argument. Go to Output Arguments and set the arguments as below: Add Process Property name in which you want to get Profile Attribute value.

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set  SessionAccessService in Business Service Name. Set  SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.