Unable to get xtk:fileRes schema values in webpage | Community
Skip to main content
G
Greeshma_Sampath1
Level 4
August 11, 2021
Question

Unable to get xtk:fileRes schema values in webpage

  • August 11, 2021
  • 3 replies
  • 2643 views

Hi All,

 

I am creating a web page in which i need to get the images list from public resources folder(xtk:fileRes schema) as drop down so that the customer can select the image from it.

But while adding xtk:fileRes in to the code, the particular column/field is not showing the dropdown option.

For cross checking i used another normal schema and tried and then I was able to get the drop down and the list from that schema was also shown.

Given below the code for this particular field used in the web app:

 

<div class="info">
<div class="infoalign"><b>Image</b><span class="req" id="req_4">*</span></div>
<div class="infowidth"><input name="txtZip" id="pincode" list="imageslist" class="pincode text" type="text" size="14" placeholder="Image" data-nl-ismandatory="true" data-nl-label="Image" data-nl-xpath="@imagepath" data-nl-bindto="xpath" data-validation-type="Image" /></div>
<datalist id="imageslist"><% for each(var rec in new XML(xtk.queryDef.create(<queryDef schema="xtk:fileRes" operation="select" lineCount="100000"> <select> <node expr="@name" alias="name"/> </select> </queryDef>).ExecuteQuery().toXMLString())){ %>
<option value=<%= rec.@name %>>
<% } %>
</datalist>
</div>

 

Is this issue specific to out of the box schemas or xtk schemas?

Could someone kindly help me resolve this issue ASAP.

 

@davidkangni @_manoj_kumar_ @jonathon_wodnicki 

 

Thanks & Regards

Greeshma

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Krishnanunni
Krishnanunni
Level 4
August 12, 2021

Hi @greeshma_sampath1 ,

I was able to list the content using querydef inside Javascript code activity. If it works inside the JS activity, I suppose it work on webapp as well. But do you need the toXMLString() and the newXML functions? The execute query itself returns an XML. Following code prints the values of public resources. 

var query = xtk.queryDef.create(  
  <queryDef schema="xtk:fileRes" operation="select">  
     <select>  
      <node expr="@name"/> 
    </select>  
  </queryDef>  
);  
var resultSet =  query.ExecuteQuery();
for each (var row in resultSet) {
  logInfo("Name: "+ row.@name);
}

 

G
Greeshma_Sampath1Author
Level 4
August 12, 2021

Hi @krishnanunni ,

 

Thank you for your suggestion.

I was already able to do the same and got the list in javascript, but the drop down is not coming when it is given in a web page.

Do you have any other idea in which we can achieve this?

 

Thanks & Regards,

Greeshma

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
August 12, 2021

Hello @greeshma_sampath1,

you are using alias and calling results by attribute name instead of alias. Remove the alias from your query def

 

Marcel

G
Greeshma_Sampath1Author
Level 4
August 12, 2021

Hi @marcel_szimonisz ,

 

Thank you for your reply.

I have removed alias and tried but still the dropdown was not coming.

 

Thanks&Regards,

Greeshma

Marcel_Szimonisz
Community Advisor
Marcel_SzimoniszCommunity Advisor
Community Advisor
August 12, 2021

Hi @greeshma_sampath1 ,

Looking at your code and you do not need  new XML() in there, as it's adobe campaign document object returned by this query def

 

 

marcel

G
Greeshma_Sampath1Author
Level 4
August 13, 2021

Hi @marcel_szimonisz ,

 

Thank you for your response.

I am able to get the xktfileRes data by using sql select script in page activity.

 

I have a doubt. Can you please tell me how we can take a value from page activity and pass that to the next page activity in a web app in adobe?

The below mentioned is the code i used in page 1 and I need to get the filename to be passed to next page activity to store in a different table.

 

<% var res = sqlSelect("publicUrl,@sstringValue:string",
"select sfilename||',' from xtkfileres where rownum < 10"); for each(var res2 in (res.publicUrl.@sstringValue.toString()).split(','))
{%>

<input name="imageFileres" data-nl-label="Image Path" data-nl-ismandatory="true" type="radio" value="https://redcross-mid-stage3-t.adobe-campaign.com/res/redcros_mid_stage3/<%= res2.split('/usr/local/neolane/nl6/var/res/redcros_mid_prod3/')[1] %>" placeholder="Image path" data-nl-xpath="@imagepath" data-nl-ismandatory="true" data-nl-label="Image path Name" data-nl-bindto="xpath" /></div> />
<img title="American Red Cross - Be a hero to patients in need!a" class="nlui-widget" style="width: 100%; max-width: 600px; height: auto;" src="https://redcross-mid-stage3-t.adobe-campaign.com/res/redcros_mid_stage3/<%= res2.split('/usr/local/neolane/nl6/var/res/redcros_mid_prod3/')[1] %>" unselectable="on" />
<% } %>

 

Thanks & Regards,

Greeshma

G
Greeshma_Sampath1Author
Level 4
August 16, 2021

Hello @greeshma_sampath1,

similar to workflow you can pass variables via context variable ctx which is available in web app flow.
You can add variable in ctx.vars.xxx and pass it from one place to another. (backend to backend) But to pass user answer use to set it in front end to back end use:

document.controller.setValue('/ctx/webAppLogRcpData/variable');

And on back end use to get it ctx.webAppLogRcpData.variable

Also this variable has to be added in the survey variables in page v5 activity
 
Marcel

 


Hi @marcel_szimonisz ,

I have used the below code to get the list from public resources and when one is selected the path/file name gets inserted to the respective @imagepath column in my schema. But the issue is that if i give 3 images in the list and select the 2nd or 3rd image the file name is not getting stored in the column in schema. On the same time when i select the 1st image the path/value is getting stored.

 

<li><% var res = sqlSelect("publicUrl,@sstringValue:string", "select sfilename||',' from xtkfileres where rownum < 3"); for each(var res2 in (res.publicUrl.@sstringValue.toString()).split(',')) {%>
<input name="121212" id="121212" type="radio" value="https://redcross-mid-stage3-t.adobe-campaign.com/res/redcros_mid_stage3/<%= res2.split('/usr/local/neolane/nl6/var/res/redcros_mid_prod3/')[1] %>" label="<%= Math.random() %>" data-nl-bindto="xpath" data-nl-xpath="@imagepath" data-nl-ismandatory="true" data-nl-label="string1" unselectable="on" uselabelasvalue="false" />
<img title="American Red Cross - Be a hero to patients in need!a" class="nlui-widget" style="width: 100%; max-width: 600px; height: auto;" src="https://redcross-mid-stage3-t.adobe-campaign.com/res/redcros_mid_stage3/<%= res2.split('/usr/local/neolane/nl6/var/res/redcros_mid_prod3/')[1] %>" unselectable="on" /> <% } %></li>

 

Could you please help me in this ASAP.

 

Thanks & regards,

Greeshma 

Terms & ConditionsAccessibility statement

Loading footer...