Forum Discussion

sbenzaquen's avatar
sbenzaquen
Icon for Helper I rankHelper I
4 years ago

Find text in a column from another table

Hi experts, I need help with something I'm working on. I want to search in the "Notes" column from the "Time Spent" table if it contains any of the "Issue Keys" of the "Issue Key" table. If so, I'd...
Need Help
sbenzaquen's avatar
sbenzaquen
Icon for Helper I rankHelper I
4 years ago

It is loading "work in on it" for a while....I think the data is still too big. My time spent table is 313k...

 

To make sure I understood it correctly, how am I supposed to link the two tables? I still don't have any link with the Time Spent table as there is no issue/project key to use...Do I need to develop one column on the time spent table? I only did the project key in the Issue Key table...

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    sbenzaquen 
    Yes. Either the project name or the project key should be avialable in both tables. The relation would be many to many.