Hi Community,
I am having the following problem: At the time of injection in the URL “?value=1-001 DOLARES”, it is not showing me any data.
This is the schema of my table:
And this is my Custom Javascript;
{% fetchxml articles %}
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
<entity name="crd4f_articles">
<attribute name="crd4f_elementslistspricieid"/>
<attribute name="crd4f_idelement"/>
<attribute name="crd4f_ idlistprice"/>
<attribute name="crd4f_description"/>
<attribute name="crd4f_price"/>
<filter type="and">
<condition attribute="crd4f_ idlistprice" operator="eq" value="{{request.params['value']}}" />
</filter>
</entity>
</fetch>
{% endfetchxml %}
{% if articles.results.entities.size > 0 %}{
"results":
[
{% for article in articles.results.entities %}
{
"Id": "{{article.crd4f_elementslistspricieid}}",
"Element": "{{article.crd4f_idelement}}",
"Description": "{{article.crd4f_description}}"
}
{% unless forloop.last %},{% endunless %}
{% endfor %}
]
}
{% else %}
No data found.
{% endif %}
It should be noted that this table has more than 20,000 records.
Can you help me here?
I would appreciate it Guys.
