SIP reference Row query

Dwight Matthys

Hi,

We have a layout which adds detail rows to the documentrow dimension. So we have the query SWA_LD_Document:Row as the master query and another one as our detail query. When creating the def.xml file I don't know what syntax to use to reference the query. For the queries in the data category I can just use the name without the SWA_LD stuff. How can we create a SIP package which automaticly selects the correct query (SWA_LD_Document:Row)?

Kind regards,
Dwight

Philipp Knecht

Hi Dwight

If you have specified "Document" as UseData you can use on the left hand side "Row" and on the right hand side "SWA_LD_YourQuery" and link em.

Sadly he always prefixes SWA_LD_ for own installed queries so you maybe have to search and replace in your layout.rst (template xml)
(This is needed because i couldn't retrieve the Query elsewise by DI)

hth

Dwight Matthys

Hi Philipp,

I tried to use Row as the query in the SIP def.xml file but when the SIP is installed the first query displays 0 (probably means not found).

[quote]
<?xml version="1.0" encoding="utf-16"?>
<layout>
<layoutdef code="ICD00003" name="ICD_LD_MarketingDocumentConfirmation" designformtype="139" layouttype="T0000002" onlygrid="N" menupos="" usedata="Document" version = "1.0">
<querydefs>
<!-- List any Queries here that should be used. -->
<querydef query="Row" query2="ICD_GetProductionTreeListByDocEntry" link="LineNum" link2="LineNum" myformtype="" myformtypedesc="" />
</querydefs>


This is a part of the def.xml file.

As you can see I use the usedata document and I use the query Row.

What is wrong?

Kind regards,
Dwight

Philipp Knecht

Hi Dwight


Have to check that out.
I can respond to this on the weekend.

hth

Dwight Matthys

Oké!

Thnx!

Philipp Knecht

Hi Dwight

It is not possible right now. If it is very critical for you we can put it on the todo list.

hth

Dwight Matthys

Hi,

Yeah this is quite necesary I think since this is a very common scenario.

Kind regards,
Dwight