Hello, this is my first post in this forum, but I haven't been able to find any answers anywhere else. We are pretty new to smartnotes, but have been using them for a while now. Lately all the scheduled infosets have been in the 'queued' status for a few days, and therefore they will not update. The update / process queue status option reveals the queue, but neiter 'queue' nor 'cancel' will change any status (cancelling one will just give a msgbox  'Set state for xxxx to 4' but no changes occu...

Can anyone advice on how we can use a Smart Notification to HR and/or Payroll when an employee changes their address through ESS We can't rely on the email notification set up in HS07 because we're on Windows so it only gets sent if the user hits the send button. Also, not all our users have email, so it may not even come up for some users. Thank you.

Have an infoset that has data populated for one notification. Would like another notification on the same data, but with a condition (when FIELD=XYZ). But that field is not a measure so it does not show in the available columns when you open the condition tab in the new notification. Instead of having to build a new infoset that is a subset of another infoset - how can we do this

Has anyone ever successfully used merged rows or merged columns in the Notification conditions I'm trying to link two infosets on username from two different data sources.

I would like to include the link on the bottom of the Smart Note that has the option to export to a spreadsheet.  I know that this can be done by updating the template to inlcude the [tools] token; however I ONLY want to include the options View as an Excel Spreadsheet View as an Microsoft Excel spreadsheet with no formatting Is this possible If so how

I have a smart note that has been in production since January of this year and rendered on the dashboard. So this smart note is not delivered to any user but is scheduled to refresh every first of the month on a dashboard and rendered on the dashboard. It essentially behaves like a report. Where can I find the historical instances for this smart note. I would like to publish all the instances every time the smart note refreshed just like the historical instances for a report. Is there a wa...

Can anyone share the setup for using an oracle stored procedure with Smart Notifications.  How is the procedure set up  (With a package, returning a cursor like Crystal) What is the syntax of the call on the Smart notes side

Is there a way to change the order of fields in a notification after the infoset creates the fields in a certain order without changing the query Thanks in advance.

I am trying to build a smart notification using the activity management piece in Lawson, and I was wondering if anybody can think of a better way to do this:   My infoset has a budget, a commitment and actual amount. I am supposed to notify a user when the expense spent on a project reaches a threshold value which is 5 of a budget.   My expense equals the actual and commitment amount. I have added an calculation column in my sql which is called the remaining amount which is ( budget – (actu...

Does anyone have a good example they can share of an LDAP query from Lawson's LDAP that was used to build an info set Trying to build a dataset of users and emails to utilize for bursting....All queries I'm trying come back with no data....

Anyone have any luck with setting up an infoset that refreshes at a smaller interval that one hour I don't think that you can modify the cron expression in the QRTZ_CRON_TRIGGERS table like you can a true cron job. I know I can create something to simply call the url to do the update/process of the infoset. Just wondered if there was a more 'native' way to handle this...

I am unfamiliar with any way to accomplish this - and I've communicated that I don't believe we can do this - but thought I would ping the gurus to validate. Have a SN on a dashboard - and can successfully filter this based upon the user that is logged in. But by default we will show all items. Assume we have a SN that has a column like Process Level - the desire is to somehow allow the user to put in a value to filter out that PL. I'm not aware of any way to do this....other than creat...

Anyone know physically where the infoset data is stored Is it a blob in a table and I'm just missing it

Since the end of february 2011 we are live with M3. We have build different Smart Notes for our users. For instance we have one Smart Note that burst to different people and the same Smart Note we also used on the dashboard. The Smart Note on the dashboard contains all records and the bursting Smart Note contains only the records which belong to specifically to the field we burst on. We used the Smart Note with a Infoset which we have scheduled. The settings of the scheduler are Update/Pro...

I have change something in the layout of a smart note.   For the Smart Note “Gemuteerde orders na handmatige vrijgave”  I added additional text in the instruction box.   The changes are made on 08 march.   Today I checked of the changes are also visible on the dashboard in Smart Office.   For some reason the additional text is not visible on the Dashboard of Smart Office.   Did you know what I have done wrong. Because the data is up-to-date

Hi All, We have imported a user delivery device for a new user who will be receiving a smart note.  The physical delivery device is their email address.   After the import, their delivery device is in an “Enabled” status. I “force-subscribed” the new user to the smart note by following the documentation in the user and admin guide and by using the “Group Content Subscription Tool”.   I have force-subscribed this notification to other users by using this same procedure. The user that had their...

Just curious about opinions. Given that you have access to use JDBC data source....DME vs SQL Why

Have a SN displayed in the dashboard with an infoset that has an application link. The SN is being displayed as the content of a module within the dashboard. When a cell is clicked the app opens, but only contained within the module. Have not been able to find a way to have this open in a new window or outside of the constraints of the module.

Did somebody have experience with application links for M3 in Smart Notifications when the email is received in the Inbox from Outlook. When the user click on the link M3 nothing happend in M3. The link open an Inter Explorere page and another page. I want when the user click on the link M3 starts the program with we send with the link.

I have created a smart notification for unposted journal entries and would like the user to release them for the email the user receives. However I am getting an error 500 when this action is taking place. Has anybody done this what am I missing

I have a SN with Employee Reviews - and have it linking to PA26. I've got PA26 defined in lawson.xml with company and employee - and the link does open PA26 successfully, but it is not populating the COmpany or Employee fields nor inquiring. I've got those two fields spelled the same way in the infoset - and both defined as key fields. In the application link I'm calling the Forms class with the tag of PA26 (like it is in lawson.xml). Isn't this supposed to work Or do I have to do this as...

Hi, I have access to query the SQL Server database that holds the meta information for our smart notifications.   I am trying to find the table/column that holds the email address of a registered delivery device.  Does anyone know the name of the table and column that holds this information   I have not had any success in finding it.  I thought it might be in the ENPBATREE table.  However, I am not seeing the delivery device that I created for myself. Regards, Tim

Using the solution builder can you transfer notifications from one environment to another. I know you can transfer infosets, devices and templates but not sure of notifications. Does anybosy else have any other ideas as to how to do this without having to rebuild the notifications from scratch when you go to another environment tia.

The current smart note I have is notifying users when GM10.2 templates are added for specific employees. Via either the 'details' link on the line item or a custom link I would like to access the GM10.2 portal form with the company, employee, and effective date populated. Can anyone help me accomplish this I am new to smart notes and would really appreciate any help someone can offer. Thank you, Tina Dosal

I am trying to create a SN that sends an email when a social security number has been changed. I have the InfoSet created; when I try and do preview it clocks out b/c the data set is too large. I'm not sure if that's a problem or not. I set up the notification and when I get to conditions, the 'compare with ...' section is not available. I want it to say 'if SSN has changed, send SN'. I have made the SSN a key and currently have my criteria set to send a SN if any changes to keys occur. ...