How to refresh the complex table in agentry?

[former_member197782]

Hi,

    I want to refresh the complex table which I used in my application.

     Refresh in the sense, if I do operation on some complex table entry the that entry should be removed from the drop down(complex table).

     It is happening fine when I reset the ATE. But I need for Transmit it self nor for resetting the entire test client.

Thanks in Advance,

Swaroopa.

[mark_pe · Accepted solution]

Swaroopa,

The answer to your query depends on what type of backend your Agentry server connects to.

Your Agentry mobile server can connect to multiple servers from SQL, Java, HTTPXML and others.

If you are using a Java Backend then to remove rows in the complex table is going to be in the Java code and because it is Java code, you can define your own logic.  Our out of the box complex table for some of the products have built in update or delete codes depending on what was set in the SAP backend. If you are really interested in this, you may have to reverse engineer the Java code plus Bapi wrappers of a complex table from the most popular product Work Manager 5.3 for SAP (Java base + SAP backend).

If you are using SQL backend, you will have reload query (Determines when to reload the table), a data query (what to download into the query) and a Delete Query what to delete on the complex table.

See picture:

The picture above is for deleting.

For updating you need to have the SQL Data Query (The other tab) to process the query so that it returns the data that needs to be updated on a non-rebuild section.  Examples for this are in our out of the box SAP Work Manager for Maximo (SQL base + IBM Backend).  You may use that as template if you have access to that software.

Hope this helps.

[former_member197782 · Accepted solution]

Hi,

  Thanks for the reply. Here I am using MSSQL Back end.

   Can you give some SDML tags to rebuild data in complex table without checking the condition.

   Here I wrote some triggers on the table if any modification done then the trigger fires on the table and table is updating based on conditions like(insert,delete,update..etc)

   But i want to rebuild the complex table for every transmit irrespective of the conditions.

   Is it is possible?  If possible please suggest the process.

Thanks,

Swaroopa.

[mark_pe · Accepted solution]

Swaroopa,

In the same Editor settings of your complex table. There are two ways to do this:
1) In the same picture above, there is the Reload section and the Data query section. The Reload section if you return 'True' as Reload - like select 'true' as Reload (We have to find an actual example from the Work Manager if it has one) can do it.

2) The actual Data query you can just query the table again and again to be downloaded from scratch. The issue with this type of query is that you are downloading everything. Normally the data query is used to download once but to download only delta for any new updates.  Again the best example is using the Work Manager for IBM (SQL backend).

Item 1 above, is strongly used in optimizing the production deployment for companies.  Certain companies will detect that after X amount of data being downloaded in their process they may have issues with network or wifi or gprs that they have to decide to improve communication or else risk corrupting their data if they are not quick enough to transmit the data.  That point of failure is very important. This is specific to the environment of the customer. You know what I mean when you are talking over your phone and you always drive to this area where the signal is low and no matter what you will tell your friend/family that "I am going to a low spot prepare for me to get cut off".  Unfortunately that also exist in Mobile devices for any application.  Certain people when they go out in the field may experience it and Reload section is used for optimization.

Item 2 is actually used for downloading your main load of complex table. An SDML will be used <<rebuild>> to indicate to the mobile device that the device is new and has no data - the <<else will be used to specify that the client is not on rebuild mode then the query in that section will be used to take a delta change.  Again best product to get here is the Work Manager for IBM.  I always tell customers to at least buy one of that product as a template before starting to design from scratch. If you are in the class of Work Manager for IBM (MOB320) you will get that training and get the application.  You can technically just send one of your guys in that training to get a copy of that template or if you work inside SAP, try to get one of that application through the SAP software download section in the service marketplace - one of the best examples with SQL and Java backend.

Example of Data query with SDML:

Hope this helps.

[former_member197782 · Accepted solution]

Hi Mark,

   Thanks for the reply. Now my application works fine with your suggestion.

Thanks,

Swaroopa