Hi,

I have many Entities with audit fields all named like:

***_UpdatedOn ***_UpdatedBy

For example a client entity has

Cli_UpdatedOn Cli_UpdatedBy

and a PersonEntity has

Per_UpdatedOn Per_UpdatedBy

I would like to give all these fields consistent names i.e.

UpdatedOn UpdatedBy

Could you suggest if this is possible using the Entity Field Name Strip Pattern or some other project setting, and if yes, how i would go about doing it.

Thanks, Iain

Hi Ian,

You can use entity field strip pattern (Project -> Settings -> Element Name Construction). In this case, the entity field name strip patter could be:

{cli_, per_}{}

Hi,

Thanks for getting back so quickly.

I wasn't clear enough in my question. i have hundreds of entities with random 3 character prefixes on all the column names.

Really what i'd like to achieve is for a way for the project to recognize the suffix and keep it, and strip the prefix.

For example

Per_Updatedby -> UpdatedBy Cli_UpdatedBy -> UpdatedBy Xxx_UpdatedBy -> UpdatedBy

etc. etc.

No worries if it's not possible i have a workaround in the code at them moment.

The reason i ask is that i have code in my entity generation template which auto sets these values. It would be nice if could just look for Fields.GetFieldNames().Contains("UpdatedBy") and then if found set the current value.

Cheers, Iain

So you need wild card stripping. Something like: {*_}{}

That's not supported at the moment.

Good suggestion, we'll look into adding this in a future version.

To get these names renamed quicky, you could use a piece of code in Element Search. it's a bit cumbersome perhaps, but it's less work than renaming them by hand . If you need help with that, let me know.

Implemented in v5.7