Custom Datasets

karlg over 7 years ago

I am trying to create a custom "local!" dataset within a "with" scope.

In my case I have for example a local!datsubSet like this :

local!datasubSet: a!queryEntity(
entity: cons!entity,
query: a!query(
selection: a!querySelection(columns: {
a!queryColumn(field: "A"),
a!queryColumn(field: "B"),
a!queryColumn(field: "C"),
}),
logicalExpression: local!logicalExpression,
pagingInfo: local!pagingInfo
)
)

Now this dataset is shown in a grid. I would like to add additional data displayed in the grid without changing the entity structure being queried. Let's say I want to add a column "D" and I already have an array for it that is local!Dvalues in the with scope.

How can I create a 4th column in the local!datasubset with the name "D" that will have as values local!Dvalues.

Is this possible? I tried with merge() and a!datasub...

Discussion posts and replies are publicly visible

Parents

0 brettf over 7 years ago

You should be able to specify the data directly on the grid. Instead of setting the data to local!datasubSet.data.field, instead call the local!Dvalues. There are two caveats to this though:

1) local!Dvalues should have the same length as your datasubset, or this can cause some problems
2) Sorting will not work very well with this

If you want to have your data line up properly with a sort, then you would most likely have to create a view to query instead, or have some complex logic to sort your local!Dvalues in the appropriate order.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 brettf over 7 years ago

You should be able to specify the data directly on the grid. Instead of setting the data to local!datasubSet.data.field, instead call the local!Dvalues. There are two caveats to this though:

1) local!Dvalues should have the same length as your datasubset, or this can cause some problems
2) Sorting will not work very well with this

If you want to have your data line up properly with a sort, then you would most likely have to create a view to query instead, or have some complex logic to sort your local!Dvalues in the appropriate order.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data