Welcome Dialog

Welcome to the Community!

We have a brand new look! Take a tour with us and explore the latest updates on Adobe Support Community.


Fetching Database Records into the AEM Designer form

New Here ,
Feb 27, 2020 Feb 27, 2020

Copy link to clipboard

Copied

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

 

 

TOPICS
Feature request

Views

845

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Adobe Community Professional , Feb 27, 2020 Feb 27, 2020
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.    

Likes

Translate

Translate
Adobe Community Professional ,
Feb 27, 2020 Feb 27, 2020

Copy link to clipboard

Copied

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.

 

 

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 27, 2020 Feb 27, 2020

Copy link to clipboard

Copied

What's a TCS product?

 

Nancy O'Shea, Adobe Product User & Community Professional
Alt-Web Design & Publishing ~ Web : Print : Graphics : Media

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Feb 28, 2020 Feb 28, 2020

Copy link to clipboard

Copied

LATEST

Technical Communication Suite (Framemaker, Robohelp etc)

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines