Is there a way to limit the Company seen by a user in a Notification (based upon an InfoSet with multiple companies) when they view it on the Dashboard. User 1 can only see Company 1000 even when the Note has data for Company 1000, 2000 & 3000. I know I can limit what the user sees if I do Delivery - Bursting but can I apply this logic to when they view the Note from the Dashboard

I've seen a couple of old postings on this with no resolution so thought I would try this again. Looking for a way to burst the notification both in email and on the dashboard using the same notification. I believe I could do this with the same infoset but creating two different notifications - one for the email notificaiton and one for the dashboard, but with the dashboard using a parameter in the query. But I would rather have a single notification to manage. Has anyone been able to get thi...

i am brand new to Smart Notes and am trying to build my very first one. Yay! But, I kind of need instructions. I had training, which was a year ago, and I am finally applying that knowldge, which means I remembered nothing. Wondering if anyone has any type of Smart Note instruction manual or tips in a word doc that could at least get me started I am sure there is a book buried somewhere in my diesk, but I work from home and my desk is 26 miles from here, so I am hoping that somewhere, someone a...

Hi, I have a Smart Note that is scheduled to run once a week, each Wednesday morning. (I have the Info Set scheduled to run at 8am each Wednesday morning, as well as the Smart Note, which then get's delivered to me). It's designed to compare the prior week's Info Set with the current week's info set and only display the records where there are new keys. My Smart Note is including records that, according to another older query we run out of MS Access, is including records that were already o...

Have a Notification Named 'Benefit Documents Not Submitted - Employee' When I burst on the email address in our Test environment, the subject line is: Burst Test - Benefit Documents Not Submitted - Employee - testmailtestco.org Is there anyway I can get rid of the 'Burst Test' part of the Subject Line Per the documentation, the subject line is supposed to be the Notification name. I am stumped. Thanks, Patricia

Hello, I have a current smartnote sending Employee HR and BN data to the HR Contact at various locations. Now, the HR Contacts want the employee supervisors getting the notification too. My question is, can my current SN that's sending emails to HR Contacts also send them to Supervisors Those are two different fields residing in two different tables. Appreciate the help! Thanks,

I'm trying to configure my smart notes so that an e-mail is only sent in case the infoset actually contains any data. However, I do not have much luck in this endeavor and I hope someone can point me in the right direction. I've configured an infoset, selecting all failed print jobs from the MEC in case there are any. If there are any I want a notification to be sent to the IT Department. I've setup the notification to send an e-mail on update of the infoset to our ITSM system and I've ticke...

My question involves the 'sender email address' for a smart note. In our installation, the Smart Notes are being sent with the 'sender email address' of a specific employee. I've been asked to change this email address to that of another employee. So I looked in the documentation. The documentation says to edit the <LBI_HOME>\<SmartNotification_HOME>\conf\DeviceTypes.xml file and change the From attribute to the sender email address to use for the device type. The problem is...

I had customized our LSN template to include our company logo a number of years ago. We have siince moved to a newer version (9.1) of LBI and I can no longer locate the modified HTML file. Can someone post the folder location that the default template is stored in on the LBI server The second issue is that our logo is getting replaced by a red X in Outlook / Exchange emails. It appears fine on Smartnotes that are sent to printer devices so I know the logo is good and accessible by the system. I...

Hi, We recently upgraded LBI and Smartnote Services to 10.3. My question is why are excel attachments always named ATT00001.xls I would think that if they're called the SN name that would be better, just like in Reporting Services. Does anyone have experience in this area Thank you! Nabil

In some cases we have scheduled smart notes that will deliver multiple copies to the same subsriber identically timestamped. There is only one scheduled time each day/week/month for each of these updates. This just started in the past two weeks. Delivery history also shows the duplicate deliveries. Any idea how we got here or how to reverse

When in the Smart Notification 'Notifications' tab, I have 3 Smart Notes with a 'Not tripped' message under the value tab. Has anyone ever encountered this before and if so, what did you do to resolve it Thanks

We're looking for a way to automate the deletion of delivery history for Smart Notes. I know about the Delete Delivery History button within Smart Notes Admin, but would prefer to have the system clean up after itself. We're running SN 10.1.0.0. Scheduling a script or using IPA would work Thanks in advance.

Does anyone know a way to break out messages within the “Instructions:” section of notification. Is there a special value that we can enter between the lines to move the next section down About this notification: Hello! The Time & Effort reports for the following employees have been released for certifications. Please click on the link below to access…. vs. About this notification: Hello! The Time & Effort reports for the following employees have been released for certifi...

Report type notification using “Options” from Related Links and Options I would like to use SNs to send out data output reports to users via Options. Basically, the data should not be displayed in the body of the email rather accessed via Related Links and Options… Options>View as an Excel Spreadsheet. Is that possible I’ve played with the section 4 Related Info/Results to Include by changing it “Do not display” but that will not display the records in the email or excel. Does anyo...

I have created a notification with a bar chart. I only want the bar chart to appear on the smart notification. I would like to hide the line at the top of the notification that says Smart Notifications : Name of Notification. I have tried to use the different parameter options under Related Info\Option but can't find one that hides that line. I have tried to create a new template that only has &91;values&93; in the body and that still didn't hide it. Any ideas or suggestions would be greatly a...

Hello - I've created an infoset in order to query the results of two other infosets following the instructions in this post: https://www.lawsonguru.com/Forums/tabid/96/aft/8005/Default.aspx I can run this query against the tables in MS SQL Server Mgmnt Studio with no issues. It returns merged data from the two infosets. select a.COLUMN0,b.COLUMN1,a.COLUMN1,a.COLUMN2,a.COLUMN3 from INFOSET_1086 b, INFOSET_1087 a WHERE a.COLUMN0=b.COLUMN0 When I place this code into my third infose...

Hi, I need to create a Smart Note that will identify individuals who have transferred OUT OF a specific Job Class. I thought I could set up a Smart Note to compare the current run to the prior run. The Smart Note would have to show who the people that are no longer in C05 and C10. Here's what I 'think' I need to do. First, I would create an Infoset with everyone in C05 or C10 Job Class. (FYI, I am not sure what would be the 'Key' for this Infoset. Would it be Job Class if that's all I want to c...

Hi, Can a Smart Note be scheduled to run hourly I see there is an option to select 'Hourly' in the Scheduler; but then the options for hours requires the user to enter a 'From' hour and a 'To' hour. If the Smart Note needs to be run hourly, what should the settings in the schedule be Thanks!

Hi, I am creating a letter template in a Smart Note. This is a letter that will get emailed to the supervisor when a specific condition is met (employee is hired and a HIREACTN1 is processed). The letter will include things such as the supervisor first and last name, employee ID, employee's job title, etc, etc....In the letter template, I must reference the supervisor's first and last name as part of the greeting. I am forgetting how I identify the correct table number, row number, and column nu...

Hi, Does anyone know what the SQL should be in an infoset when trying to change the format of the birthdat from mm/dd/yyyy format to just mm/dd I am not versed enough in SQL language to change this in my Infoset. Is there a way to change the format within the step called 'Define Info set'. I saw there are options to change the date format to various things, but of course, what I wanted was not an option. Any tips on how to change within SQL or within the Info Set would be appreciated. ...

Good Morning, i have a Smart Note that I've designed with the intention of triggering when an employee is no longer in the N05 or N10 Job Class. In the Smart Note data, I have Employee ID, Employee name, Hire Date, Adjusted Hire Date, Structure Group, LP Plan, LP Balance, Email Address, Accrual End Date and Master End Date. The Smart Note will trigger when any of these items change. This is done by using the condition that says 'Items no longer in data from...' The problem I am h...

Hi, I have a Smart Note that, once moved to Production, will be designed to deliver a letter template to each email address that appears in the info set (It's a notice that will go to supervisors about their new hires; one will deliver as soon as the employee is put in a HIREACTN2 PA Action and their status is A0, and the other is set up to deliver to the supervisor with a different message on the employees first day of employment). But before we start sending these notices, we wanted to tes...

Good Morning, I have a Smart Note set up to burst to 2 devices as part of testing. The Info Set contained 6 records, thus, 6 email notifications should have been delivered to each device. When I looked this morning, only 3 notificaitons delivered to each device. I was able to rule out one of the records. (The email address that is being used to trigger the Smart Note was blank.) But there are 2 other records in the Info Set that didn't deliver...I see no reason why a Smart Note would not gen...

Smart Note goes out OK when manually triggered and the scheduler is setup correctly. But, nothing! Scheduler says it went, Delivered Alert History says it didn't, and Activity says nothing. This is a new implementation and there is only one scheduled notification. Can anyone point me in the right direction to find out why this is happening (NOT happening!) Thanks in advance, -Robby