Forum Discussion
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...
Done - I have now 48 distinct "Project Keys" (and 9k Issue Keys)
tamerj1 - see my reply above (Message 12). What is next? thanks
sbenzaquen
Any luck?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...
sbenzaquen
Yes. Either the project name or the project key should be avialable in both tables. The relation would be many to many.
