|
|
|
|
|
|
10 Replies and 10299 Views
Information for acactivity 10299 10
Started by Ruma Malhotra
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 whe...
|
|
|
|
10 |
10299 |
by Ruma Malhotra 01/30/2009 11:49 AM |
|
1 Replies and 18295 Views
Loading inside Lawson Portal 18295 1
Started by Deleted User
I have Smart Notes sending out emails to employees to fix various issues. In these smart Notes I have included a link to the Lawson Employee Self Service page they need to use. However it will just pull up the page directly. I would like it to load the page inside the Lawson portal. Is there a way to do this
I was hoping there would be something like
http://LawsonServer/lawson/portal/redirect=lawson/xhrnet/some_page.htm
Thanks.
|
|
|
|
1 |
18295 |
by John Henley01/30/2008 12:47 PM |
|
0 Replies and 741 Views
Language Translator 741 0
Started by thummel1
In certain smart notes we need to offer the option for employees to translate the message in the smart smart note to a different language. Has anyone included a language translation option into any of their smart notes
|
|
|
|
0 |
741 |
09/09/2020 5:39 PM |
|
0 Replies and 1395 Views
Create Smart Note to capture PR116 job 1395 0
Started by thummel1
I am attempting to capture all pay records updated via a PR116 and deliver a Smart Note to employees to confirm they have had a scale increase. Is there a way to isolate for only the records updated via a PR116 I was hoping there is a table that can intercept the data before PR116 is processed, capture the date after PR116 is processed, but be able to isolate for only those records that tie to that PR116. Thoughts
|
|
|
|
0 |
1395 |
05/22/2020 11:58 AM |
|
1 Replies and 5233 Views
Infoset Query String errors out 5233 1
Started by thummel1
I have an SQL Statement that successfully runs in SQL Oracle, but when I add it as an Info set in the Smart Notification tool I receive the following error message: 'Error: ORA-01756: quoted string not properly terminated'. I have double quotes around all my column headers. I also have single quotes around any strings that are part of case statements. (e.g. case when x = 'ABC' then 'Pass' else 'Fail' end as 'Test') My SQL is almost 2500 rows, with very complex case statements. Some strings...
|
|
|
|
1 |
5233 |
by thummel108/21/2019 4:50 PM |
|
7 Replies and 2679 Views
Infoset as Attachment? 2679 7
Started by thummel1
Hi, we are on LBI V10. I am looking for a creative way that will allow data to be sent as an email attachment in a smart notification outside of the organization. Ideally, I'd like to convert the data generated from an Info set to an Excel or CSV document, include it in the notification as an attachment versus in the body of the email, and deliver to the recipient. All creative ideas are welcome, thanks, Tania H
|
|
|
|
7 |
2679 |
by Dave Curtis07/09/2019 12:58 PM |
|
0 Replies and 867 Views
Smart notes to Mobile devices 867 0
Started by thummel1
A law recently went into effect requiring new employees receive certain information on their first day of employment as well as confirmation of receipt of this information. For existing employees, they must receive information 'in advance' of the change, although no confirmation of receipt is required. Ideally we would like to leverage functionality within Lawson to deliver this information electronically, and for the new employees, build in the functionality to allow them to respond electro...
|
|
|
|
0 |
867 |
07/08/2019 2:47 PM |
|
1 Replies and 1139 Views
Header row not lining up in SN email 1139 1
Started by texasInstruments
I am trying to send a simple email with changes/deletes. I have the process working now but for some reason even when I am not using a Template I am still seeing the data come over in a table that does not have header/data lining up. When I send the email as plain text, I can see the html tags....how do I just get the header and data in alignment in an email
|
|
|
|
1 |
1139 |
by Dave Curtis05/08/2019 3:34 PM |
|
0 Replies and 956 Views
Pending Action Reasons Table Name TM 956 0
Started by thummel1
I am creating a Smart Note that points to Talent Management that will deliver to any employee who is terminating from the organization. We would like to exclude pending terminations where the reason for terminating is involuntary. My understanding is that the S_EMPL table stores the pending actions; however, this table does not appear to store the pending action reasons tied to the action. What is the name of the table that stores pending action reason codes that tie back to the pending actio...
|
|
|
|
0 |
956 |
02/26/2019 3:43 PM |
|
6 Replies and 10878 Views
Formatting of Blank Dates in Smart Notification 10878 6
Started by Kay Hamill
I am new to Smart Notification and am writing a query that returns a date field where some of the dates are not populated.&160; I am using a JDBC connection against an Oracle 10 database.
The records with the blank dates are returned to the infoset as 1/1/1700.&160; I know when I run the query directly in SQLPlus, that tool returns the date as 1/1/2000, but I know that in Lawson the date is unpopulated.
When I write the Notification, I see the 1/1/1700 populating there as well.&160; Is ther...
|
|
|
|
6 |
10878 |
by thummel102/07/2018 11:03 AM |
|
4 Replies and 4086 Views
Align Columns 4086 4
Started by Randy
Can't seem to get the syntax right to align the columns in SN. Admin manual say's it should look like this for column 1. Not working. colopt1|align=center&colopt8=no
|
|
|
|
4 |
4086 |
by Randy12/13/2017 2:52 PM |
|
2 Replies and 4431 Views
Deliver LBI report in Smart Note 4431 2
Started by thummel1
Hello, is it possible to deliver LBI reports in a designated format (e.g. Excel, PDF) as an attachment in a Smart Note The goal of this would be to eliminate a step where certain staff are tasked with running an LBI report, exporting, saving, and emailing to other customers within the organization that do not have LBI security access. Just wondering if Smart Notes have this type of functionality
|
|
|
|
2 |
4431 |
by Mark Petereit11/01/2017 6:54 AM |
|
0 Replies and 1241 Views
Changing ownership of Smart Notes 1241 0
Started by thummel1
We recently upgraded to V10. I was tasked with migrating all smart notes to V10. In the process, I became the 'owner' of all smart notes. My colleagues can no longer see any Notifications. In some cases, I have full editing rights of other's notifications, and in other cases I do not have editing rights, and the original publisher cannot even see them, thus no one has editing access to some of these notifications. We have instructions that explains how to change ownership of notifications, w...
|
|
|
|
0 |
1241 |
07/17/2017 10:57 AM |
|
0 Replies and 1252 Views
Migrating Data Sources 1252 0
Started by thummel1
Hi, is there an easy way to tell if when I created a Smart Note Solution Pack, if I accidentally did not uncheck 'Include Data Source Details' under Data Source options I am wondering if that detail would reside in any of the XML documents that are saved in the solution pack and if so, how do I find that (since I am not an expert at XML language).
|
|
|
|
0 |
1252 |
05/24/2017 12:11 PM |
|
0 Replies and 1277 Views
Confirmation of Delivery Device 1277 0
Started by thummel1
Hello, I have an email I set up as a delivery device for Smart Notes; however, the email confirmation is not being delivered to the recipient. We noticed the email address if 48 characters. Does anyone know if there is a character limit when delivering Smart Notes to customers Thanks!
|
|
|
|
0 |
1277 |
04/18/2017 4:33 PM |
|
0 Replies and 1190 Views
CSV as Data Source for SN 1190 0
Started by thummel1
Hello, looking to use a CSV file as a data source for smart notes. The SN would need to look for null values in a string field. Eventually, there may be more conditions to look for (e.g. Column 1 is null, or, Column 2 = Y and Column 3 = No). Is this possible conceptually I was able to set up a CSV file as a data source, but am stuck here and have several questions such as: When I update the Info Set it returns an 'errors' message, but I can still preview the data Do I need to create a measu...
|
|
|
|
0 |
1190 |
03/20/2017 10:41 AM |
|
1 Replies and 4291 Views
Stop Smart Note when no Data 4291 1
Started by thummel1
Hi, is there a way to stop a Smart Note from emailing to the Device if the Info Set did not return any data THE Smart Note is set to generate 'When Data is Updated' in the Delivery options The report is scheduled to run daily, but the end user does not want to receive a notification when no records are present in the Info Set. Thank you,
|
|
|
|
1 |
4291 |
by SaraP11/18/2016 11:59 AM |
|
0 Replies and 2195 Views
Template and Smart Notes 2195 0
Started by thummel1
Hi, I am on Lawson version 9.0.1. We have a Smart Note that gives us a list of individuals each day. The Smart Note is the only way we have to get at the new 'keys' that are added to this table each day (PERSACTION), We need the data for each individual to populate onto a form that we have designed. The form was designed in MS Word. Is it possible to have this MS Word form(or it's 'look') loaded as a template LBI, and add the data for each data field in the corresponding 'spot' on the form, so t...
|
|
|
|
0 |
2195 |
09/15/2016 10:35 AM |
|
0 Replies and 1514 Views
Excel as a Source 1514 0
Started by thummel1
Is it possible to use an Excel spreadsheet as a data source for Smart Notes We have some processes managed this way and we've been discussing ways to send alerts to managers that appear on the spreadsheet when certain conditions are met. A Smart Notification would be a great way to deliver the message. Thanks!
|
|
|
|
0 |
1514 |
09/07/2016 10:50 AM |
|
0 Replies and 1420 Views
Define Info Set Issue 1420 0
Started by thummel1
I am building a Smart Note to generate to managers. The SQL executes in SQL Developer. Form there I copy/paste the SQL into the Info Set in 'Step 1'. When I advance to Step 2 of the Info Set setup, when I click on the 'Auto-Create' option, nothing generates. I have manually added each column and saved the meta data successfully. When I 'update' the Info set, it says it returns 1 record (And should be appx 13 as SQL Developer and the 'preview' displayed) but when I preview the 'sample' after the ...
|
|
|
|
0 |
1420 |
09/06/2016 12:47 PM |