Populating datagrid through a dynamic query.

In our requirment I have to populate two rows of a datagrid through a query,one of them is getting populated.The problem with the other one is that its a dynamic query,the part of query after "select" in turn comes from selecting multiple selections from a listbox.

My Code In java is:

String []selectedValues=null;
ListBox attributeListBox = (ListBox) getControl("List",ListBox.class);
attributeListBox.setMutable(true);
String Actname = attributeListBox.getElementName();
System.out.println("Actual Name of ListBox is:"+Actname);
PageContext pc=getPageContext();
HttpServletRequest req=(HttpServletRequest)pc.getRequest();
String s[] = req.getParameterValues(Actname);
StringBuffer buff=new StringBuffer();
for (int i=0;i<s.length;i++)
{
System.out.println( "Sel val are:"+s[i]);
if(i !=(s.length-1))
buff.append( s[i]+ ",");
else
buff.append(s[i]);
}
System.out.println("Values for Query are:"+buff.toString());
   String sqlPropertList=("select "+buff.toString()+" from "+strTransType+" where r_object_type ='"+strTransType+"'");
    System.out.println("Query sqlPropertList is:" +sqlPropertList);
    Datagrid datagrid=(Datagrid) getControl("mainDoc",Datagrid.class);
    datagrid.getDataProvider().setDfSession(getDfSession());
    datagrid.getDataProvider().setQuery(sqlPropertList);
    datagrid.getDataProvider().refresh();
    datagrid.getDataProvider().initBind();

("strTransType" comes from another query)

In JSP I added :

<dmf:datagrid name="mainDoc" paged="true" pagesize="29" query="sqlPropertList">

But still in webtop its displaying "query Error has occured".
Please give your thoughts & help me in this.
Thanks in advance

Find more posts tagged with

Comments

sergi

You shouldn't define the "query" attribute of dmf:datagrid tag

shr

Even I think that error is created by this tag only,

Can you tell me some other way to populate the datagrid in this case.

Please it will be of great help to me

sergi

For populating your datagrid you should:

1. Create datagrid contol on your JSP, something like this:

<dmf:datagrid name="mygrid" bordersize="0" cellpadding="0" cellspacing="0" paged="true" rendertable="true">
<dmf:datagridRow name="objectgridrow">
<td>
<dmfx:actionlink action="editfile"></dmfx:actionlink>
</td>
<td class="doclistlocicon" nowrap width="18">
<dmfx:docbaselockicon datafield='r_lock_owner' size='16'/>
</td>
<dmf:columnpanel columnname="object_name">
<td>
<dmfx:actionlink action="view" name='viewdoc' datafield="object_name" showifdisabled="true" showifinvalid="true">
<dmf:argument name="objectId" datafield="r_object_id"/>
<dmf:argument name="type" datafield="r_object_type"/>
<dmf:argument name="launchViewer" datafield="true" />
</dmfx:actionlink>
</td>
</dmf:columnpanel>
<dmf:columnpanel columnname="info">
<td><dmfx:actionimage name='inf_button' src='icons/prompt/info.gif' action="properties" width='17' height='17' showimage="true">
<dmf:argument name="objectId" datafield="r_object_id"/>
<dmf:argument name="type" datafield="r_object_type"/>
</dmfx:actionimage></td>
</dmf:columnpanel>
<dmf:columnpanel columnname="correspondent">
<td><dmf:stringlengthformatter maxlen="150">
<dmf:label name="corrlab" datafield="correspondent"/>
</dmf:stringlengthformatter> </td>
</dmf:columnpanel>
</dmf:datagridRow>
</dmf:datagrid>

2. In your behavior class in (onInit method), you should obtain the grid control by name:

Datagrid myGrid = (Datagrid)getControl("mygrid", Datagrid.class);

then get the DataProvider

myGrid.getDataProvider()

then set session to dataprovider:

dataprovider.setDfSession(getDfSession());

then set query by setQuery method.

and, finall call initBind() method

shr

Thanks But I have been doing this for populating one of my rows.but my problem for the other row is that my "argument name" is not known,i mean evrytime its fetched from a ListBox,so it changes every time.I dont have a particular argument e.g."r_object_id" to pass in JSP.

sergi

You can use alisases for fields for example - for one query it would be:

SELECT object_name AS attr1, title as attr2 FROM ....

for the second:

SELECT subject AS attr1, r_creation_date AS attr2 FROM .....

BUT you will have problems with data types

Or another way - define your custom resultset in java class and set it into dataprovider

shr

Can you please tell the other option i.e custom resultset one in more detail.

some example code will be of great help.

sergi

Something like this:

Datagrid grid = (Datagrid) getControl("PerfGrid", Datagrid.class);
        if (grid == null) {
            grid = (Datagrid) createControl("PerfGrid", Datagrid.class);
        }
        TableResultSet tableRS = new TableResultSet(new String[] { "Sender",
                "Performer"}); // <-- creating table header with columns: Sender and Performer

            String[] results = new String[]{"Mark","John"}; // creating the first row
       tableRS.add(results); // addin' the row to the resultset
        DataProvider provider = grid.getDataProvider();
        provider.setDfSession(session);
        provider.setScrollableResultSet(tableRS);
        provider.initBind();

shr

Thanks,this was helpful.

Here you have hard coded addition of rows,can you tell me how to add them from a query.

Thanks in advance.

sergi

When you're executin' the query, you obtain an object with IDfCollection interface. So you can use IDfCollection.getAttrCount() and IDfCollection.getAttr(int counter), to get IDfAttr object, that contains info about fetched attribbutes. The you need to use one of the getters method of IDfCollection to obtain data. (IDfCollection.getString(), IDfCollection.getBoolean() and so on).