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

[former_member552266]

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_member552266]

bill.froelich requesting your inputs

Thanks in advance

Regards,

Swathi

[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_member552266]

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.