23
Views
2
Comments
Solved
Filter

Hi Guys,

What filter should I apply here?

HashTable.oml
2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello @Rohan Roy 

Please check if this will help - 

Check this Example

Edit - https://personal-ejuytnht.outsystemscloud.com/Filter_Sample_Oml/Screen1?_ts=637921210141483024

I have also attached the oml

I hope this will work 

Thanks

Tousif Khan

Filter_Sample_Oml.oml
2021-05-18 02-27-17
Manish Gupta
Champion
Solution

Hello Rohan

It looks you are saving the Key Value (that I assume is reminder of MOD) as ID. This is not a good practice as in future two students may result to the same mod like 2 mod 10, 22 mod 10 that time your data will show error while creating in database. 

So, you need to keep ID as auto number and save keyvalue in another attribute. 

Later on the condition will be filtered as -

keyvalue = NullIdentifier() or keyvalue = searchkeyvalue

As we do not have like operator for Integers


If still you want to keep the ID as KeyValue then use the below filter - 

HashTable1.Id = NullIdentifier() or HashTable1.Id = keyvalue 

2023-10-21 19-42-11
Tousif Khan
Champion
Solution

Hello @Rohan Roy 

Please check if this will help - 

Check this Example

Edit - https://personal-ejuytnht.outsystemscloud.com/Filter_Sample_Oml/Screen1?_ts=637921210141483024

I have also attached the oml

I hope this will work 

Thanks

Tousif Khan

Filter_Sample_Oml.oml
2021-05-18 02-27-17
Manish Gupta
Champion
Solution

Hello Rohan

It looks you are saving the Key Value (that I assume is reminder of MOD) as ID. This is not a good practice as in future two students may result to the same mod like 2 mod 10, 22 mod 10 that time your data will show error while creating in database. 

So, you need to keep ID as auto number and save keyvalue in another attribute. 

Later on the condition will be filtered as -

keyvalue = NullIdentifier() or keyvalue = searchkeyvalue

As we do not have like operator for Integers


If still you want to keep the ID as KeyValue then use the below filter - 

HashTable1.Id = NullIdentifier() or HashTable1.Id = keyvalue 

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.