Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-2500

extended udf: UI needs to look at typeID to display the description

          Details

          • Type: Bug
          • Status: Open
          • Priority: Minor
          • Resolution: Unresolved
          • Affects Version/s: None
          • Fix Version/s: None
          • Component/s: Third Party Data
          • Labels:
            None

            Description

            This is a bug for a UI change associated with a change in the backend behavior related to http://jira.ri.thesearchagency.com/browse/ADMAX-2209

            The backend is now saving the distributionID value into the `typeID` column for wh_publisher data sources.

            This results in multiple rows with the same "Publisher Feeds" description in the UI. My hope is that it's a quick change to have the UI pull the distribution description from the typeID value like it does for dataSources that have type='publisher'.

            mysql> select * from dataSources join dataAvailability on (dataSources.id = dataAvailability.dataSourceID ) where dataAvailability.date = "2010-12-14" and accountID=17 and type in ('searchengine','wh_searchengine','client','wh_client','pixel','wh_pixel','publisher', 'wh_publisher');

            ----------------------------------------------------------------------------------------------------------------------------------------

            id type typeID accountID id date oldUpdated updated dataSourceID status statusText needsRerun override

            ----------------------------------------------------------------------------------------------------------------------------------------

            13895 wh_client NULL 17 18478561 2010-12-14 00:00:00 2010-12-13 17:08:43 13895 success NULL false false
            17361 wh_pixel NULL 17 18482201 2010-12-14 00:00:00 2010-12-13 17:08:48 17361 success NULL false false
            87351 client NULL 17 18496111 2010-12-14 00:00:00 2010-12-13 17:09:02 87351 not started NULL false false
            130761 publisher 180 17 18511351 2010-12-14 00:00:00 2010-12-13 17:09:25 130761 not started NULL false false
            130771 publisher 177 17 18511361 2010-12-14 00:00:00 2010-12-15 10:51:19 130771 success NULL false false
            130781 publisher 188 17 18511371 2010-12-14 00:00:00 2010-12-15 10:51:20 130781 success NULL false false
            131011 publisher 197 17 18511591 2010-12-14 00:00:00 2010-12-13 17:09:25 131011 not started NULL false false
            16451 wh_searchengine 3 17 18511641 2010-12-14 00:00:00 2010-12-13 17:09:25 16451 success NULL false false
            8832 wh_searchengine 5 17 18511651 2010-12-14 00:00:00 2010-12-13 17:09:25 8832 success NULL false false
            8968 wh_searchengine 147 17 18511661 2010-12-14 00:00:00 2010-12-13 17:09:25 8968 success NULL false false
            9199 wh_searchengine 164 17 18511671 2010-12-14 00:00:00 2010-12-13 17:09:25 9199 success NULL false false
            131021 wh_publisher 177 17 18512581 2010-12-14 00:00:00 2010-12-15 10:51:20 131021 success NULL false false
            131031 wh_publisher 188 17 18512591 2010-12-14 00:00:00 2010-12-15 10:51:20 131031 not started NULL false false

            ----------------------------------------------------------------------------------------------------------------------------------------

            13 rows in set (0.06 sec)

            mysql> select `dataSources`.`accountID`,`dataSources`.`type`,`dataAvailability`.`status` from `dataAvailability` join `dataSources` on ((`dataSources`.`id`=`dataAvailability`.`dataSourceID`)) join `tsacommon`.`accounts` on ((`dataSources`.`accountID`=`tsacommon`.`accounts`.`id`)) where ((`tsacommon`.`accounts`.`id` in (17)) and (`dataAvailability`.`date`="2010-12-14") and (`dataSources`.`type` in ('wh_pixel','wh_client','wh_searchengine','wh_position','wh_publisher'))) order by `dataSources`.`accountID`;

            -------------------------------------

            accountID type status

            -------------------------------------

            17 wh_client success
            17 wh_pixel success
            17 wh_searchengine success
            17 wh_searchengine success
            17 wh_searchengine success
            17 wh_searchengine success
            17 wh_publisher success
            17 wh_publisher not started

            -------------------------------------

            8 rows in set (0.00 sec)

              Attachments

                Activity

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    therouxj Jeff Theroux
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: