I am off to bed so I'll be a little sparse on the detail in this reply...
The DB view U__HPD_Help_Desk is an out of the box view, I only added a
column to it. That view and one for each of the other forms Change,
Problem, Work Order, Task, etc. also have similar out of the box DB views.
When all i
Thanks a ton Jason.
Also i will try to impalement it & will keep you posted on it.
One query -
Also after adding the custom column in "U__HPD_Help_Desk" is it mandatory to
add the dummy columns to every other view used in the Overview UNION view.
After that we need to simply add the new colu
Thanks a ton for your superb response.
Also regarding the DATEDIFF() - > please could you let me know that are you
calculating it for the difference between Submit Date & current date??
--
Sent from: http://ars-action-request-system.1.n7.nabble.com/
--
ARSList mailing list
ARSList@arslist
That is correct. Well, current timestamp (includes time too) The getdate
function in SQL Server (don't remember you saying which DB you are using).
https://docs.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql
"Returns the current database system timestamp as a datetime value without
4 matches
Mail list logo