Fetching Database Records into the AEM Designer form

[kohlitanika@ymail.com]

I am using AEM Designer 8.0 and SQL Server. I have made a form and connected it to the SQL Server. I want to retrieve specific record from the table into the form depending upon the lookup ID entered in the form by the user. I want fetch specific record from the database. 

Kindly please help. 

On the Exit event of the lookup ID Textfield:

if(len($.rawValue)>0) then

var cdhid=$.rawValue

xfa.sourceSet.DataConnection.#command.query.commandType="text"
xfa.sourceSet.DataConnection.#command.query.select= concat("SELECT CPTY_SHORTNAME FROM CDH_BANKS_STG WHERE CPTY_CDHID=",cdhid,";")
xfa.sourceSet.DataConnection.open()
xfa.sourceSet.DataConnection.first()

endif

[LinSims · Accepted solution]

This website is for supporting Adobe's CC and TCS products. 

AEM is supported at a different website: 

https://experienceleaguecommunities.adobe.com/

You will need to repost your question there.

Be aware that the Community Help forum is for help in using the Community website. Product questions should be posted in the associated product community.

[Nancy OShea]

What's a TCS product?

[John Waller]

Technical Communication Suite (Framemaker, Robohelp etc)

[sayali26087067nelg]

I am looking for a course in AEM designer for designing the form , request your help here

[John T Smith]

Go up and read the information posted Febuary 2020 and go to that link