Filter identifier attribute in aggregate

Hi,


I'm having trouble with the filter functionality.

Basically i'm trying to do filtering for all fields shown in my employee list table.


It seems like i cannot do filter for a foreign key attribute or is there something i'm missing?

Please help.


Thank you.

Solution

Hi Deddy,


to filter by identifier use follow this example:


hr_employment.EmploymentStatusId =  integertoidentifier(texttointeger(searchKeyword))


because is not allow use (like) to search identifier attributes.


Regards.

Solution

Agno Silveira wrote:

Hi Deddy,


to filter by identifier use follow this example:


hr_employment.EmploymentStatusId =  integertoidentifier(texttointeger(searchKeyword))


because is not allow use (like) to search identifier attributes.


Regards.

 

Hi Agno,


Oohh.. i see. So i'll need to convert the data type first and i'll not be able to just partial search the keywords for identifier.


Thanks for your help.

 

Deddy Ariesandy Feryanto wrote:

Agno Silveira wrote:

Hi Deddy,


to filter by identifier use follow this example:


hr_employment.EmploymentStatusId =  integertoidentifier(texttointeger(searchKeyword))


because is not allow use (like) to search identifier attributes.


Regards.

 

Hi Agno,


Oohh.. i see. So i'll need to convert the data type first and i'll not be able to just partial search the keywords for identifier.


Thanks for your help.

 

 I am happy to help you.

Cheers.