Defining a table in trasaction properties

[Former Member]

Hi friends,

Can anybody tell me about how to define a table in the trasaction properties...

I have created a BLT which will take the table as input parameter.I have data in table but dont know how to create a table in the properties.Once BLT has been called it should call the table which was defined in the transaction propery....This is how my requirement.

Please help me out.

Thanks & Regards

Sireesha.

[Former Member]

Hi Sireesha

to define a table in the trasaction properties you can follow following steps :-

1) Open the BLS logic editor and go to action tab XMII XML Output.

2) Open this action tab and choose action Document. Under configuration you can define your desired columns,min ,max range and data type parameters.

3) After creation of columns, data insertion can be done row by row so for that purpose,add action Row.

4)Now right click on Row action and go to link of Row. map columns of document to perticular actions rows.

By this way you can create table and finally save it in xml saver.

Run this in query template as executive query and there you can see your result in table format.

If it is your answer than Tell me

Thanks

Ramshanker

[Former Member]

Hi Sireesha,

if I get it you were able to call a Xacute (BLS) Query from a Transaction you built with the BSL and get this displayed as a table. Remember this table is still in xMII-XML format (choose text/xml instead of text/html) and you will see it. Lets call this Transaction A.

Now you want to use a table as input property of another transaction (B) or as local variable etc. However you have to build your table in a XML Structure e.g.:

<test>

<item></item>

<item></item>

</test>

Even if this is not a valid xMII-XML you can define an input-property (Type: xml) and it will work if you pass this values from a webpage e.g. as Param.1 to your query. As ist is not in xMII-XML Format you have to use some action blocks to read the data out of your property.

If you want to use the result of your Transaction A in another Transaction try to use a Transaction call. Or use a XML-Query in your Transaction wich will point out to your saved file, or load your saved file with an XML-Loader. It depends what you want to do.

Hope this helps

Martin

PS: I have to try the way you build an XML-Output. Are you able to assing as may rows you want? Have you every thougt to use the xMII-Document Action block?

[Former Member]

Hi Martin

As par your question

(" PS: I have to try the way you build an XML-Output. Are you able to assing as may rows you want? Have you every thougt to use the xMII-Document Action block? ")

If you want to assign more than one rows than you can use repeater action.

This action will take repeatedly values from given path.

So add repeater in between xMII-Document Action and Row action block.

Well if you want to know something else than let me clear

Thanks

Ramshanker

[Former Member]

Hi Sireesha,

I think you need to explain what you mean by table. Is this table some sort of data? Or is it a table name? Perhaps it might be easier to describe what the use case is (as in what you are trying to do with this transaction, and why).

You can create an XML input transaction property which can contain tabular data, and can be easily manipulated using xMII.

Regards,

Sidney Shek