Data Source with Primary Key
Author: A_Jain
Publication Date: 8/25/2017 15:07
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
-
Author: sense - 8/25/2017 15:19
FirstSpirit automatically generates a column "fs_id" within the datasource, so there is no need to have an additional column.
0 -
Author: A_Jain - 8/25/2017 15:21
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.
0 -
Author: rednoss - 8/31/2017 9:31
Hello Ashish,
I think this posting [Creation of Composite Primary Key ] will help you.
Best regards
Rene
0 -
Author: sense - 8/31/2017 9:39
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.
0 -
Author: mikula - 9/4/2017 8:30
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
0 -
Author: A_Jain - 9/4/2017 16:03
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.
0
Please sign in to leave a comment.
Comments
6 comments