Skip to main content
Solved

ETM, Matching Record Count

  • Sep 30, 2026 1:15 PM UTC
  • 2 replies
  • 24 views

askey-s
Sidekick (Customer)
Forum|alt.badge.img+6

Hi

Within an ETM datamapper, is it possible to have returned the number of records that are found when a variable assyst search or record selection is done into a variable, please?

I need to know how many active item relation records there are against an item so that I can set a flag on the item record.

Thanks

Best answer by Paul McCulloch

if I have a variable assyst search name ‘items’ then I can reference the items found in a subsequent field as variables.items. This is a JS array - so you can use  variables.items.length to find out how many matching items were found.

View original

2 replies

Forum|alt.badge.img+12
  • Hero (Employee)
  • Answer
  • Sep 30, 2026 1:19 PM UTC

if I have a variable assyst search name ‘items’ then I can reference the items found in a subsequent field as variables.items. This is a JS array - so you can use  variables.items.length to find out how many matching items were found.


askey-s
Sidekick (Customer)
Forum|alt.badge.img+6
  • Author
  • Sidekick (Customer)
  • Sep 30, 2026 1:32 PM UTC

Hi Paul

Yes, of course!  Thank you.  I’ve tried and have something to work with now.

Many thanks

Steven