Data driven approach on Attachments - power portal

[VVDynamics]

Hi Experts, I am quite new to power portals. I am trying to retrieve attachments from dataverse using fetchxml through webtemplate, where in if I add filter condition for request.params.id the results are always 0.  I am guessing the ID being passed might not be the one I am checking, but unsure how to pass ID from advance form step to basic insert form (attachments being displayed in subgrid)

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="caaci_genericformsubmissionattachment">
<attribute name="caaci_genericformsubmissionattachmentid" />
<attribute name="caaci_name" />
<order attribute="caaci_name" descending="false" />
<filter type="and">
<condition attribute="caaci_genericformheaderid" operator="eq" uiname="ENL1234 - Apply for Initial ENL Application Licence" uitype="caaci_genericformheader" value="{7999E32A-0364-ED11-9561-0022481B58DE}" />
</filter>
</entity>
</fetch>

it gives 5 results from dataverse, if I place value="{{request.params['id']}}" results are 0.

Update:

Even though there is an ID in the request.params, the filter is still giving 0 results.  I have tried other posts here where suggesting to place filter and attributes in order, nothing worked for me 😞

[OliverRodrigues]

Hi @VVDynamics , if you try to simply display the ID in the parameter what happens?:

<p>ID: {{request.params['id']}}</p>

but ultimately, is there any reason as to why you are using Liquid/Fetch to retrieve the attachments?

I am assuming the Attachment table has a Lookup to Header table, so you can simply add that as a subgrid. Is there a reason to not show as a subgrid?

Where is your Fetch/Liquid code? is that in the Advanced form step JavaScript?

[Inogic]

Hi,

For replacing the ID in your fetch xml please use “{{request.params.id}}” in portal. Please refer below screenshot for the same.

And then just try to execute the webpage in the browser by passing the parameters.

Hope this helps.

If you find the answer useful then please mark it as verified.

Thanks!

Inogic Professional Services

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/  

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[VVDynamics]

Hi Oliver, thanks for your reply.  The code is in webtemplate.  When I place this 

<p>ID: {{request.params['id']}}</p>

 the code is not being executed.  Yes we are displaying attachments as subgrid, but the concept here is user has to select from the attachments related to that particular entity. When I have tried displaying all the attachments also, it is giving me only one record:

{%if request.params['id'] %}

{% fetchxml subcategory_query %}
<fetch version="1.0" mapping="logical">
<entity name="caaci_genericformsubmissionattachment">
<attribute name="caaci_genericformsubmissionattachmentid" />
<attribute name="caaci_name" />

</entity>
</fetch>

{% endfetchxml %}
{
"totalcount": "{{ subcategory_query.results.entities.size }}",
"results": [
{% for sub in subcategory_query.results.entities %}
{

"id": "{{sub.caaci_genericformsubmissionattachmentid}}",

"listofdocs": "{{sub.caaci_name}}"
}{% unless forloop.last %},{% endunless %}
{% endfor %}
]
}
{%endif%}

On click of Add attachment, there opens a basic create form

 which shows only a single record.

[VVDynamics]

Thanks Inogic, yes I have tried that, and it gives 0 results

[GWham1]

Have you created entity permissions to be able to retreive/read the record you are expecting? I normally find that if you get results using Advanced Find and not via FetchXML, then you do not have permissions setup correctly to retreive the record.

[OliverRodrigues]

"Yes we are displaying attachments as subgrid, but the concept here is user has to select from the attachments related to that particular entity"

subgrid allows user to view the details of the attachment record, so I am still not sure why you need the fetch

there seems to be an issue when retrieving the ID via Liquid, I know it's stupid but I have to ask, are you sure the parameter is called id ? if this is an Advanced Form, how is this being populated, I feel like Advanced Form only adds Session ID + Step ID, and not the record ID itself

also where is your Liquid code placed? is this in the web page / Javascript from the step? 

[VVDynamics]

Yes entity permissions are in place

[VVDynamics]

subgrid allows user to view the details of the attachment record, so I am still not sure why you need the fetch - the same subgrid is used to create attachments, this subgrid is added as metadata from advance form. 

The liquid is in webtemplate which is associated with Home Webpage.

I feel like Advanced Form only adds Session ID + Step ID, and not the record ID itself - this is true, but the other existing queries have the same implementation, i tried to findout the about the ID using var id = $('#EntityFormView_EntityID').val(); which gives record id, but the result is from Advance Form, where the attachments are from basic form, which are added as metadata to the advance form, so I am not sure if I am missing passing this ID from advance form to basic form.  

On advance form, this step might be maintaining the ID, not sure, as there is an existing query which is still based on request.params.id and executes without any issue:

[OliverRodrigues]

Apologies, I keep answering with questions but I have a few more 😂

"the same subgrid is used to create attachments, this subgrid is added as metadata from advance form."

- if you want separate subgrids, you can add multiple subgrids to the form and manipulate the metadata for each one to have different actions, not sure if that's what you mean

would you have a mock page of what you are trying to achieve, I still can't visualize 

"The liquid is in webtemplate which is associated with Home Webpage."

Is your Advanced Form associated with the home page? please note that your Fetch will execute every time the home page is loaded, this might bring your site performance down

"var id = $('#EntityFormView_EntityID').val();"

this is executed client-side, but your Fetch is being executed server-side, so you can't retrieve that at that stage

"but the result is from Advance Form, where the attachments are from basic form, which are added as metadata to the advance form"

I am either getting more confused again or maybe understanding this better.. are the Attachments a modal/basic form within your Advanced Form? or are they an Advanced Form Step itself? can you share a snapshot?

"On advance form, this step might be maintaining the ID, not sure, as there is an existing query which is still based on request.params.id and executes without any issue"

Can you share the URL structure?

any URL/snapshot you can hide any sensitive information, we just need to see structure of things so we can better assist you