• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
Locked
0

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

1.0K

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

Community Expert , 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.

 

 

Votes

Translate

Translate
Community Expert ,
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.

 

 

Votes

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
Community Expert ,
Feb 27, 2020 Feb 27, 2020

Copy link to clipboard

Copied

What's a TCS product?

 

Nancy O'Shea— Product User, Community Expert & Moderator
Alt-Web Design & Publishing ~ Web : Print : Graphics : Media

Votes

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
Community Expert ,
Feb 28, 2020 Feb 28, 2020

Copy link to clipboard

Copied

Technical Communication Suite (Framemaker, Robohelp etc)

Votes

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
New Here ,
Jan 07, 2023 Jan 07, 2023

Copy link to clipboard

Copied

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

Votes

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
Community Expert ,
Jan 07, 2023 Jan 07, 2023

Copy link to clipboard

Copied

LATEST

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

Votes

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