PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 01/30/2009 11:49 AM by  Ruma Malhotra
Information for acactivity
 10 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Ruma Malhotra
Private
Private
Veteran Member
(1092 points)
Veteran Member
Posts:412


Send Message:

--
01/27/2009 1:04 PM
    I am trying to create a smart note for activity management that notifies a user whenever a new activity in the project and activity management system is created.

    Looking at the ERDs on this site for activity management, there is a table acactivity that has all activity information for each activity created in the system. Looking at the technical documentation for this table there is a field that says acv_date_created which gives the date the activity was created in the system.

    However when you connect through OLEDB to this table this field is not present.

    Is the technical documentation updated or is it for an older version and is there any field that gives the date a new activity was added to the system. this date cannot be the begin date and the end date because these 2 dates gives the dates when an activity can begin and end accepting transactions.
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/27/2009 1:11 PM
    I will not be able to use acaudit since we did not have audit history turned on.
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    01/27/2009 1:21 PM
    Ruma,

    What if you connect directly to the database? Do you see it then? acactivity is a standard table and you should be seeing it from the OLE DB Query Builder. Are you sure you have rights to see it?
    If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/27/2009 1:28 PM
    Hey Matt,

    I first connected through ODBC and I have access to all tables in lawson and I was not able to see it. then I used the schema browser on toad to look at all the fields and I could not see it there. Finally I looked through OLEDB and I cannot see it.

    Are you able to see it?
    David Williams
    Private
    Private
    Veteran Member
    (3022 points)
    Veteran Member
    Posts:1018


    Send Message:

    --
    01/27/2009 1:58 PM
    If you look up the ACV table with MS Add-Ins, what table does it indicate the field belongs to? Do the other fields for these records also belong to the ACV table?
    David Williams
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    01/27/2009 2:02 PM
    There are ERDs specific to various major versions (8.0, 8.1, 9.0).
    ACV-DATE-CREATED is a new fields in 9.0 apps, so if you are running an older version that would explain why you can't see it.

    BTW, I think you're using the wrong tool for this--you should be using ProcessFlow. There is already a service defined that can be triggered when an activity is added.
    Thanks for using the LawsonGuru.com forums!
    John
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    01/27/2009 2:03 PM
    Yes, Im seeing that table from both the schema browser and Lawsons OLE DB query builder. What specific build of AC apps are you on?
    If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/27/2009 2:17 PM
    We are on version 8.1 for apps but 9.0 for environment and maybe that is why i am not able to see the field.

    If this is in processflow and since we have a backlog for processflow I may just create the smart note till we have the processs flow in place.

    I don't know what else field to use for 8.1 apps. Any other ideas?
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    01/27/2009 2:34 PM
    you could do a select statement of your Project and Activity and whatever other information, then in Step 2 you can do a condition to look for New Items. This operator can be a little tricky but used right it may give you what youre looking for.
    If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
    John Henley
    Private
    Private
    Senior Member
    (9563 points)
    Senior Member
    Posts:3205


    Send Message:

    --
    01/27/2009 2:58 PM
    I'm not aware of any other place it is stored in the database. You can do a differences approach in LSN to send notifications for new records in the infoset. Not sure how/what your requirements are, of course.
    Thanks for using the LawsonGuru.com forums!
    John
    Ruma Malhotra
    Private
    Private
    Veteran Member
    (1092 points)
    Veteran Member
    Posts:412


    Send Message:

    --
    01/30/2009 11:49 AM
    Thanks Matt and john for your replies. We may not be able to use "The new items" in the second round since any change to an activity will also generate a smart note. We would be flooded with smart notes since we have more than 2000 activities built and there are constant changes to these activities as fas as the date range status, budget etc.

    I may just wait till we upgrade to 9 apps before creating this sn unless someone cries louder.

    Thanks anyway for all the help.
    You are not authorized to post a reply.