Forum Discussion

pasupathi's avatar
pasupathi
Helper I
4 years ago

developer not going into any project

i have 2 columns 

ProjectStatus                   DeveloperName            

DEV                                      A

Developer allocated             B

FSD                                       C

Hold                                     D

Hypercare                             E

Live                                       F

UAT                                      G

question: if any developer name is not under any projectstatus show the developer name

5 Replies

  • dhruvinushah's avatar
    dhruvinushah
    Responsive Resident

    Hi pasupathi ,
    Give more details on your question. is this an issue where the developer name is present in the table but not associated to any project status? Are the fields in seperate tables and you have a relationship between them?
    Please give more information.

  • i have only single table in that table i have 19 columns out of that i have two columns shown above 

    ex: i have 11 developers out of 11 developers 9 developers have a projects but 2 developers doesnt have any projects show the 2 developers name  

    • danextian's avatar
      danextian
      Super User

      Hi pasupathi ,


      Please share a sample data and your logic - How would you know if a developer doesn't  have any project? Where is in your data can that be found? What will indicate the there are no projects?

      • pasupathi's avatar
        pasupathi
        Helper I

         have only single table in that table i have 19 columns out of that i have two columns shown above 

        ex: i have 11 developers out of 11 developers 9 developers have a projects but 2 developers doesnt have any projects show the 2 developers name 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pasupathi ,

     

    In the sample data you provided above, each Developer has a Project Status.

    How can you tell if the developer is not in any project state, the project state column is blank like below?

    If so you could just add a filter like below:

    If I misunderstood your requirement, please show more details.

     

    Best Regards,

    Jay