With regards to deleting the Active Ingredients, since they said it's ok I will just show them a message saying that they will expire next month or something like that. Otherwise, it seems like it'll get complicated.
Veni, I changed ADDITIONAL_INFORMATION to a clob and added the full thing he wanted in there (I found the email for awhile ago when I tried this before). Can you check to see if it's coming through in the app for that PULA?
I tested it for the two PULAs which had the longest ADDITIONAL_INFORMATION fields. One was 892 characters and the other was 1081. Both of them came through without any cutoff. Thanks for looking into this!
Hey @troddick, I was looking at the database and at the AI table. Some of the INGREDIENT_NAME's look cutoff to me. For eg. one with IDs 3151 and 2054.
3151 = "Cyclohexanone, 2,4-dimethyl-" and 2054 = "()-Trichloroethylidene)-a-D-glucofuranose ()= 1,2-O-(2,2,2". I think they are the same in the prod database. Do these look right? I am not sure what they are supposed to be so I can't tell.
Yeah, I'm not sure. That field can definitely hold more characters than that.. that must be the way we initially got them. Getting the ai table populated way back was a nightmare.. the data was horrible! this must be some of the lingering bad/incomplete data