search from dimension value

(0) Share

Report

Posted on by mohammed.mqi

2,050

Greetings everyone

i have table name PayrollExpencesTrans and it relation with DimensionAttributeValueCombination

and i want search about Partial from the dimension value from PayrollExpencesTrans table

i want search about this value (M09001)

so i did like this

select firstOnly  payrollExpencesTrans
            where dimensionAttributeValueCombination.DisplayValue like "*" this.text() "*"
            exists join dimensionAttributeValueCombination where payrollExpencesTrans.LedgerDimension==dimensionAttributeValueCombination.RecId;

but still give me nothing

any idea how can i solve this problem

All responses (1)

Answers (0)

Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report
RE: search from dimension value

Hi mohammed,

You can use DimensionAttricuteLevelValueAllView instead and query based on ValueCombinationRecId -

select firstOnly payrollExpencesTrans join dimensionAttributeLevelValueAllView where dimensionAttributeLevelValueAllView.ValueCombinationRecId == payrollExpencesTrans.LedgerDimension where dimensionAttributeLevelValueAllView.DisplayValue == this.text();