How to add/update data for a search field on a page?

0
I have made an connection to SQL database using the external database connector in the studio. I have a page which has the search fields which I want to point to a specific column in the table under the ExternalDatabaseConnector. Can someone share the steps to do it? I am using Studio 10.18.6. 
asked
1 answers
1

Hi AnshilKumar Patel

 

You can link the search fields on your page to a specific column in the ExternalDatabaseConnector by configuring the Response Structure in the Response Structure tab of the External Database Connection document.

As you have connected to the SQL database using the External Database Connector in Studio 10.18.6, you can follow these steps:

  1. Open the External Database Connection document in Studio.
  2. Click on the Response Structure tab at the top of the document.
  3. In the Response Structure tab, you can preview and create an entity from the response of your query.
  4. You can adjust the name of the entity or move back to a previous step.
  5. Click Save Query & Create Entity to create the entity in your domain model.
  6. Once the entity is created, you can link the search fields on your page to this entity by configuring the microflow actions.

After creating the entity, you can use the Query External Database activity to retrieve the data from the ExternalDatabaseConnector and link it to the search fields on your page.

To use this data in your microflow, see the Query External Database activity.

 

Here are some references

https://docs.mendix.com/refguide/external-database-connection/

https://www.mendix.com/evaluation-guide/app-capabilities/data-querying-management/

https://docs.mendix.com/refguide10/external-database-connection/

 

I hope this will help.

answered