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
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

sbenzaquen 
That would make 2.8 bilion iterations. In addition to CONTAINSSTRING which is a slow function. Let me think if there is another way to do that.

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

Thank you tamerj1 .

I was maybe thinking of this as an option:

  • issue keys are comprised by: 5 letter characters; a "-" sign and 1/2 digits (e.g. PBRID-72, PALMA-3).
  • we may get a rule that searches for these criteria in the "Notes" field and then remove those that are not in the Issue Key table (you may get some silly date fitting the criteria)

 Let me know if this helps.