Automic Workload Automation

Hi,
How do I to count (select count AH_NAME) only the 'main jobf', for example, JOBF.TEST without counting the same jobf that has only change file name after transfer?
How to count?
Example:
JOBF.TEST
JOBF.TESTE(/SFTP/TESTE_01-09-2015.CSV)
JOBF.TESTE(/SFTP/TESTE_02-09-2015.CSV)
JOBF.TESTE(/SFTP/TESTE_03-09-2015.CSV)

I using the following select:

select count(AH_Name), AH_Name from AH where AH_OType in ('JOBS', 'JOBF') and AH_Client='0110' and to_char(AH_TimeStamp4,'yyyy-mm-dd HH24:MI:SS') between '2017-07-31 03:00:00' and '2017-08-01 02:59:59' group by AH_Name order by AH_Name

Thanks and regards,
Karina

Not sure I fully understood, but:

Since the main JOBF never has brackets in the name (guaranteed as per Automic object naming constraints), but the "child" JOBF always have, wouldn't the following additional "where" clause not suffice?

... where AH_NAME not like '%(%'

Best,
Carsten

Hi Carsten_Schmitz_7883 ,

Yes, this is my doubt.
Thank you for your answer!

Best Regards,
Karina