Hello everyone,

I'm asking about how to adjust the location drilldown to display locations based on the chosen classification, so for example if i chose classification (Plumbing) and then i choose water issue as a sub category, i get locations based on the category not the sub category. 

I think i can summarize my question in the following "Can i capture from the srmobile the chosen parnet classification (first level) so later i can display locations with a query based on this classification in the form "

Thanks in advance!

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

Dear @Steve Lee,

That's exactly what am trying to do and have an issue with, How to capture the current selected category on a ticket on the srmobile that is not submitted yet and based on this selected category on the issue/request a specific locations appear based on a filter (Query Definition) on the MXAPIOPERLOC.

Thanks for forwarding this issue to the mobile team, Your help means a lot as this is a critical request that we need to achieve.

BR

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

Dear @Steve Lee,

Adding to the above my case now is that i don't know how to query or capture from the MXAPIOPERLOC (Locations) object the structure the current classstructureid of the ticket so later based on the classification of the ticket from example the same locations with the same classstructure appear only

BR

Dear @Steve Lee,

That's exactly what am trying to do and have an issue with, How to capture the current selected category on a ticket on the srmobile that is not submitted yet and based on this selected category on the issue/request a specific locations appear based on a filter (Query Definition) on the MXAPIOPERLOC.

Thanks for forwarding this issue to the mobile team, Your help means a lot as this is a critical request that we need to achieve.

BR

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

Dear @Steve Lee,

I hope you are doing well,

I was wondering if you came across any possible way regarding filtering the locations based on the chosen classification on SRMOBILE,

Thanks in advance.

Dear @Steve Lee,

Adding to the above my case now is that i don't know how to query or capture from the MXAPIOPERLOC (Locations) object the structure the current classstructureid of the ticket so later based on the classification of the ticket from example the same locations with the same classstructure appear only

BR

Dear @Steve Lee,

That's exactly what am trying to do and have an issue with, How to capture the current selected category on a ticket on the srmobile that is not submitted yet and based on this selected category on the issue/request a specific locations appear based on a filter (Query Definition) on the MXAPIOPERLOC.

Thanks for forwarding this issue to the mobile team, Your help means a lot as this is a critical request that we need to achieve.

BR

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

I did get a response from the development team with a suggestion but I have tried this and still not got this working - I will chase again and see if I can make any further progress

Dear @Steve Lee,

I hope you are doing well,

I was wondering if you came across any possible way regarding filtering the locations based on the chosen classification on SRMOBILE,

Thanks in advance.

Dear @Steve Lee,

Adding to the above my case now is that i don't know how to query or capture from the MXAPIOPERLOC (Locations) object the structure the current classstructureid of the ticket so later based on the classification of the ticket from example the same locations with the same classstructure appear only

BR

Dear @Steve Lee,

That's exactly what am trying to do and have an issue with, How to capture the current selected category on a ticket on the srmobile that is not submitted yet and based on this selected category on the issue/request a specific locations appear based on a filter (Query Definition) on the MXAPIOPERLOC.

Thanks for forwarding this issue to the mobile team, Your help means a lot as this is a critical request that we need to achieve.

BR

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

Thanks a lot for your time and effort, i really do appreciate it 

I did get a response from the development team with a suggestion but I have tried this and still not got this working - I will chase again and see if I can make any further progress

Dear @Steve Lee,

I hope you are doing well,

I was wondering if you came across any possible way regarding filtering the locations based on the chosen classification on SRMOBILE,

Thanks in advance.

Dear @Steve Lee,

Adding to the above my case now is that i don't know how to query or capture from the MXAPIOPERLOC (Locations) object the structure the current classstructureid of the ticket so later based on the classification of the ticket from example the same locations with the same classstructure appear only

BR

Dear @Steve Lee,

That's exactly what am trying to do and have an issue with, How to capture the current selected category on a ticket on the srmobile that is not submitted yet and based on this selected category on the issue/request a specific locations appear based on a filter (Query Definition) on the MXAPIOPERLOC.

Thanks for forwarding this issue to the mobile team, Your help means a lot as this is a critical request that we need to achieve.

BR

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.

So after some testing I can get this working on the Location Search so it only returns locations that have the same classification as selected on the SR. The Location Hierarchy DrillDown will not work with this filter as it always looks at each level starting at the top level locations e.g. where location.parent is null and these would not all have the same classification.

To get the location search to work in this way you need to add the following 3 changes:

1) The first change is to run the following sql statement against the database because by default the objectstructure excludes the CLASSSTRUCTUREID from the object so we need to have it included to use it in our query:

delete from MAXINTOBJCOLS where INTOBJECTNAME='MXAPIOPERLOC' and objectname='LOCATIONS' and name='CLASSSTRUCTUREID'

2) search for the following: <maximo-datasource-override id="locationFilterDS" and the where clause as per below:

Thanks a lot for your time and effort, i really do appreciate it 

I did get a response from the development team with a suggestion but I have tried this and still not got this working - I will chase again and see if I can make any further progress

Dear @Steve Lee,

I hope you are doing well,

I was wondering if you came across any possible way regarding filtering the locations based on the chosen classification on SRMOBILE,

Thanks in advance.

Dear @Steve Lee,

Adding to the above my case now is that i don't know how to query or capture from the MXAPIOPERLOC (Locations) object the structure the current classstructureid of the ticket so later based on the classification of the ticket from example the same locations with the same classstructure appear only

BR

Dear @Steve Lee,

That's exactly what am trying to do and have an issue with, How to capture the current selected category on a ticket on the srmobile that is not submitted yet and based on this selected category on the issue/request a specific locations appear based on a filter (Query Definition) on the MXAPIOPERLOC.

Thanks for forwarding this issue to the mobile team, Your help means a lot as this is a critical request that we need to achieve.

BR

OK so I think I now understand - the SRMOBILE application out of the box uses a data query called 

Dear Steve,

Thank you for your response. Yes, the classification I choose initially represents the category of the issue/request. Here's what I want to achieve:

For example, if the user selects Plumbing as the category of the issue/request, the location drilldown should display only the locations that match a specific query I've set on the locations object, rather than showing all locations.

Essentially, if the user selects category A for the issue/request, only locations with the loctype attribute set to C should appear. Similarly, if they choose category B, only locations with loctype set to E should be displayed.