Questions & Answers

[A_Jain]

Hello,

Is it possible to have a primary key column or unique key column in Data Source? Users might add by mistake same DataSet again in the data source. I want to avoid that

Best Regards,

Ashish Jain

[sense]

FirstSpirit automatically generates a column "fs_id" within the datasource, so there is no need to have an additional column.

[A_Jain]

Yes, but I would like to have my own defined primary key column. For e.g. a Data Source with columns Employee ID and Employee name. I want to make sure that one employee id is added only once in Data Source.

[rednoss]

Hello Ashish,

I think this posting [Creation of Composite Primary Key ] will help you.

Best regards

Rene

[sense · Accepted solution]

Another solution would be using rules within FirstSpirit and a schedule within the value determination, see ODFS (help/odfs/template-develo/rules/connecting-exte/index.html), you need a custom module to check if the key the editor entered is already taken and pass this back to the rule.

[mikula]

Hello Ashish,

do you need further help or did Svens or Renes replies already help you? If so, it would be great if you marked this reply as "correct answer" so that other community users find the solution easily. If you have already found a solution by yourself, it would be very kind of you, if you posted it here.

Best regards

Martin

[A_Jain]

Yes Sven, this was the first idea that I had. But I thought may be there is a better and easier solution available. Thank you for the help.