• State Not Answered
  • Replies 4 replies
  • Subscribers 96 subscribers
  • Views 2148 views
  • Users 0 members are here
Options
Related

Filter and Group By Is not working properly on Pending Attestation Page

Pradeep Pola
over 5 years ago

Hi Experts,

we have a requirement to display user department and user  manager pending attestations page.

So we extended  attestationcase table and we are using a template to update that field .

we are able to successfully display the values in the portal but  when we do the filter or Group by on those columns it is grouping based on user but not on uid_personhead(user manager) or uid_department (user department)

  • 0 over 5 years ago

    Hi,

    How are you defining these values on the web form? If you are using grid columns, you can define grouping/sorting settings on the column.

    Hanno

  • 0 over 5 years ago in reply to Hanno Bunjes

    Hi Hanno,

    Me and Pradeep are from the same team.

    We have added two columns (Manager, Department) into AttestationCase Gridband. both the values are picked from PropertyInfo3 and PropertyInfo4 which is configured in the Manager. The values in these two columns are displaying fine in the portal. I can also use the filter on these columns and get some results based on the Filtered text.

    The issue here is I am not getting all the results. After enabling the Trace log on the portal, I can see the below query triggered which is limiting the filter to 200 rows only.

    -----

    select * from (select UID_AttestationCase from AttestationCase where (UID_AttestationCase in ( select UID_AttestationCase from AttestationCase acc left outer join (select m.entrykey, m.EntryValue from dialogmultilanguage m where ((m.UID_DialogColumn in ( select c.UID_DialogColumn from QBMColumnTranslation join DialogColumn c on c.XObjectKey = QBMColumnTranslation.ObjectKeyDialogColumnSource where uid_dialogcolumntarget = 'ATT-DEAFE9A3523D4CE4A849FDADCB9BE0CD')) or (m.uid_dialogColumn = 'ATT-DEAFE9A3523D4CE4A849FDADCB9BE0CD')) and m.UID_DialogCulture in ('QBM-CULT-en-US')) x on x.entrykey = acc.PropertyInfo3 where isnull( x.EntryValue, acc.PropertyInfo3) like N'%T03%'))) as x ORDER BY (select null) OFFSET 0 ROWS FETCH NEXT 200 ROWS ONLY
    ------
    Can you help how can I get rid of this limitation? Another things to notice is, the Group by function shows exact number of results.
  • 0 over 5 years ago in reply to ranjan.mishra

    Hi,

    What does the grid show? The default pagination setting is not 200, but it looks like it's paging the first 200 items.

    The grid does not support unlimited selection in database mode.

  • 0 over 5 years ago in reply to Hanno Bunjes

    HI Hanno,

    The Attestation GRID shows the attestation cases with two added column 'Manager' and 'Department' (added from Manager tool). It shows all teh data perfectly and also the Filter works on all items on rest other columns than the 'Manager' and 'Department'. For the Display and other columns I can use the filter on all.