cancel
Showing results for 
Search instead for 
Did you mean: 

How to refresh complex table in which data is fetched based on parent indexes?

sravanthi_polu
Contributor
0 Kudos

Hi All,

          The scenario is, i have declared a complex table with fields and indexes in which the second index has a parent index.The data in the second field is fetched based on the first field.let us consider that i have chosen A in first field (A has 1,2,3 items in back end),the second field will populate A items (in this case 1,2,3),I have chosen first field A second field 1(A-1) and generated a report ,after that i have performed a sync with the data base,the values are updated.Now if again i choose first field as A then the second field should show only 2,3 items because i have generated report for A-1 combination.If the report generated for A-2 then second field should show only 3 when i select first field as A.Now finally if i generate report for even A-3 combination ,the first field should not show A that means i have generated report for all the items of A so it(A) should not be showed in complex table drop down.

                                                  For this  i have written data query, deleted query,I have even fired triggers for the tables in back end system.But the complex table is not refreshing ,even if i generate report for A-1 it is still showing 1 in the items list(second field).But when I reset my test environment then only it is removing.Please let me know how to solve it.

                              Thanks in advance

Regards,

Sravanthi Polu

Accepted Solutions (1)

Accepted Solutions (1)

mark_pe
Active Contributor
0 Kudos

If this is Agentry, you may need to study SDML for your Data Query.. In the main manual there is SDML section. (Syclo Data Mark up language - Not sure if they renamed this to SAP Data Markup Language). Good thing that SAP, Syclo or Sybase all starts with the letter 'S'.  It's easy to change the manual to say one thing or another.

Add this to using exchange tables too. Most of this type of knowledge is taught in the SAP MOBILITY class - MOB320.

http://training.sap.com/v2/course/mob320-sap-agentry-work-manager-for-ibm-maximo-classroom-095-be-en...

Due to IBM Mobility is done in Java + SQL.  All related SQL type of knowledge is shown in the class above.  So all examples about refreshing tables are in that class and its documentation (Tutorial).

You may also try to use the Reload Query (example below is just a snippet from the SAP Work Manager for IBM):

Example (only a small portion from the complete Work Manager for IBM - Reload script for the Asset Complex Table - not the complete one):

 

select 'true' as reload <<database.singleRow>>

"

 

else

 

"

select 'false' as reload <<database.singleRow>>

"

 

sravanthi_polu
Contributor
0 Kudos

Hi Mark,

I have tried with reload query and modified the data query as mentioned above according to  my requirement.It is working correctly.

 

           Thanks for reply

Regards,

Sravanthi Polu

Answers (0)