Restrict specific number of records in Complex table entries - Syclo Work Manager

[Former Member]

Hi Experts,

We have Work Manager 6.1 application deployed on SMP 3.0. We have a requirement to restrict complex table entries with records starting with 2000 to 3000 series in a specific screen.

We cannot restrict these entries in middle ware or back end as these records has to be hidden in specific screen. Please suggest rule that can achieve this requirement.

Regards,

Swathi.

[Former Member]

bill.froelich requesting your inputs

Thanks in advance

Regards,

Swathi

[jim_bonczyk]

Swathi,

This would require customizing the Work Manager back end Java code that populates your complex table and return a calculated value for the new field. The customization would need to take each specific ID and figure out what "series" group each belongs to.

Jim

[jim_bonczyk]

Swathi,

One approach would be to add a new "series" field to the complex table definition and populate this field with a common value for each series. For example use "2000" for all records that begin with 2000 through 2999.

Next, create a complex table index "series" on this new series field, and a second complex table index "id_by_series" on the ID field and set the parent index to the new "series" index.

On your screen, set the complex table search control to use the "id_by_series" index and set the parent value to the series that you want to restrict (for example "2000").

Using complex table indexes in this manner will perform much faster than using rules to filter the data on the fly.

Jim

[Former Member]

Hi Jim,

Thanks for your reply.

Can you please suggest how to populate new "series" field with a common value for each series. For example use "2000" for all records that begin with 2000 through 2999.

Regards,

Swathi.