Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Smart Notification
Conditions on plain attributes?
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LindseyC
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5183
People Online:
Visitors:
352
Members:
0
Total:
352
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Smart Notification
Conditions on plain attributes?
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
George Graham
Veteran Member
Posts: 201
9/23/2010 8:47 PM
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?
Matthew Nye
Veteran Member
Posts: 514
9/23/2010 9:17 PM
If the column must be a condition for one notification and not for the other just add the field twice to the same infoset, set one to measure and the other to an attribute.
George Graham
Veteran Member
Posts: 201
9/23/2010 11:16 PM
But if this is a "non measureable" field - say Process Level - that only lets me select it if I choose something like "Total" or "Count" - but those are not applicable to a string field. Or am I missing something?
Matthew Nye
Veteran Member
Posts: 514
9/24/2010 12:02 PM
Not sure I follow. What is the data type of the field? Also, what query language are you using, dme or sql?
George Graham
Veteran Member
Posts: 201
9/27/2010 5:05 PM
This is a string field - but this could apply to dates, etc... The idea is that in the Conditions page of the info set at the right hand side where the columns/fields are listed - only fields that are flagged as "measures" display there to be able to select to apply any conditions to - not any attribute type fields. The only way I can see doing this is through the original query - regardless of if it is SQL or DME.
Giulia
Basic Member
Posts: 12
2/1/2011 1:38 PM
I have the same problem. I want to apply a condition to a column in the Infoset but I can't because the column is not listed in the columns/fields box because it is an attribute (the data type of the field/column is string). Where you able to come up with a solution?
Giulia
Basic Member
Posts: 12
2/2/2011 1:24 PM
I figured out that you don't need to have any fields in the column/fields list box. If you choose has new items or has new keys in the condition, it will apply to all the fields in the Infoset.
You are not authorized to post a reply.