Need help with understanding Data resource in UI building

[Nadia7]

Hello all!

I am configuring 'Service desk landing page overview SNC' sub page
I need to get the logined user location name.

I need to put it for title. But now I able to get only sys_id. But I need a name of this location. 

Is there any way to get the location name here? I don't understand what is preferences here - sow.home.overview.mode

Thank you in advance for any advice!

[Brad Tilton · Accepted solution]

Hi Nadia,

The Look up user preferences data resource is a composite data resource consisting of:

• GlideDomain Current User Preferences Query GraphQL data resource - This DR pulls info about the logged in user as well as any additional preferences that are specified in the preferences property.
• GlideDomain Query Preferences Scriptlet Scriptlet data resource - This DR takes the results of the GQL query and formats them into something more easily usable in UIB.

I think you have a couple of options here:

1. Add an additional Look up record data resource to the page that takes the sys_id of the location and pulls the name.
2. Modify the two data resources above so you're also pulling the location name in addition to the ID.
3. Create your own data resource that does the same thing as the composite while also pulling the location name. 

The first is probably the easiest way to go as you're not modifying any data resources, but it might be slightly less performant since you're adding another query. If you don't want to go with the first option I would go with the third.

[Nadia7]

Thank you for your clarification.

Maybe, you may help me with this script also?
I created an additional Look-up record data resource that pulls the name of the location.

I need to combine this location with some text in the header of the data visualization. But am not able to do it.

[Nadia7]

I have found the mistake in the script. Should be:

function evaluateProperty({
    api,
    helpers
}) {
    var locationName = api.data.look_up_location.results[0]._row_data.displayValue;
    var titleScore = " User Project - NO CI";
    return locationName + titleScore;
}

[IronPotato]

Hi @Brad Tilton ,

I know this is old post, but is it possible to somehow create blog or make You and I build video about COMPOSITE DRs? I'm trying to implement GRAPHQL and Scriptlet combination to optimize performance but I have no luck of getting the data from Composite DR. Since there's no documentation whatsoever regarding Data Drivers field and it's properties and how to actually combine 2 other DR's. It would really help if there would be one.

Thank You