Finance | Project Operations, Human Resources, ...

Create custom filtrable field with default dimension string value

(0) Share

Report

Posted on by Awaxx

229

Hi all,

Is there a way to create a field for CustTrans form based on CustTrans.defaultdimension to display the string value of this one ?

This field must be filtrable so display method doesn’t work here and we can’t use defaultDimensionView because new standard method don’t work with it.

Thank you.

I have the same question (0)

All responses (26)

Answers (0)

Awaxx 229 on at

Like (0)

Report

Need help please.

Was this reply helpful? Yes No
Raj Borad 1,417 on at

Like (0)

Report

Hi User,

You need to create a string field and push the value of dimension value in the insert method and update method of the CustTrans Table for upcoming transactions.

For previous ones, you have to create a job to update that field with the value of dimension value.

Thank you,

Raj D Borad

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Hi Raj,

Could you explain exactly what should i do please ?

Thanks.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Could i had those table to form datasource and join them to get display value ?

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Yes your understanding is correct. You need to join them via formdatasource like you said or through a view as a datasource.

First make sure what you actually want to show. Let's say some name using the default dimension recid. So for the existing records of customer transaction, go to ssms and check that value. Here you will get one query to fetch the name. Using the same query create a view as it may contain more than 1 table and add it as a datasource to the form.

This way you can achieve it.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Problem as i said on the post i could not use views as datasource because of a deprecated method, before i was using defaultdimensionview as datasource but still 10.0.37 i can't.

The new standard method :

custTrans_DS.positionToRecordByValue(fieldnum(CustTrans,RecId), int642Str(custTransOriginator.RecId));

don't accept views as form datasource.

Was this reply helpful? Yes No
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Are you facing some error when using view as a datasource? Can you send the error here?

If you are not able to add a view then you can use tables as a datasource. Both does the same thing.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report
Hi Bharani,

Yes i've got an error saying : ‘Unsupported data source used for PositionToRecord or PositionToRecordByValue. Unable to execute fallback logic to find record’.

I was first using defaultDimensionView as datasource and used initialized event to get the value :

FormRun formRun = sender.formRun(); FormDataSource DefaultDimensionView_ds = formRun.dataSource(formDataSourceStr(CustOpenTrans, )); DefaultDimensionView_ds.queryBuildDataSource().addLink(fieldnum(CustTrans, DefaultDimension), fieldnum(DefaultDimensionView, defaultdimension)); DefaultDimensionView_ds.queryBuildDataSource().addRange((fieldnum(DefaultDimensionView, Name))).value(sysquery::value(GLDimensionAttributeconstants::newDepartmentsDimension));

And i used some property on this form datasource view to link CustTrans datasource.

When i made some reasearch on the error, it appear that the new method i showed yesterday don't use views.

Was this reply helpful? Yes No
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

But can you tell us why you still need some custom code to populate values like you said this?

used initialized event to get the value :

Why do you require this initialised event? You can add a datasource normally with a linktype set right?

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report

Maybe i didn't understand how to this correctly.

I think i was doing that to add the dimensionattribute filter value.

Could you explain me how i could reach that step by step please ?

Was this reply helpful? Yes No