Conditions on plain attributes?

 6 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
George Graham
Veteran Member
Posts: 201
Veteran Member
    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
    Veteran Member
      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.

      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      George Graham
      Veteran Member
      Posts: 201
      Veteran Member
        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
        Veteran Member
          Not sure I follow. What is the data type of the field? Also, what query language are you using, dme or sql?

          If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
          George Graham
          Veteran Member
          Posts: 201
          Veteran Member
            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
            Basic Member
              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
              Basic Member
                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.