Composite primary key with a partial field


#1

I see in the docs that you can define a composite primary key. Can I use SQL to make a composite key with an (example) LEFT term?

for instance, {firstname}-{lastname}-{LEFT(birthdate,10)}


#2

No. This is currently not supported. You can only define which fields you wish to use and/or plain text (as separators between the fields or other additions to the fields’ values)