6 Replies Latest reply on Nov 25, 2014 1:17 AM by sja

    GROUP SITES DQ  BY CP Address?

    sja

      Hi

       

      Is there smart regex I can use to auto group by CP Address?

      Or I need to copy&paste all the site/pop address?

       

       

       

      like that

      addressCP.png

        • Re: GROUP SITES DQ  BY CP Address?
          mharvey

          Are you creating a group for each address?  If so, you'd just need to select the address in the Dynamic query.  You'll have to repeat for each group you want to create.   If you are wanting to group a node list by address, then you simply need to edit the node list or node tree resource and choose the Address CP as only of the sorting columns.

          • Re: GROUP SITES DQ  BY CP Address?
            sja

            Hi

             

            Thanks for getting to me.

             

            Each POP/Site have 5-10 nodes that share  the same address CP.

            Like to Auto generate those group based on that Address CP.

             

             

            something like

            Node A CP NY

            Node B CP LA                 Auto Group = 1.Group NY

            Node C CP NY                                      2.Group LA

            Node D CP LA

             

            /SJA

              • Re: GROUP SITES DQ  BY CP Address?
                sja

                Okay when I run that

                 

                Orion Objectis
                Press down arrow to use existing values.

                 

                 

                I get all the nodes that has something in the address CP to 1 big group...

                I want to generate a group for each unik address

                  • Re: GROUP SITES DQ  BY CP Address?
                    mharvey

                    To do that, you'd have to use 1 query per group.  The DQ within the group creation is generating for that sole group you are creating.  There's not an automated group builder that would do this.  There are way to get something done using the SDK, but I'm not all that familiar with it.  Within the website, you'd have to create each group individually and list out each address within a query that would belong to that group.

                • Re: GROUP SITES DQ  BY CP Address?
                  RichardLetts

                  I've uploaded a perl script here: add-group.pl to create dynamic groups


                  Here, nodes have a custom property 'Building' that contains a building code


                  I manually created the list of unique groups I wanted at ~lines 23..25+; the group name to be created is generated at ~line 40; and the query that defines the members of the group is at around line 56

                   

                  /RjL