1 Topic by thezimguy (edited by thezimguy 2019-02-11 13:23:33)

  • Registered: 2018-07-19
  • Posts: 260

Topic: Calculated Field with count causing problems

Please find attached a sample project to demonstrate the problem I'm facing with the calculated Field with aggregate 'count'.
tableGrid not listing all rows when the aggregate function COUNT is used in the calculated Field.
Any help?

Regards

Post's attachments

Attachment icon calculatedCount.zip 3.98 kb, 284 downloads since 2019-02-11 

@thezimguy

thezimguy's Website

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,681

Re: Calculated Field with count causing problems

Try using
(select count(*) from tbdata)
Please see attached.
Derek.

Post's attachments

Attachment icon calculatedcount.zip 336.33 kb, 347 downloads since 2019-02-11 

  • Registered: 2018-07-19
  • Posts: 260

Re: Calculated Field with count causing problems

(select count(*) from tbdata where items LIKE {edit1})

Please why is the above code not working in calculated Field. What is the right way.
Thank you in advance.

@thezimguy

thezimguy's Website

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Calculated Field with count causing problems

You can't use {edit1} in calculated field.

Dmitry.
  • Registered: 2018-07-19
  • Posts: 260

Re: Calculated Field with count causing problems

Thank you boss

@thezimguy

thezimguy's Website