Question
Change character length on a field after data already entered that exceeds
03:49 May 19, 2022
We have a couple string fields set at 500 and unlimited characters that we now want set to a character limitation of 250. There's already data in some of the fields that exceed 250. How can we possibly query and amend these fields via a BP?
Like
1 comments
09:09 May 19, 2022
Hi Susan,
If this is section object, I would tag such records using SQL (You should create tag with such name before).
This is a sample for Account object:
INSERT INTO AccountInTag
(TagId, EntityId)
select (select t.Id from AccountTag t where t.Name='LongName'),a.Id from Account a
where LEN(a.Name)>250
Then you can filter records with this tag in UI or BP
Show all comments