How I can receive the primary key value after adding into database from OK Port.

03 Jul '19, 04:01 PM


I have given parameters for creating an entry in the database except for the primary key. After the entry created I need the id of the entry created from the OK port. 


Please help me to retrieve the value.

x 0
Answer Answer at this question and get points!
Forum Hero - Level 9

Hi Vijaya,

by default the Create Component returns the primary key of the managed element. In your case you can add a Parameter (e.g. oid) to the OK Port of your Action and pass the oid value returned by the Create Component. Moreover this parameter can be propaged over the OK Flow starting from the Action.

Anyway you have to define an Attribute on your Entity marked as Key (it is the primary key).

Please for more details refer to related guides available on WebRatio Learn section. For example:

x 0
Answer at this question and get points!

Related questions

502 proxy error-generate and run Adding and deleting from the database Agregar boton de cambio de contraseña en el login Ajax and FCK Editor (WebRatio 5.x) Ajax onchange and jQuery 2.x (with migrate plugin) incompatible Ajax on change selection field and modify units Alimentar graficas con base de datos Atributos Condicionales heredados Attribute comparison in a selector unit Autocomplete template Automatic date in form Automatic file upload [beginner] - How to store and browse data collected with BPM app? BPMN: URL field Business object data Cancellare campi e tabelle dal database Cannot add a Database in the Domain Model Cannot connect to MySQL Cannot insert an entity in the database Cannot invoke method selectSingleNode() on null object Can't generate and run database or start tomcat server! Change uplod directory and protect anauthorized access to files ckeditor - change directory for the browser Clean a form Como crear cambio de contraseña Como mostrar una imagen en una lista o en la componente detalles? Como recuperar todos los atributos de una relacion N:N y insertar registros? Como tener dos botones juntos en un formulario independientes de una accion? Como usar la función autocomplete en un field Compare with the current time Conexion a Oracle 12g Connection refused. connect to Cloud Convert data in a Calculated attribute Convert selector component result to single value coupled mandatory fields Creación DB Apache Derby - Modelado BPMN Criptare dati sensibili nel database Cryptic error when submitting a form Database connection, Host and Port number Database password encrypting Database properties Database resource consumption Database Tables Creation After Remote Deploy DB in Data Service Project Deploy in Cloud Amazon Beanstalk with Postgres Disabilitare campi durante evento AJAX Drop down menu question Dudas sobre modelado(Data Flow,Forms y Operation Create) Dynamic attribute/field names. Possible? Dynamic data type Dynamic instantiation of fields on a page for any Class type Empty record mistakenly saved entry form logic. Entry Unit - Default field timestamp Entry Unity, Field Date Type Error Error updating metadata process EverLasting error "The TCP/IP connection to the host has failed. Connection refused" Execute truncate sql query Field as link soruce file analysis then update MySQL database Find Model Problemas Foriegn key relationship Form element Form template Generate and run locally on webratio professional edition. getting data from database Getting the absolute path of a RTXBLOBData Groovy and Database Guardar Saltos de LINEA Hide a form if condition if true Hide form until a flow is triggered Hiding form components based on page conditions Hierarchy component How can I import a view in the Domain Model as an attribute of an Entity? How database or datamodel migration? How to block empty string in Database How to disble derby database? How to fix Network error(status 0) How to redirect to the correct site view after a successful login attempt How to show certain values derived from relations in the domain model? I can't run any application with WebRatio (Table/View 'APP.POST' does not exist) Image in List field input mask Insert data into database Is it possible to create a derived relationship between databases? JDBC4 Postgresql Driver JDBC connection with mysql on mac Job not start correctly Mapping database of the entity '...' is unspecified [MOBILE] Can't synchronize domain model with beck end DB Mostrar datos de diferentes tablas/ show dates from diferentes entities MS SQL server jdbc file Multi Entry Unit: How to forward only checked rows? Multi-Image Upload Multiple forms on one page. HTML5 input attributes. Possible? (2 questions) multi selections field problem Multi Selects didn't work in update page MySQL Driver jdbc No Apache Derby driver found No Database on Cloud account No database on my cloud account Passing JSON Object to Model Personalizzare lo stile di un progetto PostgreSQL Predefined values in database Prelevare la chiave del record da una Selection Field in una Multiple Form Problem accessing MySQL with WebRatio 6 Problema Grafo da una lista gerarchica Problema ¨HTTP Status 404" Problemas con el Operations View Delete Problem saving multi selection from input Problems to connect Sql Server DB from Webratio Problems with Database Metadata Problem with fields with accents used in attribute condition Problem with query unit! Problem with stored procedure Problem with the deletion of more than 50.000 records in a table Progress bar when uploading big file(s) in a form? publish web service for storing information in PostgreSQL DB following XSD Resource Pulire URL query a database Redirecting users to another site view Refresh and Synchronize DB Problems Relaciones Removing the User-Group-Module tagles Resize fields Retrieve a value and add some value to it reverse engineering, problema con le relazioni di default Script Unit e Mysql Search by Selector component does not work selection fields on cascade Select multiple files for upload Setting Upload directory Share database connection Showing items that have a relation with an entity Slot in Selection Field Solve "Generation Error" with Generate and Run option Statistics Component for WebRatio > 7.2.0 Status ProcessInstance and activityInstance in spanish Sybase JConnect 4 JAR replace Sync DataService Project with Mobile Project Table 'freeapp43.profesion' doesn't exist Tarea de servicio no me evalua el valor Trying to Synchronize Domain Model Unable to execute the script java.lang.NullPointerException Unknow property on Dynaclass after generation Unspecified BPM Engine Database Update fields based on selection of other fields Update mutiple records with the same value Updating attributes of an entity upload file and the move it to other location upload file html Uppercase User Login Timestamp Username come chiave Using own User and Group tables Uso de la componente chart de webRatio Validacion validation fields Value Length (Min) fails to validate when field is empty? Web ratio data model WebRatio - list results of joined tables Web Ratio Mobile and Foreign Key Web Ratio Mobile - Remote data mapping problem WebRation - Create Navigation diagram WebRatio no imports all attributes (fields) of a table What are the new features of WebRatio 6.1? Where is the ACME demo data stored?! which of these three models is closer to webratio/ifml way of creating web applications White report